Advanced learning course Excel

Advanced learning course Excel

Product Code: Office Productivity
  • 500.00€

  • Ex Tax: 500.00€
lessons

Our considerable experience with Microsoft Office Excel shows us that this program is like an ocean of possibilities, where you can constantly find new things, and most importantly - practically applicable in life.

Once you have the basic knowledge and skills to work with Microsoft Office Excel, it is essential to continue the gradual development to reach the heights.

Those who skip the in-between increase the risk that many things can become complicated, unclear and confusing. If this happens, people lose the desire to learn and go for the goal. This principle is vitally proven.

In the intermediate course, my goal is to help you master Excel at an intermediate level and use the program effectively.

Pre-requisites:

Microsoft Office Excel installed on your PC

Basic Excel skills and knowledge

Willingness to learn and practice

Who is this course for?

For those who already have a basic level of Excel knowledge and skills but want to deepen them

For those who need to use Excel on a daily basis at work.

For those who are interested in Excel and its capabilities

Who this course is for:
Those who already have a basic level of Excel knowledge and skills but want to deepen them
Those who need to use Excel on a daily basis at work
Those who are interested in Excel and its capabilities

What you will learn
Apply sorting and filtering tools in a database (DB)
Find and eliminate duplicates in the database
Work with functions specifically designed for use in a database
Validate (verify) data
You will become a confident user of the Pivot Table and Summary Chart
Import and export data from text files
Create a variety of charts
Work with Power Pivot and its basic tools
Explore important Excel printing options
Work with 3D (pass-through) formulas
Consolidate data
And much more

Course content 10 sections - 57 lectures - Total duration 3 hrs 17 mins

Introduction
Sorting and filtering an Excel database
Functions for Excel database
Checking (validating) Excel data
Importing and exporting data to Excel
Excel Summary Table (Pivot Table)
Power Pivot and its tools
Working with large amounts of Excel data
Conclusion
Additional Video Lessons

3 lectures - 4 min
9 lectures - 32 min
4 lectures - 14 min
4 lectures - 12 min
2 lectures - 6 min
8 lectures - 21 min
6 lectures - 18 min
5 lectures - 15 min
2 lectures - 2 min
14 lectures - 1 hour 15 min

 

Write a review

Note: HTML is not translated!
    Bad           Good