Excel - Intermediate

Are you ready to elevate your Excel skills? With our course, Learn to use Microsoft Excel like a Pro - Intermediate Level, you'll take your foundational knowledge of Excel to the next level. This course is designed for those who have basic Excel skills or have just completed the Beginner Level course. Dive into the world of advanced Excel functionalities that will transform how you work with data.

Course Highlights:

• Master essential Database functions, including SUMIFs, to analyze data efficiently.
• Become an expert in Pivot Tables, allowing you to summarize and visualize your data effortlessly.
• Learn to automate repetitive tasks, streamlining your workflow and saving you valuable time.
• Gain insights into data management that can revolutionize how you handle information in Excel.

Who Should Enroll:

This course is perfect for students and corporate employees looking to enhance their Excel abilities. Whether you aim to improve your data analysis or optimize your reporting processes, this course will equip you with the tools you'll need to succeed.

Join us and learn to use Microsoft Excel like a Pro - Intermediate Level today, and unlock the full potential of this powerful tool for your professional and personal growth!

Curriculum:

1. Excel - Intermediate
- Excel Intermediate Introduction
- Intermediate Shortcut Keys

2. Lists
- What are Lists
- Sorting a List
- Sorting - Multiple Criteria
- Custom Sort
- What are Filters
- Format a List as a Table

3. DataBase Functions
- Introduction to DataBase Functions
- DSum Function
- DSum Function - Single Criteria
- DSum Function - Multiple Criteria
- DAverage
- DCount Function
- Subtotal

4. Data Validation
- Data Validation - List
- Data Validation - Decimal
- Input and Error Messages

5. Importing and Exporting
- Importing Data from Text Files
- Importing Data from MS Access
- Exporting Data to a Text File

6. Creating Basic Charts
- Creating Basic Charts
- The Chart Ribbon
- Adding and Modifying Data on a Chart
- Formatting Charts

7. Pivot Tables
- Understanding Pivot Tables
- Creating Pivot Tables
- Pivot Table Calculations
- Grouping Pivot Table Data
- Formatting Pivot Table Data
- Drilling Down into Pivot Table Data
- Creating Pivot Charts
- Filtering Pivot Table Data
- Filtering using the Slicer

8. Working with Large Data
- Grouping Data
- Consolidating Data

9. LookUp Functions
- VLookUp
- HLookUp
- Index and Match

10. Advanced Functions
- FV Function
- PMT Function
- Hyperlinks
- Text to Columns

11. Excel Intermediate - Conclusion
- Excel Intermediate - Conclusion