Master Excel Like a Pro!
- Do you find yourself spending a lot of time manually performing repetitive tasks in Excel?
- Have you ever encountered errors in your Excel formulas and struggled to identify and fix them?
- Do you need to create complex reports or presentations using Excel data?
- Do you work with multiple Excel workbooks and struggle to keep them organized and linked?
- Do you need to automate certain tasks or processes in Excel to save time and increase efficiency?
- Do you need to collaborate with others on Excel workbooks and want to learn how to use Excel Online?
- Do you need to create and share forms to collect data in Excel?
- Do you want to learn how to use advanced data analysis tools in Excel to gain insights and make better decisions?
- Do you want to improve your overall proficiency in Excel and learn advanced features and techniques to enhance your productivity?
If so, then the Excel Level 3: Advanced course will help you.
AT A GLANCE
This workshop is intended to help all users get up to speed quickly on the advanced features of Excel. We will cover using Excel online, worksheet Automation, auditing and error checking, data analysis and presentation, working with multiple workbooks and exporting and sorting data.
- 2 x 4-hour, instructor-led online sessions
- Public workshops are available for all our Excel courses.
- Comprehensive Learning Guide and Resource Manual
- Subscription to our monthly LearningLink e-newsletter
Master Excel's advanced tools for data mastery and automation
Learn how to master a wide range of advanced Excel skills that enable more efficient and powerful data analysis and workbook automation.
- Data Consolidation – Combine data from multiple sources into one analytics resource.
- Workflow Automation – Use macros and VBA to automate repetitive tasks.
- Collaborative Editing – Jointly edit live Excel files in real-time with Excel Online.
- Data Governance – Apply data validation rules and control access to sensitive data.
- Advanced Analysis – Perform complex data analysis with Power Pivot, Power Query and data modelling.
What You Will Learn
Advanced Excel Usage
Gain proficiency in using Excel Online, automating worksheets, auditing and error checking, data analysis, working with multiple workbooks, and exporting and sourcing data.
Efficiency and Automation
Learn to automate tasks, manage workbook properties, use advanced formula auditing tools, and analyse data effectively using advanced Excel features.
Data Presentation and Collaboration
Master the art of presenting data with tools like Sparklines, Quick Analysis, and What-If Analysis, and learn to collaborate using Excel Online and OneDrive.
Advanced Data Handling
Acquire skills in consolidating data from multiple sources, creating and maintaining links between workbooks, and utilising different data sources for analysis and reporting.
Upon completing this course, you will know how to collaborate on workbooks stored online, conduct complex what-if analysis, build connections between multiple data sources, automate worksheet tasks with macros and templates, create dynamic presentations leveraging Excel’s visualization tools, and troubleshoot formulas and trace errors.
Unit 1 Excel Online:
- Learn about using both Excel Online and the Excel desktop application, and the differences between
- Become comfortable managing workbooks in OneDrive
- Opening and editing workbooks in both applications
- Understand the benefits and obstacles that can be presented by each.
Unit 2 Worksheet Automation:
- Automate worksheets and their functionality
- Manage workbook properties
- Record and run basic macros,
- Create and use templates
- Use data validation criteria.
Unit 3 Auditing and Error Checking:
- Use formula auditing tools to trace errors and evaluate formulas
- Track formulas using the Watch Window and the Camera tool
- Arrange and display data using the Group commands
Unit 4 Data Analysis and Presentation:
- Using the Quick Analysis Tool
- Adding Sparklines
- What-If Analysis tools and how to use them to explore different
Unit 5 Working with Multiple Workbooks:
- Arrange, view, and navigate between multiple workbooks
- Consolidate data from multiple sources
- Create and maintain links between different workbooks
- Resolve broken connections.
Unit 6 Exporting and Sourcing Data:
- Available file formats for exporting data, and how to create them
- Understanding different data sources that can be accessed
- The process of creating and sharing a Microsoft Form to support data collection