Microsoft Excel Intermediate

By the end of this Microsoft Excel Intermediate course, participants will be able to:

• Advanced Formulas and Functions: Apply more complex functions (e.g., INDEX/MATCH, CONCATENATE, IFERROR) for more sophisticated calculations and data manipulation.
• Data Analysis Tools: Use tools like PivotTables and PivotCharts for powerful data analysis and visualisation.
• Data Validation and Protection: Apply methods to validate data entries and protect sensitive information within spreadsheets, enhancing data accuracy and security.
• Conditional Formatting: Use conditional formatting to highlight and visualise data based on specific criteria, making trends and anomalies more apparent.
• Advanced Charting and Graphing: Create more complex and customised charts and graphs to present data in a more visually appealing and understandable way.
• Managing Larger Datasets: Manage and handle larger datasets more efficiently, using tables and advanced sorting and filtering options.
• Automation with Macros: Use macros to automate more complex tasks, saving time and reducing errors in repetitive processes.
• Collaboration and Sharing: Collaborate effectively on workbooks, track changes, and merge data from different sources.
• Decision Support Analysis: Create scenarios and perform what-if analysis to support decision-making processes.
• Advanced Formatting Techniques: Apply advanced formatting techniques to make spreadsheets more visually appealing and professional-looking.