Basic Microsoft Excel for Microsoft 365 is a beginner course in using Excel for calculation and summarising data, from entering and formatting data and writing formulas and functions, including XLOOKUP, to building charts and summarising with PivotTables. It suits staff who use Excel in everyday work, administrative and accounts teams, and people moving up from older versions of Excel.
Excel is used in almost every job, from keeping lists and working out expenses to summarising monthly sales, yet many users still retype figures by hand, copy formulas that give wrong results or spend too long setting up pages for printing. Getting the foundations right from the start, storing data as tables, writing formulas and choosing the right functions, makes work faster, cuts mistakes and makes it easy to move on to data analysis.
This course starts with the Excel window, managing files and saving to OneDrive, entering data with AutoFill and Flash Fill, and formatting, then moves on to formulas, relative and absolute cell references, basic functions, conditional functions and XLOOKUP. Learners then organise data as Excel tables, sort and filter, highlight data with conditional formatting, build charts, summarise with PivotTables and slicers, and prepare files for printing and sharing, finishing with a workshop that produces a sales summary report. It works with both Excel in Microsoft 365 and Excel 2024. (2 days, 6 hours per day, 12 hours in total, Beginner level.)
Course Details
This is the 2026 edition of the Basic Microsoft Excel 2016/2019 course. It runs for 2 days, 6 hours per day (12 hours in total, 09:00-16:00), as lectures with labs built on sample office files, at Beginner level. The content has been rewritten for Excel in Microsoft 365 and Excel 2024, adding AutoSave with OneDrive, Flash Fill, IFS, XLOOKUP, Excel tables, data validation and file sharing, while advanced analysis continues in the Advanced Microsoft Excel for Microsoft 365 course. Learners use their own or their company's copy of Excel. They take home the course handbook, sample files with answers, and the report they build in the workshop.
Section 1: Lab: The Excel Window and Managing Files
Section 2: Lab: Entering and Editing Data Quickly
Section 3: Lab: Formatting Worksheets
Section 4: Lab: Formulas and Cell References
Section 5: Lab: Everyday Basic Functions
Section 6: Lab: Conditional Functions and Looking Up Data
Section 7: Lab: Excel Tables and Managing Data
Section 8: Lab: Highlighting Data with Conditional Formatting
Section 9: Lab: Charts and Sparklines
Section 10: Lab: Summarising Data with PivotTables
Section 11: Lab: Printing, Protecting and Sharing Files
Section 12: Workshop: A Sales Summary Report
No public rounds are open right now. Join the waiting list and we will contact you first when the next round opens, or ask us on LINE. Or call 02-570-8449 or 088-807-9770
A PivotTable summarises large amounts of data into a summary table in a few clicks, such as sales by branch and month, without writing formulas. Organise the data as an Excel table first, then go to Insert and choose PivotTable, and drag fields into Rows, Columns and Values. You can change the summary to a sum, count or average, add slicers for button-style filtering, and click Refresh when new data arrives.
A relative reference such as A1 shifts when you copy the formula to another cell, which suits repeating the same calculation row by row. An absolute reference such as $A$1 always points to the same cell, which suits fixed values such as a VAT or discount rate kept in one cell. Mixed references lock only the row or the column, and pressing F4 while writing a formula switches between the styles.
XLOOKUP searches any column and can return a value from a column on either side. It does an exact match by default and lets you set the text shown when nothing is found, all in one function. VLOOKUP needs the lookup column to be leftmost and a column number that breaks easily when columns are inserted. In Excel in Microsoft 365 or Excel 2024, use XLOOKUP as your main lookup, but be able to read VLOOKUP in existing files.
It suits staff in any department who use Excel in everyday work, administrative, accounts, HR and sales staff, people moving up from older versions of Excel, and teachers, lecturers and students. You only need to be able to use a computer and Windows; no previous Excel experience is required. Bring a laptop with Excel from Microsoft 365 or Excel 2024.
You will be able to enter and format data quickly, write formulas with correct cell references, use functions such as SUMIFS, IFS and XLOOKUP, organise data as Excel tables, highlight it with conditional formatting, build charts, summarise with PivotTables and slicers, and prepare files for printing and sharing. Participants who complete the training receive a Certificate of Completion with its own number, which can be verified online.
Yes. It can be run in-house for your team, with examples adapted to your own work, such as using your department's real report layouts or data files as the workshop brief. You can request a quotation from this page, or contact us on LINE @itgenius or by phone on 02-570-8449.
Articles are published in Thai.
Work in many departments starts in Excel, but as the data grows and more people share it, problems appear: duplicated records, inconsistent typing, links between lists that are hard to follow, and reports rebuilt by hand every month. Microsoft Access…
Many organisations start keeping data in Excel because it is easy, but as the data grows and more people need it, they run into duplicates, inconsistent entries, several versions of the same file and reports that have to be compiled by hand every month.…
Once you can write basic macros, real work soon gets harder. Data runs to tens of thousands of rows, so macros that loop cell by cell become slow; files have to be combined from many folders; totals must be summarised by unique customer code; PivotTables and…
