Videos Learn with Our Expert Trainers
In this video, you will learn how to average a group of numbers using Microsoft 365. The video demonstrates how to use the AutoSum feature to quickly calculate averages in Excel.
By clicking the cell to the right of a row or below a column, you can access the AutoSum dropdown menu and select the Average option.
The video also explains how to verify the formula and save time when averaging a few cells.
Additionally, it covers how to average values and cells that are not adjacent by using the Average function and ignoring empty cells or those containing text.
This tutorial will help you efficiently calculate averages in Microsoft 365.
By clicking the cell to the right of a row or below a column, you can access the AutoSum dropdown menu and select the Average option.
The video also explains how to verify the formula and save time when averaging a few cells.
Additionally, it covers how to average values and cells that are not adjacent by using the Average function and ignoring empty cells or those containing text.
This tutorial will help you efficiently calculate averages in Microsoft 365.
- 2:01
- 3702 views
In this video, you will learn how to simultaneously view multiple worksheets using Microsoft 365. The video covers the steps to open and arrange multiple worksheets side by side, allowing you to compare and analyze data more efficiently.
This feature is particularly useful when working with large datasets or when you need to cross-reference information across different sheets.
By learning this skill, you will be able to boost your productivity and make better-informed decisions.
This feature is particularly useful when working with large datasets or when you need to cross-reference information across different sheets.
By learning this skill, you will be able to boost your productivity and make better-informed decisions.
- 3:25
- 4300 views
In this video, you will learn how to simultaneously edit and calculate formulas across multiple worksheets in Microsoft 365. The video covers the process of grouping worksheets, making changes that apply to all worksheets, formatting tables, and using formulas.
This tutorial will help you efficiently manage and manipulate data across multiple worksheets, saving you time and effort.
This tutorial will help you efficiently manage and manipulate data across multiple worksheets, saving you time and effort.
- 3:07
- 4336 views
In this video, you will learn about how to determine the right tool to use in collaborative work using Microsoft 365. The video covers the importance of defining your collaboration needs, identifying the different uses of Microsoft 365, and promoting change within your organization.
This will help you make informed decisions on which tools to use for effective collaboration.
This will help you make informed decisions on which tools to use for effective collaboration.
- 3:01
- 3840 views
In this video, you will learn how to create a chart using Microsoft 365. The video covers the process of selecting the cells you want to use for the chart, clicking the quick analysis button, and accessing the Charts tab.
Excel then displays recommended charts based on the selected data.
You can hover over each chart option to see which one looks best for your data.
The video demonstrates creating a clustered column chart, which is great for comparing data.
By following the steps in the video, you will be able to create eye-catching charts that make it easier to analyze your data.
This tutorial is essential for anyone using Microsoft 365 and looking to improve their data visualization skills.
Excel then displays recommended charts based on the selected data.
You can hover over each chart option to see which one looks best for your data.
The video demonstrates creating a clustered column chart, which is great for comparing data.
By following the steps in the video, you will be able to create eye-catching charts that make it easier to analyze your data.
This tutorial is essential for anyone using Microsoft 365 and looking to improve their data visualization skills.
- 0:52
- 3684 views
In this video, you will learn how to customize the items displayed on a chart using Microsoft 365. By selecting the chart, you can easily add, remove, or change elements such as the title, legend, gridlines, and data labels.
You can also adjust the size and appearance of these elements.
Additionally, you have the option to add error bars, customize the gridlines, and choose the position of the legend.
The video demonstrates how to customize a chart to your preferences, allowing you to create your own unique charts.
This knowledge will help you effectively customize charts in Microsoft 365 for your specific needs.
You can also adjust the size and appearance of these elements.
Additionally, you have the option to add error bars, customize the gridlines, and choose the position of the legend.
The video demonstrates how to customize a chart to your preferences, allowing you to create your own unique charts.
This knowledge will help you effectively customize charts in Microsoft 365 for your specific needs.
- 4:28
- 4404 views
In this video, you will learn top tips for working in Excel Online.
The video covers three ways to make your worksheet easier to read with formatting:
changing the appearance of text or numbers, aligning text, and formatting numbers.
These tips will help you improve clarity and readability in your Excel Online worksheets.
The video covers three ways to make your worksheet easier to read with formatting:
changing the appearance of text or numbers, aligning text, and formatting numbers.
These tips will help you improve clarity and readability in your Excel Online worksheets.
- 3:35
- 4375 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
- 4483 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
- 4014 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 a series of repetitive information, such as dates, by dragging the black plus sign.
It also demonstrates how to use Flash Fill to quickly format a list of names by typing the first name and letting Excel provide a preview of the formatted names.
These features are tremendous timesavers and can do much more than what is covered in this introduction.
Mastering Autofill and Flash Fill will help you save time and improve your productivity in Excel.
The video covers how to use Autofill to automatically fill in a series of repetitive information, such as dates, by dragging the black plus sign.
It also demonstrates how to use Flash Fill to quickly format a list of names by typing the first name and letting Excel provide a preview of the formatted names.
These features are tremendous timesavers and can do much more than what is covered in this introduction.
Mastering Autofill and Flash Fill will help you save time and improve your productivity in Excel.
- 2:55
- 4345 views
In this video, you will learn about Flash Fill, a feature in Microsoft 365 that automatically fills in and formats data.
The video covers how to use Flash Fill with different types of data, such as names and phone numbers.
It also demonstrates how to use unique formatting and provide additional examples to help Flash Fill understand patterns.
Additionally, the video shows how Flash Fill can be used to combine and format names, as well as split up columns of data.
This will help you efficiently manipulate and format data in Microsoft 365 using Flash Fill.
The video covers how to use Flash Fill with different types of data, such as names and phone numbers.
It also demonstrates how to use unique formatting and provide additional examples to help Flash Fill understand patterns.
Additionally, the video shows how Flash Fill can be used to combine and format names, as well as split up columns of data.
This will help you efficiently manipulate and format data in Microsoft 365 using Flash Fill.
- 2:59
- 3706 views