Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Present Like a Pro: Excel Insights & PowerPoint Design

Name: Present Like a Pro: Excel Insights & PowerPoint Design
Rating: 3.5 (10 reviews)

Turn Complex Data into Beautiful, Easy-to-Understand Visual Stories

Created bySadiq Al Lawati

Last updated 12/2025

English

English [Auto],

What you'll learn

Understand the principles of effective business communication
Proper planning of your story line
Structure your business communication like Proffessionals
Select most suitable business reflective colors
Save time whenever you have frequant reporting
Increase the impact and interaction with your dyamic reports
Analyse basic to complex data using MS excel
Create your dynamic dashboard in MS Excel
Connect MS Excel with MS Powerpoint using Think-Cell
Update your reports and business communication using single clicks

Course content

8 sections • 57 lectures • 3h 42m total length

Getting Started4:38
You will be able to understand the main concept of the course and with complete guide on business presentation and brief on MS Excel and MS Powerpoint
Effective Business Presentations2:56
The Value of Using MS Excel0:55
The Value of Using MS PowerPoint2:04
Explore the value and basics of Microsoft PowerPoint, including ease of use, versatile applications for slides, business content, resumes, infographics, and designing clear, shareable presentations.

Engage Your Audiences1:51
You will be exposed to some interesting information and details on the ways to engage your audiences along with understanding the most organized ways to structure your business presentation along with detailed explanation on each section of it
The Most Attractive Presentation's Structure1:11
Structure your presentation with a clear flow and a proven storyline to engage audiences and boost outcomes. Treat your talk as a puzzle that shapes data into a picture.
Part.1: Welcoming and Introduction0:45
Part.2: The Overview Outlook0:28
Explore the helicopter view to present the big picture of your subject, focusing on the top aspects to prepare the platform and attract attention.
Part.3: Deep Dive Into Your Subject0:22
Part.4: Performance Measures & Monitor0:31
Identify core performance measures and monitoring at the heart of your presentation, then explain exact and detailed performance information, dive into specific areas, and derive findings to drive outcomes.
Part.5: Wrapping Up & Way Forward0:33

ABC of MS Excel9:54
You will watch a fast recap of 10 min on MS Excel and this is very essential for beginners along with main highlights on formatting your data, using data validation, conditional formatting, name manager and other interesting formulas that is widely used to create dashboards along with direct practicing on real example to create dashboard
Understand & Apply Formatting9:19
Master practical Excel formatting to prepare a dynamic dashboard for PowerPoint by styling headers, fonts, colors, alignment, borders, merging cells, and using format painter, plus converting percentages to numbers.
Data Validation5:18
Apply data validation in Excel to ensure accurate data entry using drop-down lists sourced from a predefined range, preventing typos and invalid entries.
Conditional formatting3:47
Learn to use conditional formatting to highlight duplicates, set value ranges, apply top ten items, above-average highlights, data bars, and color heat maps for clear data insights.
Name Manager & "MATCH" Formula4:32
Use name manager to define students and year ranges, then build a dashboard with match and offset, plus data validation, to show the last three years for the selected year.
"OFFSET" Formula3:06
The Magic of "HLOOKUP" Formula5:05
Creating & Testing Interactive Dashboard0:58

ABC of MS PowerPoint8:50
You will watch a fast recap of 9 min on MS PowerPoint and this is very essential for beginners along with main highlights on selecting the theme and matching it with suitable color combinations and the way to structure your presentation and change layouts along with adding various range of objects
Selecting The Theme3:17
Merge & Select Suitable Color Combinations3:31
Structuring Main Sections3:40
Learn how to structure a presentation by creating and renaming sections like introduction, body, analysis, and conclusion, assign slides to each section, and prepare the outline before beautifying the slides.
Changing Layout1:05
Master layout changes in PowerPoint by choosing from title slide, title and contents, or section header, then switch to a blank layout to insert new objects.
Adding Multiple Objects4:53

What is Think-Cell?0:56
I will take you step by step in knowing and understanding all about the new software called Think-Cell and you will also be able to follow the steps to get 30 days Free trial for the software
You will also be able to compare it with the other software's along with understanding the main graphs and how to format them and how to extend the power of enabling measurement and analysis tools
Why is Think-Cell Essential to Business Communication?1:06
Main Differences Between Think-Cell & Other Graphs0:54
Subscribe for FREE Trial & Follow The Course3:50
Main Graphs in THINKCELL1:28
Formatting Graphs2:32
Adding Powerful Analysis Tools5:43

Create Charts5:48
We will move here to show the ways to create both ways charts and compare between both charts along with showing the way to update new added data
You will be able to understand and download a very useful reference that will show most important chart types and the way to tabulate your data
Master Reference for Creating Charts in Excel & Think-Cell5:28
Comparison Between Excel & Think-Cell Charts3:59
Updating New Data in Excel & Think-Cell1:53

