Please contact us on WhatsApp at 00201019340490
Advanced Excel course (includes functions, charting, pivot table setup, linking between multiple worksheets, and setting up a complete Excel project) and explanation of many functions.
What I offer in the advanced Excel course:
1- Introduction to Excel and its basic principles
2- More than 30 formulas in Excel
3- How to analyze data using Pivot Table
4- How to use charts and their types
5- A comprehensive example using all of the above, linking between several sheets and using links.
If your Excel level is beginner and you only know the basics and want to develop your level, then book your place in the #Professional_Excel workshop where you will learn to use advanced functions like
IF –Ifs-LOOKUP-Count if-SUMIFS -INDEX-MATCH - and you will also learn data analysis using Excel through
Charts
Pivot tables
3 stages in Excel to become proficient and familiar with the most important details:
First Stage:
1) Introduction to Excel.
2) Data processing and arrangement within the table Sort & Custom sort
3) Using the filter and data filtering Filter & ADV Filter & Slicer
4) Conditional Formatting
Second Stage:
You will learn most of the formulas you can use wherever you work, formatting, and building reports
Like mathematical formulas, text formulas
Counting formulas, testing formulas, conditional formulas, date formulas, and many other formulas.
These are some of the formulas and many others:
sum & sum if & sumifs
max & min & average
count & count a & countback & count if
if & ifs
text
concatenate & concat & text join
Third Stage:
You will learn how to build and analyze reports using:
“Pivot Table” & “Pivot Chart”
And how to build a “Dashboard”
Number of lectures: 5 lectures - one lecture per week.
The course is interactive online on ZOOM.