3 Sections
58 Lessons
4 Weeks
Expand all sections
Collapse all sections
Module 1: Beginner
13
1.1
1. Intro
1.2
2. The Ribbon
1.3
3. Saving Files
1.4
4. Entering and Formatting Data
1.5
5. Printing from Excel & Using Page Layout View
1.6
6. Formulas Explained
1.7
9. Correct a Formula Error
1.8
8. Specifying and Using Named Range
1.9
7. Working with Formulas and Absolute References
1.10
11. Insert Function & Formula Builder
1.11
12. How to Use a Function – AUTOSUM, COUNT, AVERAGE
1.12
10. What is a Function
1.13
13. Create and Customize Charts
Module 2: Intermediate
18
2.1
1. Recap
2.2
2. Navigating and editing in two or more worksheets
2.3
3. View Options – Split Screen, View Multiple Windows
2.4
4. Moving or Copying Worksheets to Another Workbook
2.5
5. Create a Link Between Two Worksheets and Workbooks
2.6
6. Creating Summary Worksheets
2.7
7. Freezing Cells
2.8
8. Add a Hyperlink to Another Document
2.9
9. Filters
2.10
10. Grouping ad Ungrouping Data
2.11
11. Creating and Customizing All Different Kinds of Charts
2.12
12. Adding Graphics and Using Page Layout to Create Visually Appealing Page
2.13
13. Using Sparkline Formatting
2.14
14. Converting Tabular Data to an Excel Table
2.15
16. Applying Data Validation to Cells
2.16
15. Using Structured References
2.17
17. Comments – Add, Review, Edit
2.18
18. Locating Errors
Module 3: Advanced
27
3.1
1. Recap
3.2
2. Conditional (IF) Functions
3.3
3. Nested Condition Formulas
3.4
4. Date and Time Functions
3.5
5. Logical Functions
3.6
6. Informational Functions
3.7
7. VLOOKUP & HLOOKUP
3.8
8. Custom Drop Down Lists
3.9
9. Create Outline of Data
3.10
10. Convert Text to Columns
3.11
11. Protecting the Integrity of the Data
3.12
12. What is it, how we use it and how to create a new rule
3.13
13. Clear Conditional Formatting & Themes
3.14
14. What is a Pivot Table and Why Do We Want One
3.15
15. Create and Modify Data in a Pivot Table
3.16
16. Formatting and Deleting a Pivot Table
3.17
17. Create and Modify Pivot Charts
3.18
18. Customize Pivot Charts
3.19
19. Pivot Charts and Data Analysis
3.20
20. What Is It and What Do We Use It For
3.21
21. Scenarios
3.22
22. Goal Seek
3.23
23. Running Preinstalled Macros
3.24
24. Recording and Assigning a New Macro
3.25
25. Save a Workbook to be Macro Enabled
3.26
26. Create a d Simple Macro with Visual Basics for Applications (VBA)
3.27
27. Outro
Microsoft Excel
Off
On
Curriculum
This content is protected, please
login
and enroll in the course to view this content!
Home
Courses
Search
Search
Account
Login with your site account
Lost your password?
Remember Me
Not a member yet?
Register now
Register a new account
Are you a member?
Login now
Modal title
Main Content