Online Course Microsoft Excel Advanced

Microsoft Excel Advanced Training Course: With the Microsoft Excel Advanced training, you will gain confidence with the program and save time!

Excel Courses that will expand your knowledge of Microsoft Excel 2016 .

Learning Objectives

Microsoft Excel is a computer program designed specifically for those of you whose daily activities require creating, processing and managing spreadsheets.

Microsoft Excel has many features including calculation functions, options for creating lists of data, charts, reports, etc. The program makes entering and editing information easy and fast. For this, however, you need to have a good knowledge of the capabilities it offers.

The online Excel training "Microsoft Excel for advanced" will allow you to explore in depth the possibilities of this powerful tool You will learn the secrets of Excel. You will gain valuable knowledge that will make your job easier and save you valuable time.

The course is delivered online, giving you the freedom to learn at a time and place that suits you. The only things you need are access to the internet, a computer/laptop and, of course, the desire.

A certificate of completion for Microsoft Excel 2016 training is available.

Training content

The theoretical part, consisting of 5 modules, is presented in an interactive way, it is filled with many visual elements through which we have gradually explained each action studied with the program. We have also prepared exercise work files and training videos.

Take a closer look at the content of the Excel e-learning "Microsoft Excel for Advanced", which is in the form of an Excel tutorial:

Module 1. Working with functions

Working with ranges:
- Selecting an entire row or multiple rows
- Selecting an entire column or multiple columns
- Selecting a cell as well as a block of 3X3 cells
- Selection of random cells
- Copy/cut and paste a range, move a range
- Filling a specified space
- Exercise - working with ranges
Working with logical functions:
- F function
- Function NOT
- AND function
- OR function
- Exercise - working with functions
Working with date and time functions:
- Date Calculations
- How to add days, months, years to a date(function TODAY, DAY, MONTH, YEAR)
- How to add time in Excel, how to display times correctly (SECOND, MINUTE, HOUR function)
- Working with text functions - TEXT, FIND, LEFT, RIGHT, MID, TRIM, PROPER, SUBSTITUTE, UPPER, LOWER.

Module 2. Working with lists

Sorting data:
- Using Sort sheet
- Using Sheet range
- Creating a custom sort
- Sorting Levels
- Exercise - Sorting Data
Data Filtering:
- How to filter data
- Using multiple filters simultaneously
- Deleting or clearing a filter
- Advanced filtering
- Advanced filtering
- Using advanced text, date and number filters (Advanced text filters; Advanced data filters; Advanced number filters)
- Exercises
Data queries with database functions:
- Overview of Excel database functions
- Grouping and summarizing data
- Grouping rows and columns
- Creating a Subtotal
- Groups displayed by level
- Subtotal exercise (video)

Module 3: Data Analysis

Create and customize tables:
- Format data as a table
- Customizing tables - rows and columns, changing table style and settings
- Removing a table
- Formatting tables exercise (video)
Intermediate Conditional Formatting:
- Conditional Formatting - Settings (Data Bars, Color Scales, Icon Sets)
- Remove Conditional Formatting
- Exercise - Intermediate Conditional Formatting (video)

Module 4. Visualizing data with charts

Creating charts:
- How are charts used? Chart insertion.
- Chart settings - layout style, insert title, rearrange data, change chart type, move, update.
- Exercise - Creating charts (video)
Advanced chart features:
- MileStone Chart
- Gantt chart
- Bell Curve Chart
- Sales Funnel Diagram

Module 5. Data Analysis with PivotTables and PivotCharts

Creating a PivotTable
Analyzing PivotTable Data:
- Adding Columns to a PivotTable
- Modifying a row or column
- Filters, adding no filters
- Exercise - Analyzing PivotTable data (videoо)
Presenting data with PivotCharts
Filtering data using Slicers:
- Adding a Slicer
- Exercise - Filtering Data with Slicers (video)

Sign up for our Excel courses and receive free additional lessons. If you have any questions, contact us on +359 878 685 304 or e-mail: office@nitbg.com.

Често задавани въпроси

What is the Microsoft Excel Advanced online training about?

This online course is designed to help you build advanced Microsoft Excel skills and gain confidence using the program. It focuses on practical knowledge that can save time in daily spreadsheet work. The training covers functions, lists, data analysis, charts, tables, and PivotTables, so you can explore Excel’s more powerful features in depth.

Who is this Excel course suitable for?

The course is intended for people whose daily work involves creating, processing, and managing spreadsheets. It is especially useful if you already use Excel and want to understand its capabilities better. The training helps you work more efficiently with data, reports, charts, and calculations.

How is the Excel training delivered?

The training is delivered online, so you can learn at a time and place that suits you. You only need access to the internet, a computer or laptop, and the willingness to learn. This makes it flexible for people who want to study around their own schedule.

What topics are covered in the Microsoft Excel Advanced course?

The course includes five modules covering working with functions, lists, data analysis, charts, and PivotTables. You will learn about logical, date and time, and text functions, sorting and filtering data, conditional formatting, tables, charts, and PivotCharts. It also includes advanced chart types such as Gantt charts and sales funnel diagrams.

Does the course include practical materials and exercises?

Yes, the training is interactive and includes many visual elements to explain each step clearly. It also provides exercise work files and training videos to support practice. The course is structured as an Excel tutorial, so you can follow along and apply what you learn.

Will I receive a certificate after completing the training?

A certificate of completion for Microsoft Excel 2016 training is available. This allows you to complete the course and receive proof of your training. The course also offers free additional lessons when you sign up.