Microsoft Excel - Advanced Course
Become an Advanced Excel User
Our Advanced course builds on the skills you've already mastered in our Beginner and Intermediate courses. You’ll start with conditional functions like IFS, COUNTIFS, and SUMIFS, then move on to working with Date and Time values and advanced lookup formulas like INDEX, MATCH, and XLOOKUP. From there, you’ll be introduced to Dynamic Arrays, learn how to audit formulas, protect your work, and finish with an introduction to automation using macros. This course equips you to tackle almost any advanced task and prepares you for a smooth transition into our Power Query, Power Pivot, and Power BI courses on your way to becoming a Microsoft Excel power user.
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 already feel confident with Excel’s core features and want to explore topics such as advanced formulas, dynamic array functions, auditing techniques, or automation tools. It’s a natural next step for anyone looking to work more efficiently with complex data and continue their journey to becoming a Microsoft Excel power user through our upcoming Power courses.
Curriculum
- 9 Sections
- 56 Lessons
- 7 Quizzes
- 3h 17m Duration
Section 1: Course Introduction
- 1. Welcome
- 2. Certificate of Completion
Section 2: Using Excel's Conditional Functions
- 3. Working with Excel's IF Function
- 4. Working with Excel's COUNTIF() Function
- 5. Working with Excel's SUMIF() Function
- 6. Using the IFERROR() Function for Error handling
- 7. Using the SUMIFS() Function for Multiple Conditions
- 8. Nesting Functions in Excel
- 9. Nesting Excel’s AND() with the IF() Function
- 10. Working with Named Ranges in Excel
- 11. Named Ranges - What to be aware of
- 12. Manage Named Ranges
- Quiz: Using Excel's Conditional Functions
Section 3: Using Excel's Lookup Functions
- 13. Using the VLOOKUP() Function
- 14. Using the HLOOKUP() Function
- 15. Excel's INDEX() Function
- 16. Excel's MATCH() Function
- 17. Combining the INDEX() and MATCH() Function
- 18. Continuation INDEX() and MATCH() Function
- 19. Choosing the Right Lookup Tool
- Quiz: Using Excel's Lookup Functions
Section 4: Working with Excel's Text Functions
- 20. Working with the LEFT(), RIGHT() and MID() Function
- 21. Working with the LEN() Function
- 22. Working with the SEARCH() Function
- 23. Working with the UPPER(), LOWER() and PROPER()
- 24. Using Excel’s TRIM() and CLEAN() Function
- 25. Using Excel’s SUBSTITUTE() Function
- 26. Using the CONCAT() Function and “&” Symbol
- 27. Working with Excel’s TEXTJOIN() Function
- Quiz: Working with Excel's Text Functions
Section 5: Using Excel's Date and Time Functions
- 28. Understanding Date and Time Values in Excel
- 29. Working with Excel’s TODAY() and NOW() Functions
- 30. Working with Excel’s EDATE() and EOMONTH() Functions
- 31. Using Excel’s hidden DATEDIF() Function
- 32. Using Excel’s WORKDAY()Function
- 33. Using Excel’s NETWORKDAYS()Function
- 34. Working with Excel's Time Functions
- Quiz: Using Excel's Date and Time Functions
Section 6: Microsoft Excel 365 Functions
- 35. Introduction to Excel Dynamic Arrays
- 36. Understanding the Spill Error and # Sign
- 37. Working with Excel's UNIQUE() Function
- 38. Sorting Data with Excel's SORT() and SORTBY() Functions
- 39. Using the XLOOKUP() Function
- 40. Creating Dynamic Lists with SEQUENCE() Function
- 41. Filtering Data with the FILTER() Function
- Quiz: Microsoft Excel 365 Functions
Section 7: Auditing and Protecting Worksheets
- 42. Tracing Precedents and Dependents
- 43. Using the Watch Window to Monitor Cells
- 44. Showing and Evaluating Formulas
- 45. Protecting Cells in a Worksheet
- 46. Protecting a Workbooks Structure
- 47. Adding a Workbook Password
- Quiz: Auditing and Protecting Worksheets
Section 8: Automating Tasks in Excel (Overview)
- 48. Introduction to Macros in Excel
- 49. Activating the Developer Tab in Excel
- 50. Creating and Running Macros
- 51. Overview of the Visual Basic Editor
- 52. Editing Macros with the VBA Editor
- 53. Creating Buttons to Run Macros
- 54. Macros Security and Best Practices
- 55. VBA Macros vs Office Script: The Future of Excel Automation
- Quiz: Automating Tasks in Excel (Overview)
Section 9: Conclusion and Next Steps
- 56. Where to Go from Here (Continue Learning)
FAQs
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:
