Microsoft Excel - Advance Level MS Excel Training Course
- Description
- Curriculum
- FAQ
- Reviews
Enhance your Microsoft Excel Skills By Learning this Advance MS Excel Training Course.
Microsoft Excel is one of the most commonly used products of Microsoft office. It is used for data entry, data analysis, data presentation, or calculation. The best thing about Microsoft Excel is that this totally depends on your skill level. You can use MS Excel for any beginner or advanced level task it will be equally efficient & easy to use in either case.
This MS Excel course is Advance Level or Expert Level training especially for engineers, data analysts, data scientists, students, teachers, or researchers, or for anyone who has basic or intermediate level Microsoft Excel knowledge & now wants to learn Advance Level, MS Excel.
This Microsoft Excel course has a total of 15 video lectures with a total length of 2 hours. This course is designed by assuming that you have basic or intermediate level knowledge of MS Excel & now you want to enhance your Excel skills & learn some Advance Excel Options that will bring more ease & add value to your work.
This course is designed in Microsoft Excel 2016 version but you can easily learn in almost any older or latest version of MS Excel.
Some Excel sample files or excel practice worksheets are attached that you can download & practice on.
This course is divided into the following different sections:
1. Introduction to the Course
2. Data Tab
3. Insert Tab
4. Developer Tab
Under these tabs the following different topics will be discussed:
- Data Analysis options
- Data import options / Excel Queries
- Data Consolidation
- Sort & Filter option
- Charts & Tables
- Pivot Tables & Charts
- Dashboards
- Form Controls
- VBA & Macros
I am hopeful that you will be extremely happy to choose this course.
So, Join This Course Today. Happy Learning!
-
2Scenario Manager OptionVideo lesson
In this video, you will learn about the Scenario Manager option under 'What If Analysis'
-
3Goal Seek OptionVideo lesson
In this video, you will learn about the Goal Seek option under 'What If Analysis'
-
4Data Table OptionVideo lesson
In this video, you will learn about the Data Table option under 'What If Analysis'
-
5Queries in ExcelVideo lesson
In this video, you will learn about the Queries option in MS Excel.
-
6Text to Columns OptionVideo lesson
In this video, you will learn about the Text to Column data tool in MS Excel.
-
7Data ConsolidationVideo lesson
In this video, you will learn about Data Consolidation in MS Excel.
-
8Sort & Filter in ExcelVideo lesson
In this video, you will learn about the Sort & Filter options.
-
9Selecting the ChartVideo lesson
In this video, you will learn how to select the right chart for the data in MS Excel.
-
10Creating Charts in ExcelVideo lesson
In this video, you will learn how to create Charts in MS Excel.
-
11Tables in ExcelVideo lesson
In this video, you will learn how to create Tables in MS Excel.
-
12Pivot Table & ChartVideo lesson
In this video, you will learn how to use Pivot Table & Charts in MS Excel.
-
13Dashboards in ExcelVideo lesson
In this video, you will learn how to create Dashboards in MS Excel.
External Links May Contain Affiliate Links read more