Excel and Google Sheets 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 live, instructor-led training session in Thailand (available online or onsite) is tailored for data analysts aiming to utilize Google Sheets for data analysis.

By the conclusion of this training, participants will have the ability to:

• Construct spreadsheets using Google Sheets.
• Implement formulas that function in both Google Sheets and Excel.
• Perform formatting and analysis on various data sets.
• Develop data visualizations through charts and graphs.