Module 1 :Introduction to Excel - Basic Navigation (Part 1)
Excel has to offer, these bite-sized courses have been developed to help everyone learn at their leisure. They can choose what they want to learn from mini videos that cover each subject individually.
Topic's covered :
How to create a new workbook, including an introduction to the screen layout and how to move around a spreadsheet easily
Exploring cells and how to select, clear information, delete, and insert them
Using multiple sheets to create workbooks, including naming and coloring tabs for convenience
The basics of spreadsheets, including how to save, print, and format pages for printing
Module 2 :Introduction to Excel - Basic Navigation (Part 2)
Topic's covered :
How to format cells to include numbers and/or text
Basic formatting, including text alignment, and changing font and borders
Editing column width and row height, moving cells, and copying and pasting
Exploring themes, cell styles, and learning how to fill cells easily
Module 3 :Introduction to Excel - Basic Navigation (Part 3)
Topic's covered :
Drag and drop, autofill, flash fill and autofill options
The basics of format painting, headers, footers, and page numbers
Using add-ins, templates, and page breaks
Freezing rows and columns and removing duplicates
Module 4 :Introduction to Excel - Basic Formulas
Topic's covered :
Using Functions and AutoSum
What the Insert function does
The Formula tab and how to use it
Copying Formulas
Absolute Cell References
Entering Calculations
Date & Time formulas
Module 5 :Introduction to Excel - Advanced Formulas
Topic's covered :
Using the IF functions and how to Nest IF functions
What IFERROR means (tidying N/A)
Range Names as well as IF/AND/OR functions
Concatenation
Using the Proper function
NOW and Choose functions
Module 6 :Introduction to Excel - Data Visualization
Topic's covered :
Using Excel charting and how to edit charts
Formatting, Labeling, and Filtering charts
Saving your chart as a template
Creating and using Sparklines
Module 7 :Introduction to Excel - Pivot Tables
Topic's covered :
What Pivot Tables are and what their use is
How to create Pivot Tables
How to create Pivot Charts
Module 8 :Introduction to Excel - VLOOKUP Function
Topic's covered :
What the VLOOKUP function is
How to use the VLOOKUP function
How to use the HLOOKUP function
Module 9 :Introduction to Excel - Conditional Formatting
Topic's covered :
What Conditional Formatting is
How to use Conditional Formatting
Rule Management for Conditional Formatting
Module 10 :Introduction to Excel - Data Tools
Topic's covered :
What Data Validation is
How to use the What-If Analysis
Using the Get Data function
How to Group and Sort Data
How Filtering works
Module 11 :Introduction to Excel - Review & Comment
Topic's covered :
Using the Find and Replace functions
Checking Spelling and using the Thesaurus
Explaining how to Protect Sheets and Workbooks
Comments: Adding, Editing, Deleting, and Displaying them
