Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
9 Hour(s) 25 Minute(s)
Language
English
Taught by
Ramzan Rajani
Rating
Course Overview
Learn Excel Formatting, Excel functions, Excel charts, Excel pivot tables and creating Interactive Reports
Excel skills are in high demand by most of the organizations.
Microsoft Excel is the greatest productivity software the world has seen so far.
However, it’s essential that you learn how to work with it effectively.
In this course you will learn Step by Step how to create Summary reports, formulas from basic to advanced level including Vlookup, IF Condition, Multiple IFs and lot many which you can use in your reporting.
What makes this course different from the rest of the Excel courses out there ?
You will be trained by Microsoft Certified Trainer + Excel Specialist
Excellent support: If you don’t understand a concept or you simply want to drop us a line, you’ll receive an answer within 24 hours
Downloadable materials : This Course comes with a complete set of downloadable materials
This course is suitable for people with basic working knowledge in Excel. We will start from the very basics and will gradually move on to some of the more advanced features, such as Vlookup functions, IF Conditions, Pivot Tables, Conditional Formatting, Excel Charts, and other tools that are often used for the purposes for regular reporting.
This course will teach you how to save time and be productive.
You should Pause the video, rewatch, and repeat exercises until you mastered them.
Happy Learning !
See you in the Session
Course Content
- 10 section(s)
- 100 lecture(s)
- Section 1 Mastering Basics of Excel
- Section 2 Conditional Formatting (Highlight / Color data on the basis of Criteria)
- Section 3 Magical Fill in Excel
- Section 4 Dynamic Table
- Section 5 Deleting Blank Rows from huge database (3 Methods)
- Section 6 Sorting & Filtering
- Section 7 Creating Beautiful Charts
- Section 8 PIVOT Table - Creating Dashboard - Summary Report with Pivot Table
- Section 9 Adding $ Sign in Formula
- Section 10 Paste Special
What You’ll Learn
- Learn the most common Excel functions used in the Office
- Create Interactive and Dynamic reports by mastering one of the most popular tools Pivot Table and Table Mode
- Create Beautiful & Stunning Dynamic Charts
- Writing IF Conditions and Nested IFs
- Mastering Vlookup (Basic to Advanced Level)
- Conditional Formatting with 12+ Sub options
- Learn CountIFs & SumIFs functions which is used to create Summary Reports
- Macros (Recording & Running) to Automate your regular task
Skills covered in this course
Reviews
-
JJulie Smith-Massara
It was a great experience. It moved at a good pace and if I didn't understand something I was able to rewind and watch again which was wonderful.
-
MMotwakel
Actually this course improve my excel sills and upgrading my known on how to create summary report and creating interactive dashboard with charts .
-
EEliza Dora Spencer
Amazing learning session! The Trainer is awesome, explanation given was very clear and easy to follow instructions. I learned a lot and I'll be happy to utilise the newfound knowledge in my work.
-
AArjun Binepal
Happy with the course overall. Good exercise content. Some feedback 1. lecture inaudible at certain points (he may be moving away from the microphone) 2. 1 zip file containing all resources along with those in each section (there are multiple resources in one section all containing the same file, gets confusing) 3. The first lecture of every section must begin with a clear, concise definition. eg. I often have to google it
