Microsoft Excel Skill for Data Analyst
- Description
- Curriculum
- FAQ
- Reviews
Microsoft Excel Skill for Data Analyst 2022
Scratch the surface of Microsoft of Excel to the Advanced level and become relevant in the Data ANALYTICS Industry
Why Should I Take this course?
This Excel course covers all you need to know in Microsoft Excel to the Advance level.
It is for you even if you don’t have a piece of prior knowledge about Microsoft EXCEL.
We are not just going to teach you basic functions and formulas but also help you learn how to combine Microsoft EXCEL functions to create amazing projects like Reports, Dashboards, and Inventory Management Systems plus other ways to practically use Functions and Formulas in Excel.
This course is prepared to help you gain industry knowledge on how Excel is used daily to make decisions in an organization.
What you will Learn
v Learn how to think like an advanced Excel user and write powerful and dynamic formulas and functions in Excel from the scratch.
v Master some tips you won’t find in any other courses
v How to apply formulas and functions in your project
v Create your own formulas that go according to Microsoft Excel rules
By the end of this course, you will go out there and confidently say to Employers that you are an Excel Expert without shaking of mind.
Our aim is to make you believe in yourself as we are going to take you by hand step by step on how to navigate Microsoft Excel like a pro.
After this course, you will never have problems creating dynamic and easy-to-update Excel Reports and you will create a very elegant, clean, interactive, and outstanding dashboard.
To get started all you have to do is to sign up and get the Resources file downloaded to your system. The resources are in a zip file, unzip it and join us in the class as we take you step by step on what you need to know about Microsoft Excel. See you There!
-
8
Customize the Ribbon and Quick Access Tool bar -
9
Basic way of hiding worksheet
-
10
Advanced way of hiding worksheet
-
11
Freeze Panes (How to lock rows and columns)
-
12
Inserting and moving worksheets
-
13
Basic ways to insert rows and columns
-
14
Shortcut to insert rows and columns
-
15
Split Screen while working on reports
-
16
Advanced ways to copy and past in Excel
-
17
How to hide and unhide rows and columns
-
18
12 How set columns and rows width
-
19
How to group rows and columns
-
20
How to move cells with values or data
-
21
Introductions to Excel functions and formulas
-
22
Understand this steps before you write any function in excel
-
23
Understand Relative cell reference in Excel
-
24
Understand Absolute cell Reference in Excel
-
25
5 Understanding mixed cell reference in Excel
-
26
How to create Range Names to write formulas fast
-
27
7. Working with Sum function with Alternative function to Aggregate values
-
28
Working with the Sumif function
-
29
10. Working with Sumifs function for multiple Criterial Ranges
-
30
Get Deep Understanding of the Round functions
-
31
Working with the Average function
-
32
Understanding the AverageA and its difference with from Average
-
33
Working with the Max and Large function
-
34
Understand the Min function in Excel
-
35
Understand the Count and CountA function
-
36
Understand the Countif Function (Pro level)
-
37
How to use the Countifs function in Excel
-
38
3-Ways to join Strings of Text in Excel
-
39
Understand how the Index function works
-
40
Understand the Match function
-
41
Complex Lookup with Index and Match function
-
42
How to use Excel Vlookup function
-
43
Understand how to combine vlookup plus the match function
-
44
Do more with the Sumproduct function in Excel (Pro level)
-
45
Remove spaces from Text using Substitute and Trim function (Pro Level)
-
46
Textjoin instead of Concate or Concatenate function
-
47
Understand the Excel Offset for Dashboard Automation
