Videos Learn with Our Expert Trainers
In this video, you will learn about three ways to add numbers in Excel Online.
The video covers selecting a set of numbers in rows or columns and using the AutoSum function to calculate totals.
It also demonstrates how to use the SUM function to add numbers in a sequence or range, including cells with text or blank cells.
These techniques will help you efficiently calculate totals and analyze data in Excel Online.
The video covers selecting a set of numbers in rows or columns and using the AutoSum function to calculate totals.
It also demonstrates how to use the SUM function to add numbers in a sequence or range, including cells with text or blank cells.
These techniques will help you efficiently calculate totals and analyze data in Excel Online.
- 3:15
- 5027 views
In this video, you will learn about copying formulas in Microsoft Excel.
The video covers how to copy a formula down a column to add pairs of cells.
It demonstrates how to use the black plus sign in the bottom right-hand corner of a cell to copy the formula into other cells.
The video also explains the concept of relative cell references, which is the default in Excel.
However, it shows that sometimes you may want to use absolute cell references to prevent the references from changing when you copy a formula.
By using the dollar sign before the column and row references, you can make a cell reference absolute.
This will help you understand how to copy formulas accurately and efficiently in Excel.
The video covers how to copy a formula down a column to add pairs of cells.
It demonstrates how to use the black plus sign in the bottom right-hand corner of a cell to copy the formula into other cells.
The video also explains the concept of relative cell references, which is the default in Excel.
However, it shows that sometimes you may want to use absolute cell references to prevent the references from changing when you copy a formula.
By using the dollar sign before the column and row references, you can make a cell reference absolute.
This will help you understand how to copy formulas accurately and efficiently in Excel.
- 3:00
- 4274 views
In this video, you will learn about Autofill and Flash Fill in Excel.
The video covers how to use Autofill to automatically fill in repetitive information, such as dates, by dragging the black plus sign.
It also demonstrates how to use Flash Fill to format data, like correcting a list of names, by typing the desired format and letting Excel provide a preview.
These features are tremendous timesavers and can do much more than what is covered in this introduction.
Mastering Autofill and Flash Fill will enhance your productivity in Excel.
The video covers how to use Autofill to automatically fill in repetitive information, such as dates, by dragging the black plus sign.
It also demonstrates how to use Flash Fill to format data, like correcting a list of names, by typing the desired format and letting Excel provide a preview.
These features are tremendous timesavers and can do much more than what is covered in this introduction.
Mastering Autofill and Flash Fill will enhance your productivity in Excel.
- 1:36
- 3790 views
In this video, you will learn about how to search and find what you need using Microsoft 365. The video covers the usage of OneDrive, Yammer, and Delve in the Office 365 subscription to help you access and organize your documents, collaborate with colleagues, and discover relevant information.
This tutorial will enhance your productivity and efficiency in finding and managing your files.
This tutorial will enhance your productivity and efficiency in finding and managing your files.
- 3:58
- 4137 views
In this video, you will learn how to insert headers and footers in Microsoft 365. Headers and footers are useful for adding information like file paths and page numbers to your worksheets when printing.
The video demonstrates how to add headers and footers in Page Layout view, either by using the header and footer tools or by typing directly into the sections.
This skill will help you enhance the appearance and organization of your printed worksheets.
The video demonstrates how to add headers and footers in Page Layout view, either by using the header and footer tools or by typing directly into the sections.
This skill will help you enhance the appearance and organization of your printed worksheets.
- 2:02
- 4062 views
In this video, you will learn about adding header and footer details in Microsoft 365. The video covers the steps to add header and footer details in Office apps like Word, Excel, and PowerPoint.
This feature allows you to customize the top and bottom sections of your documents, spreadsheets, and presentations.
Adding header and footer details can enhance the professional look of your files and provide important information such as page numbers, document titles, and dates.
This will help you create visually appealing and well-organized documents using Microsoft 365.
This feature allows you to customize the top and bottom sections of your documents, spreadsheets, and presentations.
Adding header and footer details can enhance the professional look of your files and provide important information such as page numbers, document titles, and dates.
This will help you create visually appealing and well-organized documents using Microsoft 365.
- 3:41
- 4003 views
In this video, you will learn about sorting and filtering data in Microsoft Excel.
The video covers how to change the order of your data by sorting it and how to filter a range of cells or a table to focus on specific data.
This will help you analyze and organize your data more effectively.
The video covers how to change the order of your data by sorting it and how to filter a range of cells or a table to focus on specific data.
This will help you analyze and organize your data more effectively.
- 1:38
- 3551 views
In this video, you will learn about sorting details in Microsoft 365. The video covers how to efficiently sort and organize your documents and information using the intelligent search feature in Microsoft 365. This will help you save time and improve your productivity by easily finding the documents and information you need.
- 4:46
- 3985 views
In this video, you will learn about AutoFilter details in Microsoft 365. The video covers how to filter data by unchecking and checking values, filtering for blank cells, using criteria to filter, applying AutoFilter to multiple columns, and auditing filters by cell and font color.
This will help you effectively filter and analyze data in Excel.
This will help you effectively filter and analyze data in Excel.
- 3:27
- 4048 views
In this video, you will learn about advanced filter details in Microsoft 365. The video covers how to use advanced filters to refine your search and find specific documents or information in the Microsoft 365 environment.
This will help you save time and improve efficiency in your searches.
This will help you save time and improve efficiency in your searches.
- 4:13
- 4094 views
In this video, you will learn about drop-down lists in Microsoft 365. The video covers how to create drop-down lists in Excel to limit the entries people can make in a cell.
By selecting the cell, a drop-down list arrow appears, allowing you to make a selection.
To create drop-down lists, you need to select the cells, go to the Data tab on the ribbon, click Data Validation, set Allow to list, enter the text or numbers in the Source field, and click OK.
Using drop-down lists can help improve data entry accuracy and efficiency.
This tutorial will guide you through the process of creating drop-down lists in Excel, enhancing your data management skills.
By selecting the cell, a drop-down list arrow appears, allowing you to make a selection.
To create drop-down lists, you need to select the cells, go to the Data tab on the ribbon, click Data Validation, set Allow to list, enter the text or numbers in the Source field, and click OK.
Using drop-down lists can help improve data entry accuracy and efficiency.
This tutorial will guide you through the process of creating drop-down lists in Excel, enhancing your data management skills.
- 0:55
- 3601 views