Overview

Master Microsoft Excel in this comprehensive 7-hour course covering everything from basic interface navigation to advanced features like pivot tables. Learn essential skills including data entry, formula creation, cell formatting, chart generation, and data analysis techniques. Explore powerful tools such as conditional formatting, sparklines, and logical functions. Gain proficiency in organizing and manipulating data through sorting, filtering, and subtotaling. By the end of this course, develop the ability to efficiently manage complex spreadsheets, create insightful visualizations, and perform sophisticated data analysis using Excel's wide range of functionalities.

Syllabus

Lesson 1 - Introduction To Excel.
Lesson 2 - Overview Of The User Interface.
Lesson 3 - The Quick Access Toolbar.
Lesson 4 - Worksheets Vs Workbooks.
Lesson 5 - The Formula Bar.
Lesson 6 - The Status Bar.
Lesson 7 - The Right Click Menu And Mini toolbar.
Lesson 8 - Using The Mouse And Pointers.
Lesson 9 - Using The Help System.
Lesson 10 - Opening And Saving Files.
Lesson 11 - Entering Data Into Cells.
Lesson 12 - Using Autofill To Enter Data.
Lesson 13 - Enter Dates And Time.
Lesson 14 - Undo And Redo.
Lesson 15 - Using Comments In Your Worksheet.
Lesson 16 - Performing Arithmetic With Basic Formulas.
Lesson 17 - Using Sum And Average.
Lesson 18 - Copying And Pasting Formulas.
Lesson 19 - Calculating Year to date Profit.
Lesson 20 - Order Of Operations.
Lesson 21 - Using Relative And Absolute Addressing In Formulas.
Lesson 22 - Max, Min, Median, Standard Deviation Of Data.
Lesson 23 - Font Styles And Colors.
Lesson 24 - Changing Column Widths And Row Heights.
Lesson 25 - Alignment And Text Wrap.
Lesson 26 - Working With Cell Borders.
Lesson 27 - Numeric Formatting Of Cells.
Lesson 28 - Formatting Date And Time Cells.
Lesson 29 - Conditional Formatting.
Lesson 30 - Working With Tables.
Lesson 31 - Insert Shapes, Pictures, Arrows, SmartArt.
Lesson 32 - Insert And Delete Columns And Rows.
Lesson 33 - Hiding And Unhiding Rows And Columns.
Lesson 34 - Inserting, Moving, And Copying Cells.
Lesson 35 - Find And Replace Data.
Lesson 36 - Page Layout View And Header Footer.
Lesson 37 - Page Break Preview.
Lesson 38 - Page Setup And Printing Documents.
Lesson 39 - Creating Charts And Graphs.
Lesson 40 - Types Of Charts In Excel.
Lesson 41 - Formatting Charts In Excel.
Lesson 42 - Changing Chart Title, Legend, Axes, And More.
Lesson 43 - Creating Sparklines.
Lesson 44 - Freeze And Unfreeze Panes.
Lesson 45 - Split Screen Vertically And Horizontally.
Lesson 46 - Creating, Renaming, Deleting Worksheets.
Lesson 47 - Formulas With Inputs From Multiple Sheets.
Lesson 48 - Using The If Function For Logical Tests.
Lesson 49 - Sorting Data.
Lesson 50 - Calculating Subtotals In Lists.
Lesson 51 - Filtering Data.
Lesson 52 - Split Data Into Multiple Columns.
Lesson 53 - Introduction To Pivot Tables.
53 - Introduction to Pivot Tables.
52 - Split Data into Multiple Columns.
51 - Filtering Data.
50 - Calculating Subtotals in Lists.
49 - Sorting Data.
48 - Using the IF function for Logical Tests.
47 - Formulas with Inputs from Multiple Sheets.
46 - Creating, Renaming, Deleting Worksheets.
45 - Split Screen Vertically and Horizontally.
44 - Freeze and Unfreeze Panes.
43 - Creating Sparklines.
42 - Changing Chart Title, Legend, Axes, and More.
41 - Formatting Charts in Excel.
40 - Types of Charts in Excel.
39 - Creating Charts and Graphs.
38 - Page Setup and Printing Documents.
37 - Page Break Preview.
36 - Page Layout View and Header Footer.
35 - Find and Replace Data.
34 - Inserting, Moving, and Copying Cells.
33 - Hiding and Unhiding Rows and Columns.
32 - Insert and Delete Columns and Rows.
31 - Insert Shapes, Pictures, Arrows, SmartArt.
30 - Working with Tables.
29 - Conditional Formatting.
28 - Formatting Date and Time Cells.
27 - Numeric Formatting of Cells.
26 - Working with Cell Borders.
25 - Alignment and Text Wrap.
24 - Changing Column Widths and Row Heights.
23 - Font Styles and Colors.
22 - Max, Min, Median, Standard Deviation of Data.
21 - Using Relative and Absolute Addressing in Formulas.
20 - Order of Operations.
19 - Calculating Year-to-Date Profit.
18 - Copying and Pasting Formulas.
17 - Using SUM and AVERAGE.
16 - Performing Arithmetic with Basic Formulas.
15 - Using Comments in your Worksheet.
14 - Undo and Redo.
13 - Enter Dates and Time.
12 - Using Autofill to Enter Data.
11 - Entering Data into Cells.
10 - Opening and Saving Files.
09 - Using the Help System.
08 - Using the Mouse and Pointers.
07 - The Right Click Menu and Mini-Toolbar.
06 - The Status Bar.
05 - The Formula Bar.
04 - Worksheets Vs. Workbooks.
03 - The Quick Access Toolbar.
02 - Overview of the User Interface.