
An introduction and welcoming to the course along with explaining the most important things to learn and what to expect at the end of the course
I will take you in a fast tour to show the most popular functions and features of Excel that is widely used
I will explain the most powerful shortcuts used in Excel that will make your convert your work to be faster
I will explain you more about dashboards and the critical need of it
You will be able to format your tables in terms of font type and size along with changing the style of representing your data.
You will also be able to format your specific cells in terms of colors and fonts along with adding different type of borders
You will learn all the ways to add, move, delete columns and rows
You will learn the use of format painter and the ways to use it on single and multiple cells, rows or columns
You will be able to apply different alignment styles on your cells
You will be able to understand and apply various number of number's formats for different uses
You will be able to understand and apply HLOOKUP formula and find it's power in dynamic reporting
You will be able to understand and apply the most useful data validation types in your data
You will be able to understand and apply different type of conditional formatting and you will be able to create your own conditions
You will be able to obtain as many as PivotTables for your row data
You will be able to select PivotTable's representations among different columns from row data
You will understand the need of adding slicers and how it affects your dynamic reports
You will be able to generate as many as charts for your data
You will be able to understand the structure of P/L and link available data to it
Thank you for working out with me along with the course outline and as a bonus for your smart and hard work, i have attached all the worked out files for all the projects in the attachment for your reference
Get ready to discover why this program is designed to become one of the top Microsoft Excel courses available today.
My name is Sadiq Al Lawati, a strategic planning expert with over 15 years of experience helping major companies make smarter, data-driven decisions. With a background in Project Management (PMI-certified), Contract Management, and Budget Management, I’ve worked with complex data every day—and mastered the Excel skills needed to turn that data into clear, powerful insights. Now, I’m here to share those skills with you.
--
Is This Course for You?
Do any of these sound familiar?
1- You feel overwhelmed when working with large datasets.
2- You struggle to analyze data and extract meaningful insights.
3- You find it difficult to build a clean, single-page dashboard.
4- You want your reports to look professional and visually appealing.
5- You think automation and dynamic dashboards are only for experts.
If yes—this course will change the way you use Excel.
---
What You Will Learn
1- We start with a quick and friendly introduction to Excel’s essential tools, features, and formatting—perfect for beginners or anyone needing a refreshers
2- Then we move step-by-step into the real power of Excel:
3- The most important formulas used around the world
4- Practical examples that make every formula easy to understand
5- How to use PivotTables and graphs to build dynamic, interactive reports
6- The secrets behind turning raw data into clear, compelling dashboards
Finally, you’ll apply everything through 5 real-world projects, learning exactly how to create dashboards that are not only functional—but impressive and professional.
---
Why This Course Matters
By the end of this course, you’ll be able to work smarter and faster, not harder.
Whether you're aiming to grow in your career, add valuable skills to your business, or even start a freelancing journey, Excel will become one of your strongest tools.
---
Enroll Now
Join the course, practice what you learn, and unlock the ability to transform everyday data into meaningful insights with confidence.
Let’s start your journey toward becoming an Excel pro.