Microsoft Power Point and Excel from Beginner to Advanced

Name: Microsoft Power Point and Excel from Beginner to Advanced
Rating: 5.0 (32 reviews)

Master Microsoft Excel, Power Point from beginner to Advanced | Complete Microsoft Excel and Power Point with Projects

Highest Rated

Created byB Lakshmi R

Last updated 7/2026

English

What you'll learn

Master Microsoft Excel from beginner to advanced level by learning formulas, functions, charts, PivotTables, data analysis, dashboards, and productivity-enhanci
Create professional and visually engaging Microsoft PowerPoint presentations using themes, slide layouts, animations, transitions, multimedia, and presentation
Analyze, organize, and present data effectively by combining Excel's powerful analytical capabilities with PowerPoint's presentation and storytelling features.
Build practical workplace skills through hands-on projects and real-world business scenarios, enabling you to create reports, dashboards, and impactful presenta

Course content

3 sections • 41 lectures • 22h 46m total length

Introduction6:06
Master Microsoft PowerPoint and Excel from beginner to advanced, learning to design professional presentations, analyze data with advanced formulas, create dashboards, and automate tasks.

PowerPoint Basics33:51
Discover the fundamentals of PowerPoint by learning how to create, edit, and format slides to build effective presentations.
Presentation Core Elements59:48
Explore the core elements of a presentation in Microsoft PowerPoint, as covered in a beginner to advanced course on Microsoft PowerPoint and Excel.
Organizing Core Elements29:40
Additional Presentation Elements & Tools30:31
Tables, Charts & Excel Data25:40
Animations & Transitions18:59
Explore creating and refining animations and transitions in PowerPoint, including entrance, emphasis, exit effects, motion paths, triggers, timing, and slide transitions to enhance storytelling.
Design Aesthetics32:02
Explore design aesthetics to create engaging PowerPoint slides. Master visual styling and layout for effective presentations in the Microsoft PowerPoint and Excel course.
Presentation Aesthentics27:18
Presenting34:09
Master presenting with PowerPoint and Excel fundamentals, delivering clear, engaging slides and data visuals from beginner to advanced techniques.
Reviewing & Customizations16:29
Review and customize PowerPoint decks using spell check, thesaurus, accessibility checks, and the compare tool; personalize themes, fonts, colors, and the quick access toolbar for efficient, accessible presentations.
Presentation Aftermath28:04

