Excel Training - Complete Course

Embark on a comprehensive 12-hour Microsoft Excel training course covering everything from basic worksheet creation to advanced data analysis and visualization techniques. Master essential skills like navigating and formatting workbooks, customizing views, and configuring print settings. Learn to manipulate data effectively by inserting and formatting cells, creating tables, and applying filters. Dive into powerful Excel functions, including conditional logic and text manipulation. Explore data visualization through chart creation and formatting. Apply your knowledge through multiple case studies, providing hands-on experience with real-world scenarios. Gain access to downloadable assets and follow along with detailed, time-stamped modules for a thorough learning experience.

Syllabus

- Introduction
- Create Worksheets and Workbooks
- Create Worksheets and Workbooks 2
- Navigate through Worksheets and Workbooks
- Navigate through Worksheets and Workbooks 2
- Format Worksheets and Workbooks
- Format Worksheets and Workbooks 2
- Format Worksheets and Workbooks 3
- Format Worksheets and Workbooks 4
- Format Worksheets and Workbooks 5
- Format Worksheets and Workbooks 6
- Format Worksheets and Workbooks 7
- Customize Options and Views for Worksheets and Workbooks
- Customize Options and Views for Worksheets and Workbooks 2
- Customize Options and Views for Worksheets and Workbooks 3
- Customize Options and Views for Worksheets and Workbooks 4
- Customize Options and Views for Worksheets and Workbooks 5
- Configure Worksheets and Workbooks to Print or Save
- Configure Worksheets and Workbooks to Print or Save 2
- Insert Data in Cells and Ranges
- Insert Data in Cells and Ranges 2
- Insert Data in Cells and Ranges 3
- Format Cells and Ranges
- Format Cells and Ranges 2
- Format Cells and Ranges 3
- Format Cells and Ranges 4
- Order and Group Cells and Ranges
- Order and Group Cells and Ranges 2
- Order and Group Cells and Ranges 3
- Order and Group Cells and Ranges 4
- Create a Table
- Modify a Table
- Filter and Sort a Table
- Utilize Cell Ranges and References in Formulas and Functions
- Summarize Data with Functions
- Utilize Conditional Logic in Functions
- Format and Modify Text with Functions
- Create a Chart
- Format a Chart
- Insert and Format an Object
- Insert and Format an Object 2
- Introduction
- Part 1
- Part 2
- Part 3
- Part 4
- Part 5
- Introduction
- Part 1
- Part 2
- Part 3
- Part 4
- Part 5
- Introduction
- Part 1
- Part 2
- Part 3
- Part 4
- Part 5
- Part 6