Videos Learn with Our Expert Trainers
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
- 4282 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
- 4277 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
- 3792 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
- 4265 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
- 3633 views
In this video, you will learn about the new content available on the MOOC Office 365 website.
The video covers the latest updates, including virtual classes on Microsoft To Do and new tutorials on Microsoft Edge Chromium.
You will discover how to effectively organize your tasks with Microsoft To Do, sync your apps, manage priorities, and create project-related lists.
Additionally, there are 10 new tutorials on Microsoft Edge, focusing on its latest features.
This content will help you enhance your organization skills and master Microsoft Edge.
Stay updated by following Mandarine Academy on LinkedIn.
The video covers the latest updates, including virtual classes on Microsoft To Do and new tutorials on Microsoft Edge Chromium.
You will discover how to effectively organize your tasks with Microsoft To Do, sync your apps, manage priorities, and create project-related lists.
Additionally, there are 10 new tutorials on Microsoft Edge, focusing on its latest features.
This content will help you enhance your organization skills and master Microsoft Edge.
Stay updated by following Mandarine Academy on LinkedIn.
- 3:25
- 2225 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
- 4142 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
- 3556 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
- 3987 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
- 4051 views
In this video, you will learn about the course on Forms and how to use Microsoft 365 for creating forms, questionnaires, and surveys.
The video covers the process of creating forms and questionnaires, collecting and using the results, collaborating with others, and adjusting the settings.
This course will help you become proficient in using Forms and enhance your knowledge of Microsoft 365.
The video covers the process of creating forms and questionnaires, collecting and using the results, collaborating with others, and adjusting the settings.
This course will help you become proficient in using Forms and enhance your knowledge of Microsoft 365.
- 1:23
- 2670 views