Microsoft Excel- Beginner to Advanced

Complete Microsoft Excel Course - Beginner to Advanced including VBA

Unlock Excel’s potential with "Excel - Beginner to Advanced including VBA" From basics to advanced skills, learn data , formulas, and automation. Enjoy engaging video tutorials and lifetime access! start your journey today!

Buy $9.99

Course curriculum

1. Introduction
1. Launching Excel
2. Start Up Screen
3. The Excel Interface
4. The Quick Access Toolbar
5. The Ribbon
6. Creating New Excel Workbooks
7. Saving Excel Files
8. Opening Excel Files
9. Beginner Shortcut Keys
1. Entering Text
2. Working with Numbers
3. An Introduction to Dates
4. Find and Replace
5. Sorting Data
6. Working with Cell References
7. Relative Versus Absolute Cell Reference in Formulas
8. Understanding the Order of Operation
1. Introduction to Basic Excel Functions
2. The structure of an Excel Function
3. Working with the Sum Function
4. Working with Min and Max
5. Working with Averages
6. Working with Count and CountA
1. Moving and Copying Data
2. Inserting and Deleting Rows and Columns
3. Changing the Width and Height of Cells
4. Hiding and Unhiding Rows, Columns and Sheets
5. Renaming Worksheets
6. Deleting Worksheets
7. Moving and Copying Worksheets
1. Adding Borders to Cells
2. Formatting Percentages
3. Merging and Centering Cells
4. A Quick look at Styles
5. Basic Conditional Formatting
1. Inserting Images and Shapes
2. Working with SmartArt
1. Print Preview
2. Margins, Scaling and Orientation
3. Printing
1. Intro to Excel Templates
2. Opening an Existing Template
3. Creating a Custom Template
1. Conclusion
2. WORK FILE RESOURCES - HANDS-ON PRACTICE
1. Excel Intermediate Introduction
2. Excel Intermediate - Shortcut Keys
1. What are Lists
2. Sorting a List
3. Sorting Multiple Criteria
4. Custom Sort
5. What are Filters
6. Format a List as a Table
1. Introduction to Database Functions
2. DSum Functions
3. DSum Functions - Single Criteria
4. DSum Functions - Multiple Criteria
5. DAverage
6. DCount Function
7. Subtotal
1. Data Validation - List
2. Data Validation - Decimal
3. Input and Error Messages
1. Importing Data From Text Files
2. Importing Data from MS Access
3. Exporting Data to a Text File
1. Creating Basic Charts
2. The Chart Ribbon
3. Adding and Modifying Data on a Chart
4. Formatting Charts
1. Understanding Pivot Tables
2. Creating Pivot Tables
3. Pivot Table Calculations
4. Grouping Pivot Table Data
5. Formatting Pivot Table Data
6. Drilling Down into Pivot Table Data
7. Creating Pivot Charts
8. Filtering Pivot Table Data
9. Filtering Using the Slicer
1. Grouping Data
2. Consolidating Data
1. VLookUp
2. HLookUp
3. Index and Match
1. FV Function
2. PMT Function
3. Hyperlinks
4. Text to Columns
1. Excel Intermediate - Conclusion
1. Excel Advanced Introduction
2. Advanced Shortcut Keys
1. Tracing Precedents
2. Tracing Dependents
3. Watch Window
4. Show Formulas
1. Protecting Cells in Worksheets
2. Protecting the Workbook Structure
3. Encrypting with Passwords
1. Name Ranges
2. Simple IF Function
3. IF, AND
4. IF, OR
5. Nested Formulas
6. CountIF and CountIFs
7. SumIF and SumIFs
1. Advanced VLookUp
2. IF and IS Error Part 1
3. IF and IS Error Part 2
4. Advanced Index Match
5. Dates - Part 1
6. Dates - Part 2
7. Replace and Substitute Part 1
8. Replace and Substitute Part 2
1. Left, Right and Mid Function
2. Search Function
3. Concatenate and Search
4. Indirect - Static
5. Indirect - Dynamic
1. Goal Seek
2. Data Tables
3. Scenarios
4. Solver
1. Excel Advanced Conclusion
2. BONUS: Building a Mini Dashboard: Advanced Pivot Tables
1. What is VBA?
2. Object Orientated Programming
1. Macros Initial Setup
2. Recording a Macro
3. Saving a Macro
1. Launching VBA
2. VB Editor
3. Custom Menu
4. Naming Projects
5. Modules
6. Code Window
7. Comments
1. Introduction
2. Variables
3. Variable Exercise
4. What are Procedures
5. What are Procedures - Part Two
6. What are Procedures - Part Three
7. Message Boxes
8. Input Box
9. Basic Navigation
10. Sheets
11. Cell Navigation
12. Advanced Sheets
13. Offset
1. Introduction
2. Operators
3. Using Variables
4. What is Automation
5. For Loop
6. Do Loops
7. IF Statements
8. IF Statements - Part Two
9. Select Case
1. Debugging
1. UDFs
1. Introduction
2. Exercise 1 - Record a Macro
3. Exercise 2 - Duplicating Data
4. Exercise 3 - Generate a Report
5. Generate a Report - Part Two
6. Exercise 4 - Inner and Outer Loops
7. Inner and Outer Loops - Part Two
8. Inner and Outer Loops - Part Three
9. Inner and Outer Loops - Part Four
10. Inner and Outer Loops - Part Five
1. Form Controls
2. Building the Form
3. Initialize the Form
4. Command Buttons
5. Command Buttons - Part Two
1. Work Files

About this course

$9.99
177 lessons
13.5 hours of video content

Discover your potential, starting today

Enroll today

Module 1: Excel Beginner

Module 2: Excel Fundamentals

Module 3: Entering and Editing Text

Module 4: Basic Excel Functions

Module 5: Modifying an Excel Worksheet

Module 6: Formatting Data

Module 7: Images, Shapes and Smart Art

Module 8: Printing in Excel

Module 9: Bonus # 1 - Excel Templates

Module 10: Excel Beginner Conclusion

Module 11: Excel Intermediate

Module 12: Excel Lists

Module 13: Database Functions

Module 14: Data Validation

Module 15: Importing and Exporting

Module 16: Creating Basic Charts

Module 17: Pivot Tables

Module 18: Working with Large Data

Module 19: LookUp Functions

Module 20: Advanced Functions

Module 21: Excel Intermediate - Conclusion

Module 22: Excel Advanced

Module 23: Working with Multiple Workbooks

Module 24: Protecting Worksheets and Workbooks

Module 25: Conditional Formulas

Module 26: Advanced Functions

Module 27: Text-Based Functions

Module 28: What IF Tools

Module 29: Excel Advanced Conclusion

Module 30 : BONUS EXCEL VBA

Module 31: Macros

Module 32: VBA Editor

Module 33: Variables and Procedures

Module 34: Loops and IF Statements

Module 35: Error Handling

Module 36: User Defined Functions

Module 37: Excel VBA - Advanced Exercise Walkthroughs

Module 38: Creating Forms

Excel VBA - Course Resources

About this course