Faster work in Excel - You will use shortcuts, autofill, series and efficient copying techniques to handle everyday Excel tasks faster, more accurately and with far fewer repetitive clicks.
More reliable formulas - You will master logical, lookup, statistical and text functions, plus nested formulas, so you can build dependable spreadsheets for analysis, reporting and routine calculations.
Stronger data analysis - You will learn to use Quick Analysis, tables, references, Goal Seek and forecasting tools, helping you draw conclusions faster and make better decisions based on your data.
Cleaner data handling - You will sort, filter, split text, fill blank cells and validate entries more effectively, so you can prepare data for further work without confusion, inconsistency or avoidable errors.
Clear reports and outputs - You will practice conditional formatting, charts, pivot tables and print settings, allowing you to create clear reports that look professional on screen, on paper and in PDF files.
Data import and merging - You will explore Power Query and importing data from sheets, files, PDFs, the web and databases, which will reduce the time you spend manually combining information from sources.
Fewer spreadsheet errors - You will trace formulas, check dependencies, work with references and protect worksheets, helping you reduce mistakes and keep much better control over calculation accuracy.
A better start with VBA - By strengthening your skills in formulas, data work and worksheet structure, you will be better prepared for VBA and understand the logic behind future automation improvements.
Excel fundamentals are revisited here from the perspective of efficient day-to-day work. The section brings together keyboard shortcuts, quick analysis, copying data and formats, table-based calculations, tracing precedents and dependents, AutoFill, series, and relative versus absolute references.
Cell presentation affects both readability and the interpretation of values in reports. Participants work with formatting options for cells and numbers, and then create custom number formats to control how dates, amounts, codes or other values are displayed without changing the underlying data.
Go To is used to locate and act on specific cell types without manual scanning. The section focuses on finding cells by content or calculation characteristics, selecting blanks efficiently, and then filling or formatting those empty cells with text or numeric values.
Calculations do not have to stay within one sheet when workbook data is distributed across tabs. This section shows how to reference, format and calculate across multiple worksheets, including the use of the asterisk pattern for operations spanning sheet ranges.
Formula work expands from basic syntax to combining multiple function categories in one model. Participants practice logical functions, lookups with INDEX and MATCH, VLOOKUP or XLOOKUP, reference functions such as INDIRECT and OFFSET, conditional aggregations, rounding and nested expressions.
Array formulas change the way calculations are built, especially in newer Excel versions. The section explains where array-based solutions are useful, how formulas and functions operate over ranges in a single expression, and which dynamic array functions require Excel 365 or 2021.
Analytical tasks often begin with a target value or a need to estimate future results. In this part, learners use Goal Seek, create a Forecast Sheet, and discuss circular references to understand how Excel behaves when formulas depend on each other.
Text cleanup and restructuring are handled with both built-in tools and worksheet functions. The section includes Text to Columns, Flash Fill, and functions for extracting, joining, locating and replacing fragments so imported or inconsistent text can be prepared for further analysis.
Conditional formatting helps expose patterns and exceptions directly in the worksheet. The material includes highlighting values that meet criteria, using data bars and icon sets with custom rules, identifying minimum and maximum results, and building formula-based formats for cases like attendance lists or Gantt charts.
Date and time calculations in Excel require understanding how both values are stored and combined. Participants calculate intervals between dates and times, work with mixed date-time entries, and apply functions such as WORKDAY, DATEDIF, WEEKNUM, TIME, HOUR and MINUTE.
Charts are used here as a reporting tool matched to the structure of the data. The section covers selecting appropriate chart types, modifying them with built-in layout and style options, working with dual axes, changing displayed series, and preparing time-based and geographic visualizations.
Accurate input depends on rules that stop errors before they enter the worksheet. The section explains how to restrict invalid values, build simple and dependent multi-level lists, and use formulas and functions to define custom validation conditions.
Protecting workbook content requires separating file access from editing permissions. Here the focus is on password protection, sheet protection against unwanted changes, locking selected cells and hiding formulas so calculation logic remains inaccessible to other users.
When large lists need to be organized quickly, correct ordering and selection become essential. This part focuses on simple and two-level sorting, horizontal sorting and sorting by format, along with filtering numeric, text and date values and building advanced criteria with wildcards.
Pivot tables turn raw datasets into structured summaries for reporting and review. The section includes aggregations such as sums, averages and counts, sorting and filtering, grouping, custom calculated fields and items, and dashboard-style presentation with slicers, timelines and pivot charts.
Working with external data starts from connecting Excel to multiple sources. Participants use Power Query to import records from worksheets, text and Excel files, PDFs, databases and web pages, and then perform basic transformations in the query editor interface.
Print setup in Excel is organized around controlling layout before output. The section covers print area definition, scaling data to paper size, margins, page orientation and repeated headers or first columns, then adds page numbering and exporting sheets to PDF.
Basic Excel skills - You should be comfortable moving around a worksheet, entering and editing data, selecting ranges and saving files so you can focus on the more advanced topics in the course.
Simple formulas and references - You should know how to enter simple formulas, use basic operators and understand cell references, because the training builds further on these practical skills.
Working with data tables - You should have experience working with lists or tables in Excel, for example sorting data and using filters, because the course develops analysis based on such datasets.
Readiness for hands-on work - You should be ready to complete exercises on a computer and test solutions on your own in worksheets, because the training is practical and strongly workshop-based.
