Course programme
A Quick Introduction to the Basics of Excel
3 lectures 22:44
The Ribbon Commands preview The ribbon includes various tabs when Excel is opened such as Home, Insert, Page Layout, Formulas, Data, Review, View, and Help, the area below the ribbon displays a set of groups and, within the groups, buttons representing a variety of commands. In this lesson, we will understand the terminology and elements of the Ribbon.
The Work Surface - Workbook and Worksheets
Recognize the mains terms used to describe Excel's Canvas.
Navigation Tools with 100+ Keyboard Shortcuts
Navigating the Excel Interface by utilize the keyboard or mouse to select cells and ranges in a spreadsheet & learn useful Keyboard Shortcuts saves lots of time in Excel.
A Quick Introduction to the Basics of Excel
3 lectures 22:44
The Ribbon Commands preview The ribbon includes various tabs when Excel is opened such as Home, Insert, Page Layout, Formulas, Data, Review, View, and Help, the area below the ribbon displays a set of groups and, within the groups, buttons representing a variety of commands. In this lesson, we will understand the terminology and elements of the Ribbon.
The Work Surface - Workbook and Worksheets
Recognize the mains terms used to describe Excel's Canvas.
Navigation Tools with 100+ Keyboard Shortcuts
Navigating the Excel Interface by utilize the keyboard or mouse to select cells and ranges in a spreadsheet & learn useful Keyboard Shortcuts saves lots of time in Excel.
The Ribbon Commands preview The ribbon includes various tabs when Excel is opened such as Home, Insert, Page Layout, Formulas, Data, Review, View, and Help, the area below the ribbon displays a set of groups and, within the groups, buttons representing a variety of commands. In this lesson, we will understand the terminology and elements of the Ribbon.
The Ribbon Commands preview The ribbon includes various tabs when Excel is opened such as Home, Insert, Page Layout, Formulas, Data, Review, View, and Help, the area below the ribbon displays a set of groups and, within the groups, buttons representing a variety of commands. In this lesson, we will understand the terminology and elements of the Ribbon.
The Ribbon Commands preview The ribbon includes various tabs when Excel is opened such as Home, Insert, Page Layout, Formulas, Data, Review, View, and Help, the area below the ribbon displays a set of groups and, within the groups, buttons representing a variety of commands. In this lesson, we will understand the terminology and elements of the Ribbon.
The Ribbon Commands preview The ribbon includes various tabs when Excel is opened such as Home, Insert, Page Layout, Formulas, Data, Review, View, and Help, the area below the ribbon displays a set of groups and, within the groups, buttons representing a variety of commands. In this lesson, we will understand the terminology and elements of the Ribbon.
The ribbon includes various tabs when Excel is opened such as Home, Insert, Page Layout, Formulas, Data, Review, View, and Help, the area below the ribbon displays a set of groups and, within the groups, buttons representing a variety of commands. In this lesson, we will understand the terminology and elements of the Ribbon.
The ribbon includes various tabs when Excel is opened such as Home, Insert, Page Layout, Formulas, Data, Review, View, and Help, the area below the ribbon displays a set of groups and, within the groups, buttons representing a variety of commands. In this lesson, we will understand the terminology and elements of the Ribbon.
The Work Surface - Workbook and Worksheets
Recognize the mains terms used to describe Excel's Canvas.
The Work Surface - Workbook and Worksheets
Recognize the mains terms used to describe Excel's Canvas.
The Work Surface - Workbook and Worksheets
Recognize the mains terms used to describe Excel's Canvas.
The Work Surface - Workbook and Worksheets
Recognize the mains terms used to describe Excel's Canvas.
Recognize the mains terms used to describe Excel's Canvas.
Recognize the mains terms used to describe Excel's Canvas.
Navigation Tools with 100+ Keyboard Shortcuts
Navigating the Excel Interface by utilize the keyboard or mouse to select cells and ranges in a spreadsheet & learn useful Keyboard Shortcuts saves lots of time in Excel.
Navigation Tools with 100+ Keyboard Shortcuts
Navigating the Excel Interface by utilize the keyboard or mouse to select cells and ranges in a spreadsheet & learn useful Keyboard Shortcuts saves lots of time in Excel.
Navigation Tools with 100+ Keyboard Shortcuts
Navigating the Excel Interface by utilize the keyboard or mouse to select cells and ranges in a spreadsheet & learn useful Keyboard Shortcuts saves lots of time in Excel.
Navigation Tools with 100+ Keyboard Shortcuts
Navigating the Excel Interface by utilize the keyboard or mouse to select cells and ranges in a spreadsheet & learn useful Keyboard Shortcuts saves lots of time in Excel.
Navigating the Excel Interface by utilize the keyboard or mouse to select cells and ranges in a spreadsheet & learn useful Keyboard Shortcuts saves lots of time in Excel.
Navigating the Excel Interface by utilize the keyboard or mouse to select cells and ranges in a spreadsheet & learn useful Keyboard Shortcuts saves lots of time in Excel.
Getting to Know Excel
5 lectures 29:54
Creation of First Excel File
In this lesson we will start a new file from scratch and create First excel file by entering data and create a table.
Formatting
Making information look more attractive in Excel and Format cells by selecting fonts and color fills.
Work with Alignment and Wrap text
This guide will show you how to use the alignment tool as well as the Wrap Text tool to create a well-formatted spreadsheet.
Hiding and unhiding rows and columns
If you are dealing with a data-heavy spreadsheet, sometimes we don't want to see all the information and need to hide or unhide rows and columns to better see the information. Fortunately, Excel makes it easy to do this.
Basic Math
In this lesson, we will work with basic mathematics in Excel and utilize the mathematics including multiplication and division in Excel.
Getting to Know Excel
5 lectures 29:54
Creation of First Excel File
In this lesson we will start a new file from scratch and create First excel file by entering data and create a table.
Formatting
Making information look more attractive in Excel and Format cells by selecting fonts and color fills.
Work with Alignment and Wrap text
This guide will show you how to use the alignment tool as well as the Wrap Text tool to create a well-formatted spreadsheet.
Hiding and unhiding rows and columns
If you are dealing with a data-heavy spreadsheet, sometimes we don't want to see all the information and need to hide or unhide rows and columns to better see the information. Fortunately, Excel makes it easy to do this.
Basic Math
In this lesson, we will work with basic mathematics in Excel and utilize the mathematics including multiplication and division in Excel.
Creation of First Excel File
In this lesson we will start a new file from scratch and create First excel file by entering data and create a table.
Creation of First Excel File
In this lesson we will start a new file from scratch and create First excel file by entering data and create a table.
Creation of First Excel File
In this lesson we will start a new file from scratch and create First excel file by entering data and create a table.
Creation of First Excel File
In this lesson we will start a new file from scratch and create First excel file by entering data and create a table.
In this lesson we will start a new file from scratch and create First excel file by entering data and create a table.
In this lesson we will start a new file from scratch and create First excel file by entering data and create a table.
Formatting
Making information look more attractive in Excel and Format cells by selecting fonts and color fills.
Formatting
Making information look more attractive in Excel and Format cells by selecting fonts and color fills.
Formatting
Making information look more attractive in Excel and Format cells by selecting fonts and color fills.
Formatting
Making information look more attractive in Excel and Format cells by selecting fonts and color fills.
Making information look more attractive in Excel and Format cells by selecting fonts and color fills.
Making information look more attractive in Excel and Format cells by selecting fonts and color fills.
Work with Alignment and Wrap text
This guide will show you how to use the alignment tool as well as the Wrap Text tool to create a well-formatted spreadsheet.
Work with Alignment and Wrap text
This guide will show you how to use the alignment tool as well as the Wrap Text tool to create a well-formatted spreadsheet.
Work with Alignment and Wrap text
This guide will show you how to use the alignment tool as well as the Wrap Text tool to create a well-formatted spreadsheet.
Work with Alignment and Wrap text
This guide will show you how to use the alignment tool as well as the Wrap Text tool to create a well-formatted spreadsheet.
This guide will show you how to use the alignment tool as well as the Wrap Text tool to create a well-formatted spreadsheet.
This guide will show you how to use the alignment tool as well as the Wrap Text tool to create a well-formatted spreadsheet.
Hiding and unhiding rows and columns
If you are dealing with a data-heavy spreadsheet, sometimes we don't want to see all the information and need to hide or unhide rows and columns to better see the information. Fortunately, Excel makes it easy to do this.
Hiding and unhiding rows and columns
If you are dealing with a data-heavy spreadsheet, sometimes we don't want to see all the information and need to hide or unhide rows and columns to better see the information. Fortunately, Excel makes it easy to do this.
Hiding and unhiding rows and columns
If you are dealing with a data-heavy spreadsheet, sometimes we don't want to see all the information and need to hide or unhide rows and columns to better see the information. Fortunately, Excel makes it easy to do this.
Hiding and unhiding rows and columns
If you are dealing with a data-heavy spreadsheet, sometimes we don't want to see all the information and need to hide or unhide rows and columns to better see the information. Fortunately, Excel makes it easy to do this.
If you are dealing with a data-heavy spreadsheet, sometimes we don't want to see all the information and need to hide or unhide rows and columns to better see the information. Fortunately, Excel makes it easy to do this.
If you are dealing with a data-heavy spreadsheet, sometimes we don't want to see all the information and need to hide or unhide rows and columns to better see the information. Fortunately, Excel makes it easy to do this.
Basic Math
In this lesson, we will work with basic mathematics in Excel and utilize the mathematics including multiplication and division in Excel.
Basic Math
In this lesson, we will work with basic mathematics in Excel and utilize the mathematics including multiplication and division in Excel.
Basic Math
In this lesson, we will work with basic mathematics in Excel and utilize the mathematics including multiplication and division in Excel.
Basic Math
In this lesson, we will work with basic mathematics in Excel and utilize the mathematics including multiplication and division in Excel.
In this lesson, we will work with basic mathematics in Excel and utilize the mathematics including multiplication and division in Excel.
In this lesson, we will work with basic mathematics in Excel and utilize the mathematics including multiplication and division in Excel.
Essential Formula Knowledge
8 lectures 01:22:08
Formula Syntax
In this lesson, we will learn the anatomy of Excel formulas and understand how to build them.
Cell Referencing
Learn about working with absolute & relative cell referencing and techniques for copying formulas to ensure that formulas are targeted at the intended cells when you copy them from one location to another.
Function Syntax
Use to understand the Anatomy of Excel functions and what their components stands for.
Math Functions
Learn Basic math functions such as SUM, ROUND and SUBTOTAL.
Statistical Functions
Learn Basic Statistical functions i.e. COUNT, COUNTA, AVERAGE, MAX, MIN, MEDIAN and MODE.
Logic Functions
Learn how to build Excel's logical functions such as IF, AND, OR and make them more complex by nesting AND and OR within them.
Text Functions
Excel has many functions to offer when it comes to manipulating text strings. In this lesson, we will learn to break apart text with the LEFT, RIGHT, MID, FIND and SEARCH Functions and to combine text with the & character.
Understanding Dates & Time
Learn to use date and time functions in order to display today's date and current time while using the Excel. Understand how time works in excel, how to change from whole numbers into time and increments and back again.
Essential Formula Knowledge ormula Auditing Tools including tracing precedent and dependent cells and formula evaluation.
Formula Auditing...