About The Project1:24
We will dive here to apply all what we have learned in the previous lectures into a real example step by step started from understanding the project, obtaining input and output, structuring the business presentation, selecting themes and colors, designing all sections and preparing the same for your charts and content along with applying the row file , formatting it, creating the summary sheet, creating dashboard and creating the suitable charts along with formatting them and enabling analysis tools and ending with adding suitable content in the designed areas
The example will also be repeated in ready made file worked out with MS Excel instead of Think-Cell
Given Inputs and Outputs1:17
Structuring My Presentation3:27
Selecting Theme & Colors1:08
Select themes and colors using the design ribbon, choosing from multiple designs for a beautiful or official look, and ensure the colors reflect the theme in the figures and charts.
Part.1: Welcoming and Introduction4:52
Part.2: Project's Overview2:23
Part.3: Deep Dive Into The Project4:19
Part.4: Measuring & Monitoring Factory Performance3:36
Visualize factory performance with sales units and revenue graphs, compare quarterly results, correlate quantities with revenues, and analyze production models and colors performance.
Part.5: Wrapping Up & Way Forward3:14
Understanding & Formatting Input Data Sheet7:19
How to Create Summary Source?5:05
Group market data into totals like revenues and prices, and copy-link them to a dashboard. Use the summary file as dashboard source and apply serial numbers and a lookup function.
Implementing Name Manager, Data Validation, Match and Offset Formulas6:18
Learn to build dynamic Excel dashboards by using name manager to define quarters, apply match and offset formulas, and implement data validation for seamless quarter selection.
Creating Dynamic Dashboard Using MS Excel Formulas17:41
Create a dynamic excel dashboard with lookup formulas, fixed ranges, and linked data to compare market revenues, industry and company performance, then present charts in PowerPoint.
Creating Think-Cell Graphs in PowerPoint8:12
Create compelling think-cell graphs in PowerPoint by inserting column charts, waterfalls, donuts, pies, and scatter charts to visualize market performance, revenues, and vehicle sales.
Formatting Graphs and Enabling Tools and Functions14:49
Format and customize charts using analysis tools, colors, axes, legends, and display options to reveal trends, growth, and market shares.
Tips to Add Comments and Wording to Obtain Professional Business Presentation9:03
Updating Next Quarter Report by Updating Graphs With Simple Clicks4:35
Update the next quarter report by updating graphs with simple clicks in PowerPoint using Think Cell, automatically refreshing numbers, averages, and formatting for Q2 twenty one and Q3.
Re-Doing Business Presentation Using Excel Charts3:05

Requirements

Microsoft Excel 2007 + (Note: Some features may not be active in earlier versions)
Microsoft Powerpoint 2007 + (Note: Some features may not be active in earlier versions)
Basic data analysis understanding
Basic computer
Trial Version of THINKCELL from their website (Try it Free) - Steps included in details

Description

Hello everyone,

Welcome to this course.

I’m Sadiq Al Lawati, a strategic planning and corporate performance expert with experience across several leading companies. With over 15 years working in Excel and PowerPoint, and a background in Project Management (PMI certified), Contract Management, and Budget Management, I have spent my career turning complex data into clear and effective business presentations.

In my recent role, I began using Think-Cell, a tool that changed the way I prepare reports. It helped me reduce preparation time by 70–80% and create more professional, impactful presentations. This course will teach you how to use the same approach to work faster and communicate more effectively.

This program is designed to help you build strong business presentation skills by combining PowerPoint, Excel, and the Think-Cell Bridge app. Whether you want to advance in your job or improve your business communication, you will gain practical techniques that save time and improve the quality of your work.

---

Do You:

1. Feel overwhelmed by large datasets?

2. Struggle to analyze information clearly?

3. Find it difficult to organize your presentations?

4. Have trouble creating attractive charts and visuals?

5. Face challenges when presenting to senior management?

6. Find it hard to keep your audience interested?

if yes, this course will help you overcome all these challenges.

---

What You Will Learn

1. Business Communication Basics

1. The fastest way to improve your communication style.

2. Simple methods to structure your presentation materials.

3. How to organize your message clearly and professionally.

2. Essential Tools for Better Presentations

1. A practical review of Excel for business reporting.

2. A practical review of PowerPoint for presentation design.

3. A step-by-step introduction to Think-Cell and how to activate the free 30-day trial.

3. Real-Life, Hands-On Practice

1. Examples based on real business situations.

2. How to build simple, interactive dashboards in Excel.

3. How to design effective, professional slides using PowerPoint and Think-Cell.

4. Creating High-Quality Visuals

1. How to create clear and professional charts, tables, and graphs.

2. Best practices for slide design and content layout.

3. How to update all your charts and tables automatically with one click.

---

This course will give you practical knowledge you can apply immediately at work. You will learn how to prepare presentations smarter and faster, not harder.

Enroll now, stay engaged, and start building skills that can help you grow in your career—or even start a freelancing journey.

Who this course is for:

Any person looking to own a unique skill that promotes his skills
Any employee looking to promote his/her career
Business Owners looking to have faster and professional reports
Organizations looking to change their business communication pattern

Present Like a Pro: Excel Insights & PowerPoint Design

What you'll learn

Explore related topics

Course content

Introduction4 lectures • 11min

Business Presnetation Structures7 lectures • 6min

The Value of Excel in Business Presentations8 lectures • 42min

The Value of PowerPoint in Business Presentations6 lectures • 25min

How Can Think-Cell Be Effective in Business Presentations7 lectures • 16min

Build A Bridge Between Excel & PowerPoint4 lectures • 17min

Real Life Project Application - Automobile Factory18 lectures • 1hr 42min

Thank You and Congratulations3 lectures • 3min

Requirements

Description

Who this course is for: