Excel Modelling Training Course

This instructor-led, live training in Thailand (offered online or onsite) is tailored for beginner-level analysts aiming to utilize Excel VBA to automate repetitive tasks, refine data cleaning and transformation processes, and enhance reporting workflows.

By the conclusion of this training, participants will have the ability to: record and edit macros, write basic VBA procedures, interact with Excel objects for reporting purposes, and debug fundamental automation solutions.

Excel is a popular spreadsheet program developed by Microsoft. It is widely used for storing, organising, and analysing data in a tabular format. Here are some of the key features and functions of Excel: 1. Spreadsheets: Excel is composed of worksheets, each of which is a grid consisting of cells arranged in rows and columns. It allows users to create multiple worksheets within a single file, facilitating the organisation of various data sets. 2. Calculations and Formulas: It enables the performance of a wide range of mathematical, statistical, and logical calculations through formulas. It offers a comprehensive set of built-in functions, such as SUM, AVERAGE, MAX, MIN, IF, VLOOKUP, and more. 3. Data Formatting and Appearance: Excel provides tools for formatting data, including changes to fonts, colours, and styles, as well as the creation of charts, Pivot Tables, and diagrams. 4. Sorting, Filtering, and Grouping: It allows data to be sorted based on specific criteria. Users can filter data to display only selected information. Data can be grouped according to specific requirements. 5. Data Analysis: Tools are available for conducting advanced analyses, such as scenario analysis, trend analysis, forecasting, and the creation of macros. 6. Data Sharing: Excel facilitates real-time sharing and collaboration, enabling multiple users to work on the same data simultaneously. 7. Task Automation: It allows for the automation of tasks through the creation of macros using the Visual Basic for Applications (VBA) programming language. Excel is widely used across 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 live, instructor-led training session in Thailand (delivered online or onsite) is tailored for data analysts at all experience levels, from beginners to advanced practitioners. The course focuses on mastering Excel for a wide range of professional activities, including data input, formula construction, analytical processing, and advanced automation.

Upon completion, participants will be equipped to:

• Master the Excel interface for efficient data entry, formatting, and basic calculations.
• Utilize advanced formulas, functions, and conditional formatting to drive deeper insights from data.
• Build and manage pivot tables and dynamic charts for compelling data visualization.
• Harness tools like Power Query and Power Pivot to perform sophisticated data analysis.
• Enhance productivity by automating workflows using macros and VBA scripting.

This live, instructor-led course, conducted in Thailand (online or on-site), is designed for business and data analysts at beginner to intermediate levels who seek to utilize Excel for data analysis and reporting within their projects.

Upon completing this training, participants will be equipped to:

• Employ Excel formulas and functions to execute calculations and data manipulation.
• Leverage analysis tools like PivotTables, What-If Analysis, and Forecasting to summarize and visualize data effectively.
• Utilize Excel charts and graphs to develop and customize compelling data visualizations.
• Apply data validation and conditional formatting to enhance data quality and emphasize key insights.
• Utilize data import and export capabilities to integrate with external sources and facilitate data sharing.

This instructor-led, live training in Thailand, offered online or onsite, targets beginner to intermediate professionals looking to increase productivity and efficiency. By utilizing the advanced features of Excel and Google Sheets, participants can refine their data organization, analysis, and collaboration capabilities.

Upon completion, participants will be able to:

• Confidently navigate and apply the core features of Excel and Google Sheets.
• Execute data analysis and generate actionable insights using advanced spreadsheet methods.
• Collaborate in real-time within Google Sheets for effective team coordination.
• Build reusable templates for streamlined reporting, tracking, and project management.

This live training session in Thailand (delivered online or onsite) is tailored for data analysts aiming to refine their skills in preparing data within Excel and effectively visualizing it using Power BI.

By the conclusion of this program, attendees will have the capability to:

• Understand the foundational principles, key objectives, and strategic approaches to data analysis.
• Apply DAX formulas in Power BI to execute complex calculations.
• Develop and utilize specific visualizations and charts for targeted analysis cases.
• Employ Power View to transition from Excel-based Power BI workflows to standalone Power BI environments.