Full Excel Course

​In this Full Excel course, you will gain in-depth knowledge from a 3,5 hour training session that is pre-recorded and can be viewed at a time and place that suits you. During the course, I will discuss how to use the functions below through practical examples:

​

Working with data volumes:

Different data types (neg numbers, currency, date, %);

Data formatting, exchange and removal;

Linking data between different worksheets.

​

Calculations and various functions:

​Shortcut options and how to use them;

Marking named ranges and searching by them;

Search functions (vlookup, index, match, hlookup);

Conditional functions (if, and, or, true, false, sumif, countif, iferror);

Functions for splitting and merging data (left, right, mid, concatenate);

Text functions for correcting and modifying data (clean, trim, upper, proper, lower, text, substitute);

Date functions (weeknum, networkdays, workdays, day, month, year);

Using basic functions (sum, count, average, max and min values);

Filtering functions (filter, sort, advanced filter);

Conditional formatting, adding conditional formatting through a function (conditional formatting).

​​

Processing large data tables:

Creating a PIVOT table and data queries;

VBA (creating and recording macros);

Using tables with large data volumes (freeze, split, side by side);

Sorting data (sorting by date, creating sort conditions);

Making subtotals (subtotal);

Grouping data (group)

Creating different scenarios (scenario manager).

​​

Charts:

Creating a chart from data in a table;

Creating a chart from multiple tables;

Adding and removing data from a chart;

Designing a chart, working with scales.

​​

Importing data:

Importing data from external environments (internet, CSV)​​​​