Microsoft Office Excel - working effectively with the spreadsheet Training Course

This instructor-led, live training in Australia (online or onsite) is aimed at beginner-level analysts who wish to use Excel VBA to automate repetitive work, clean and transform data, and improve reporting processes.

By the end of this training, participants will be able to: record and edit macros, write simple VBA procedures, work with Excel objects for reporting tasks, and debug basic automation solutions.

Excel is a popular spreadsheet program developed by Microsoft. It is used to store, organise, and analyse data in tabular form. Here are some key features and functions of Excel: 1. Spreadsheets: It consists of sheets, where each sheet is an array made up of cells arranged in rows and columns. It allows you to create multiple sheets within a single file, enabling the organisation of different data sets. 2. Calculations and formulas: It enables performing various mathematical, statistical, and logical calculations using formulas. It has a wide range of built-in functions, such as SUM, AVERAGE, MAX, MIN, IF, VLOOKUP, etc. 3. Data formatting and appearance: It provides tools for formatting data, including changes to font, colour, style, as well as creating charts, pivot tables, and diagrams. 4. Sorting, filtering, and grouping: It allows data to be sorted according to specified criteria. It enables filtering data to display only selected information. It offers the ability to group data according to your needs. 5. Data analysis: Tools for performing advanced analyses, such as scenario analysis, trend analysis, forecasting, and creating macros. 6. Sharing data: It enables sharing and collaborating on data in real time, allowing multiple users to work on the same data simultaneously. 7. Task automation: It allows the creation of macros and task automation using the VBA (Visual Basic for Applications) programming language. Excel is widely used in various fields, from business to science and education. Its versatile features enable data analysis, report creation, budgeting, scheduling, data management, and many other applications.

This instructor-led, live training in Australia (online or onsite) is designed for data analysts ranging from beginner to advanced proficiency levels who wish to leverage Excel to execute a wide array of tasks, including data entry, formula creation, data analysis, and advanced automation.

Upon completion of this training, participants will be able to:

• Navigate the Excel interface and carry out fundamental data entry, formatting, and calculations.
• Apply advanced formulas, functions, and conditional formatting for effective data analysis.
• Create and manage pivot tables and charts for data visualisation.
• Utilise tools such as Power Query, Power Pivot, and perform comprehensive data analysis.
• Automate tasks using macros and VBA to streamline workflows.

This instructor-led live training in Australia (online or onsite) is designed for beginner to intermediate-level business analysts and data analysts who wish to use Excel to perform data analysis and reporting for their projects and tasks.

Upon completion of this training, participants will be able to:

• Utilise Excel formulas and functions to perform calculations and manipulate data.
• Employ Excel data analysis tools, including PivotTables, What-If Analysis, and Forecasting, to summarise and visualise data.
• Create and customise data visualisations using Excel charts and graphs.
• Apply data validation and conditional formatting to ensure data quality and highlight key insights.
• Use Excel's data import and export capabilities to connect with external data sources and share data with others.

This instructor-led, live training in Australia (online or onsite) is designed for beginner to intermediate-level professionals who wish to boost their productivity and efficiency by leveraging the advanced features of Excel and Google Sheets for data organisation, analysis, and collaboration.

By the end of this training, participants will be able to:

• Navigate and utilise the core features of Excel and Google Sheets.
• Perform data analysis and create actionable insights using advanced spreadsheet techniques.
• Collaborate in real-time using Google Sheets for seamless teamwork.
• Create reusable templates for reporting, tracking, and project management.

This instructor-led, live training in Australia (online or onsite) is designed for data analysts seeking to learn techniques for preparing data in Excel and then visualising it within Power BI.

Upon completion of this training, participants will be able to:

• Grasp the principles, objectives, and approaches of data analysis.
• Apply DAX formulas in Power BI for complex calculations.
• Create and utilise visualisations and charts for specific analysis scenarios.
• Import via Power View to transition from Excel-based workflows to independent Power BI environments.