Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
9 Hour(s) 41 Minute(s)
Language
English
Taught by
Sama Tamhidi
Certificate
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
Course Overview
Excel complete Course. From Microsoft Excel Formulas & Tables to Pivots, Dashboards which shine you & save your time.
In Excel all you need Trip which we start Together you will learn from basic to advanced level of Excel to prepare a complete work schedule also analyzing and tracking of Duplex Villa with a user-friendly environment and with a lifetime Great Support:
What you learn
This course teaches you to create well-designed Excel dashboards.
You will be familiar with essential excel formulas, and be ready to implement them in every excel forms.
This Microsoft Excel All You Need Course comes with all excel workbooks which I have created and worked in the course.
Excel dashboard & Report
Excel Formulas
Excel Power Pivot & Pivot Tables & Queries
Basic
1. General Acquaintance
2. Simple Forms Journey
3. Designing a Form
4. Text Functions
5. Search Functions
6. Count Functions
7. Sum Functions
8. IF Functions
9. Vlookup & Conditions
10. Names
11. Charts
12. Kind of Charts
13. Search & Replace
14. Group & Sort & Subtotal
15. Filtring
16. Conditional Formatting
17. Split & Freezing
18. Dynamic Form
19. Dynamic Form-Part2
20. Printing
Intermediate
21. Table
22. Pivot Table
23. Pivot Table-Human REsource
24. Pivot Table Machinery
25-1. Sales-Dashboard
25-2. Design of Sales Dashboard
26. Advanced Conditional Formtting
27. Advanced Filter
Advanced
28. General Acquaintance of Power Query
29. HR Report with Power Query
30. Data Power Query
31. General Acquaintance of Power Pivot
32-1. Power Pivot-Project Managewment
32-2. Power Pivot-PM-Cost
32-3. Power Pivot-PM-Manhour
33. Power Pivot Graph
34. Dashboard
++ Great Support and Constantly Updated
As the quality Course is so important for us, we have individual supports that you can ask your questions and issues from us and also we constantly check what is important and what do you need to know more from Excel to hasten your analyzes.
We would be happy to see you on this Trip.
Course Content
- 5 section(s)
- 67 lecture(s)
- Section 1 Start the Trip!
- Section 2 Basic
- Section 3 Intermediate
- Section 4 Advanced
- Section 5 See You Later!
What You’ll Learn
- Master Microsoft Excel from Beginner to Advanced
- Learn the Basics of Microsoft Excel
- Learn the most common Excel functions used in the Office
- Maintain large sets of Excel data in a list or table
- Save time by unlocking dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions and many more
- Create dynamic reports by mastering one of the most popular tools, PivotTables
- Work with Queries
- Work with large data in a blink of an eye it is called Power Pivot
Skills covered in this course
Reviews
-
PParisa Sadat Mir Isakhani
Highly recommended Excel course, especially for those who work in the project management field!
-
AAthili Pavarana
I liked the course structure, which explains a project from scratch.
-
AAta Motı
Great course as she share files and also explained Power Pivot and queries with nıce samples + I learned about Dashboards.
-
SSHIEKH MOHAMMED RAFIQ
Sama your great instructor and explanation which you provide on each topics very detailed and undestand eazily, after taking your Power BI free course feel like taking this course. Thank you very much