Excel 10139:50
Formatting42:34
Master formatting in Microsoft PowerPoint and Excel from beginner to advanced, enabling polished slides and spreadsheets with clear layout and professional visuals.
Conditional Formatting22:15
Master conditional formatting in Excel by creating rules that auto color and highlight cells based on values, text contains, or duplicates. Use top bottom rules, color scales, and managing rules.
Data Clearning55:42
Functions1:02:26
Explore functions in Microsoft Power Point and Excel, covering topics from beginner to advanced levels.
Functions Mixology in Excel27:40
New Functions Introduced By Microsoft40:33
Business Finance Functions23:32
Learn how to apply Excel finance functions such as FV, FV schedule, PV, NPV, XNPV, IRR, MIRR, XIRR, NPER, RATE, and PPMT to model investments, loans, and cash flows.
Business Finance Functions38:35
Learn how to use Excel and PowerPoint to perform essential business finance functions, from basic calculations to advanced financial analysis and presentation of results.
Pivot Tables22:23
Lookup Functions29:01
Reviewing & Troubleshooting33:21
Develop essential skills in Microsoft Power Point and Excel by reviewing core features and troubleshooting common issues from beginner to advanced levels.
Customizations & Collaborations17:06
Customize the ribbon and quick access toolbar, adjust autocorrect, and enable autosave, then learn cross-application collaboration with PowerPoint and Word using paste special and linked objects.
Creating Macros Using VBA18:02
Learn to automate Excel tasks with VBA and macros in the Visual Basic for Applications editor, including recording macros, saving as macro-enabled workbooks (.xlsm), and using objects, properties, and methods.
Excel Dashboard in Micrsoft Excel36:06
Excel Dashboard in Micrsoft Excel53:26
Build an Excel dashboard in Microsoft Excel to present data visually and track key metrics.
Tips and Tricks in Microsoft Excel6:38
Master Excel with practical tips that boost efficiency, including autofill, flash fill, keyboard shortcuts, quick analysis, and essential tools like formatting, tables, and data validation.
Advanced Pivot Tables44:05
Master advanced pivot tables in Excel to summarize large data sets, analyze trends, and create dynamic reports for better decision making.
Advanced Uses of LookUp Functions1:00:45
Explore advanced uses of look up functions to streamline data retrieval and analysis in Excel, as part of the Microsoft Power Point and Excel course.
VBA Foundations1:02:37
Build VBA foundations for PowerPoint and Excel, guiding learners from beginner concepts to advanced techniques.
Writing VBA Code39:05
Master writing VBA code to automate tasks in PowerPoint and Excel, advancing from beginner to expert.
Your VBA Tool Kit25:49
Explore VBA toolkit to master popular functions, VBA library, and how VBA differs from Excel; learn looping, for each, for next, variable declarations, if statements, select case, and file handling.
Debugging18:23
Beautifying Code43:05
Beautify code in Microsoft PowerPoint and Excel, from beginner to advanced.
UserForms & ActiveX Controls35:29
Explore UserForms and ActiveX controls to build interactive forms and automate tasks within PowerPoint and Excel, as part of a beginner to advanced course.
Importance of Excel5:25
Explore how Excel organizes data with rows and columns, speeds up calculations through formulas, and visualizes insights with charts. Automate repetitive tasks with macros to boost productivity.
Creating Your OWN Functions18:36
Learn to build user defined functions in Excel, or diy functions, by adding a module and public function procedures, using optional arguments, with examples like ColorSum and biz age.
Productivity Hacks1:05:10
Master productivity hacks for Power Point and Excel. From beginner to advanced, apply practical tips to improve workflow.
Financial Modeling Tools35:55
Explore financial modeling tools in Excel to build robust models and analyze financial scenarios, from beginner to advanced levels.

Requirements

You do not need to have any experience at all. You will learn Microsoft Excel and Power Point from beginner to Advanced

Description

Unlock the full potential of Microsoft Excel and PowerPoint with this comprehensive beginner-to-advanced course designed to help you build essential workplace and productivity skills. Whether you are a student, job seeker, business professional, entrepreneur, or office administrator, this course will equip you with the practical knowledge needed to create powerful spreadsheets and impactful presentations.

In the Microsoft Excel section, you will learn everything from spreadsheet fundamentals to advanced data analysis techniques. Master formulas, functions, charts, PivotTables, conditional formatting, data visualization, dashboards, and productivity tools that help you organize, analyze, and present data effectively.

In the Microsoft PowerPoint section, you will learn how to create professional presentations that capture attention and communicate ideas clearly. Explore slide design principles, themes, layouts, animations, transitions, SmartArt, multimedia integration, and presentation delivery techniques that will help you create engaging and visually appealing presentations.

Through hands-on exercises, practical examples, and real-world projects, you will gain the confidence to use Excel and PowerPoint in academic, business, and professional environments. By the end of this course, you will be able to analyze data, create insightful reports and dashboards, and deliver compelling presentations that make a lasting impression. No prior experience is required—just a willingness to learn and develop valuable skills that are highly sought after in today's digital workplace.

Who this course is for:

It is for anyone who wants to learn Microsoft Excel and Power Point from beginner to Advanced

Microsoft Power Point and Excel from Beginner to Advanced

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 6min

PowerPoint - Beginner to Advanced11 lectures • 5hr 37min

Microsoft Excel - Beginner to Advanced29 lectures • 17hr 4min

Requirements

Description

Who this course is for: