Advanced Excel Course launching on Mar. 1, 2025

Microsoft Excel - Intermediate Course

Overview
Curriculum
Reviews
FAQs

Take your Excel skills to the next level

 

Our Intermediate course builds on the foundations you’ve already mastered in the Beginner course, taking you deeper into Excel’s powerful features and tools. From mastering PivotTables to using forecasting tools like Goal Seek, and gaining an introduction to Power Query and Power Pivot, this course is designed to give you the confidence and expertise needed to tackle more complex tasks and seamlessly progress to our Advanced Excel Course.

 

At ExcelCamp, we believe that learning should be engaging, supportive, and interactive. Here’s what makes this course stand out:

 

 

  • Progressive Learning: Our curriculum is structured to build your skills incrementally, ensuring that you develop a solid understanding of each concept before moving on to the next. This step-by-step approach helps you gain confidence and proficiency as you progress through the course. 

 

  • Dedicated Support: Questions along the way? Our teaching assistants are always ready to help. Plus, you might find answers and new perspectives from fellow students – learning is a team effort here! 

 

  • Interactive Learning: Learning is more engaging and effective when it's interactive. Our courses feature active discussions and comment sections where you can engage with instructors and peers. This collaborative environment enhances your understanding and retention of the material.

 

  • Community: ExcelCamp is more than just a course; it's a vibrant community. Join us on our social media platforms and become part of a supportive community where you can share tips, ask questions, and grow together with peers.

 

 

This course is designed for those who have a solid understanding of Excel basics and are ready to take their skills to the next level. It’s perfect for anyone looking to enhance their productivity, expand their knowledge of Excel’s powerful features, or prepare for more advanced topics in data analysis.

 

Curriculum

  • 8 Sections
  • 47 Lessons
  • 6 Quizzes
  • 3h 20m Duration
Expand All
Section 1: Course Introduction
2 Lessons
  1. 1. Welcome
  2. 2. Certificate of Completion
Section 2: Importing Data into Excel
6 Lessons1 Quiz
  1. 3. Importing Data from Files
  2. 4. Importing Data from other Sources
  3. 5. Managing Queries and Connections
  4. 6. Introduction to Power Query
  5. 7. Transforming Data with Power Query
  6. 8. Some more Power Query Transformations
  7. Quiz: Importing Data into Excel
Section 3: Working with Data in Excel
9 Lessons1 Quiz
  1. 9. Understanding Excel Lists
  2. 10. Sorting a List (Single and Multi Level Sorting)
  3. 11. Custom Lists and Unsorting a List
  4. 12. Filter a List in Excel
  5. 13. Adding Subtotals to Your List
  6. 14. Fill Empty Cells in Your List
  7. 15. Find and Remove Duplicates
  8. 16. Find and Replace Data in Your List
  9. 17. Convert Your List into an Excel Table
  10. Quiz: Working with Data in Excel
Section 4: Data Management and Formatting
8 Lessons1 Quiz
  1. 18. Introduction to Excel Data Validation
  2. 19. More about Excel Data Validation
  3. 20. Consolidating Data in Excel
  4. 21. Using Excel's Text to Column feature
  5. 22. Discovering Excel's Data Types
  6. 23. Custom Formatting Options
  7. 24. Navigating Large Datasets
  8. 25. Freezing Panes in Excel
  9. Quiz: Data Management and Formatting
Section 5: Working with Excel Pivot Tables
9 Lessons1 Quiz
  1. 26. Introduction to PivotTables
  2. 27. Working with an Excel PivotTable
  3. 28. Manipulating PivotTable Data
  4. 29. Using Calculated Fields and Items
  5. 30. Grouping Data in PivotTables
  6. 31. PivotTable Layout and Formatting Options
  7. 32. Creating PivotCharts
  8. 33. Using Slicers and Timelines
  9. 34. Best Practices and PivotTable Settings
  10. Quiz: Working with Excel PivotTables
Section 6: Power Pivot and More Analysis Tools
8 Lessons1 Quiz
  1. 35. Introduction to Power Pivot in Excel
  2. 36. Importing Data into Power Pivot
  3. 37. Building Relationships in Power Pivot
  4. 38. Creating PivotTables from Data Models
  5. 39. Using Excel's Goal Seek Feature
  6. 40. Using Excel's Solver Tool
  7. 41. What-If Analysis with Data Tables
  8. 42. Forecast Sheet for Trend Analysis
  9. Quiz: Power Pivot and More Analysis Tools
Section 7: Workbook Design Options
4 Lessons1 Quiz
  1. 43. Structure and Design Principles
  2. 44. Workbook Themes and Colours
  3. 45. Adding Hyperlinks in Excel
  4. 46. Using Excel Templates
  5. Quiz: Managing an Excel Worksheet
Section 8: Conclusion and Next Steps
1 Lesson
  1. 47. Where to Go from Here (Continue Learning)
0 out of 5

0 user ratings

FAQs

Expand All
1.  Will I have lifetime access to this course?

Yes, once you enroll in the course, you will have lifetime access.

2.  What kind of support can I expect if I need help during the course?

Our dedicated support team is here to help with any course-related questions or technical issues you might encounter. You can reach out via our Q&A section or email us at any time for assistance.

3.  Will I receive a certificate upon completion?

Yes, upon completing any of our courses, you will receive a certificate that you can add to your LinkedIn profile and resume. Note: We are currently developing digital badges, we will notify you once they are available.

4.  How often is the courses updated?

We regularly update our courses to ensure they reflect the latest in Excel functionality and best practices. Typically, courses are reviewed and updated annually, or sooner if significant changes in Excel occur.

5.  I am evaluating this for our team. Who can I speak with to learn more?

Please contact us directly at info@excel-camp.com to learn more about bulk discounts.

×

Free Lesson Videos:

Thumbnail
6. Introduction to Power Query
00:03:36
Thumbnail
11. Custom Lists and Unsorting a List
00:10:00
Thumbnail
30. Grouping Data in PivotTables
10:00:39

Deleting Course Review

Are you sure? You can't restore this back

Course Access

This course is password protected. To access it please enter your password below: