Microsoft Excel Level 5

Categories: Worksafe
Wishlist Share
Share Course
Page Link
Share On Social Media

Course Prerequisite(s)

  • Please note that this course has the following prerequisites which must be completed before it can be accessed
  • Microsoft Excel Level 4

About Course

Advanced Microsoft Excel: Level 5 is a comprehensive 9-hour course designed to enhance participants’ proficiency in Excel, focusing on advanced data analysis, automation, and collaboration techniques. This course is suitable for individuals who have a strong understanding of Excel fundamentals and want to master advanced features to streamline their workflows and make data-driven decisions. Through hands-on exercises, practical examples, and real-world applications, participants will learn advanced functions, data modeling techniques, automation with macros and VBA (Visual Basic for Applications), and collaboration tools such as Power Query and Power Pivot.

What Will You Learn?

  • Master advanced functions and formulas for complex data analysis and manipulation.
  • Explore advanced data modeling techniques using Power Query and Power Pivot.
  • Automate repetitive tasks and streamline workflows using macros and VBA.
  • Understand advanced data visualization techniques for effective communication of insights.
  • Learn collaboration tools and techniques for sharing and collaborating on Excel workbooks.
  • Gain practical experience through hands-on exercises and real-world projects.

Course Content

Advanced Functions and Formulas
Review of basic functions and formulas Advanced text functions: CONCATENATE, TEXTJOIN, MID, etc. Advanced lookup and reference functions: INDEX, MATCH, INDIRECT, OFFSET, etc.

Advanced Data Analysis Techniques
Using array formulas for complex calculations Applying advanced statistical functions: FREQUENCY, RANK, PERCENTILE, etc. Implementing logical functions: IF, AND, OR, NOT, etc.

Power Query and Power Pivot
Introduction to Power Query: data import, transformation, and cleaning Leveraging Power Pivot for data modeling and analysis Creating relationships, measures, and calculated columns in Power Pivot

Automation with Macros and VBA
Introduction to Excel macros: recording, editing, and running macros Writing VBA code to automate repetitive tasks and extend Excel functionality Creating custom functions, user-defined functions (UDFs), and add-ins with VBA

Advanced Data Visualization and Collaboration
Creating advanced charts and graphs for data visualization Using slicers and timelines to interactively analyze data Collaborating on Excel workbooks: sharing, protecting, and tracking changes

Want to receive push notifications for all major on-site activities?

✕