Chứng chỉ MOS Excel 2019 - Exam MO-200 Microsoft Excel
TS. Dang Xuan Tho
5.0 (500)·6h 10m · 91 lectures
$3.00$12–$199up to −98%
Loading course
Microsoft Office for Mac: Excel, Word, Power Point + Copilot
3 in 1 Bundle Pack: Microsoft Excel for Mac, Microsoft Word for Mac, Microsoft PowerPoint for Mac: Office 365 on macOS
5.01 reviews12 learners
- All Levels
- 21h 6m video
- 121 lectures
- English
- Updated 2026
Taught by Being Commerce
- 21h 6m of on-demand video
- 121 lectures across 5 sections
- One-off payment — no subscription
- Lifetime access on web and mobile
- English audio
Curriculum
5 sections122 lectures21h 6m total
- Microsoft Office for Mac: 3 Bundle with Microsoft Copilot AI0:58
- Microsoft 365 Account Setup8:39
- Understanding the Interface of Microsoft Word5:34
- Creating a Document7:37
- Draft with Microsoft Copilot9:38
- Editing a Document15:58
- Formatting a Document18:54
- Advanced Editing - Layouts14:53
- Advanced Formatting - Design16:17
- Insert Tables - Different Ways to Insert Tables5:37
- Design and Customize Tables - Table Design & Layout18:14
- Data Sorting for Organize & Analysis Data with Copilot11:02
- Insert Images for Illustrations12:11
- Insert Shapes for Illustrations8:40
- Insert Smart Art for Illustrations2:47
- Insert Media for Illustrations4:44
- Add Headers, Footers & Page Numbers8:45
- Add Equation Editor and Symbols5:01
- Table of Content7:34
- Foot Notes and End Notes3:47
- Cross Reference and Citations8:59
- Bibliography - Manage Sources12:11
- Review - Track Changes, Version History & Comments8:33
- Password Protect - Restrict Access with Password3:20
- Concept of Mailing: Step by Step7:10
- Mail Merge and Print Wizard10:18
- Different View Settings for macOS6:19
- Difference Between Microsoft Word and Google Docs & Apple Pages11:08
- Microsoft Word Templates - CV as Example5:32
- Sharing and Export your Microsoft Word Document8:44
- Getting Started with Word and Copilot2:12
- Draft Documents with Microsoft Copilot5:30
- Draft Documents with Outlines with Microsoft Copilot4:59
- Edit & Change Text and Tone in Word with Microsoft Copilot4:21
- Revise Edits to your Word Documents with Microsoft Copilot6:37
- Ask Questions on Word Documents with Microsoft Copilot3:14
- Create Artifacts like Summarize, Quiz, Email and More with Microsoft Copilot5:49
- Transform Text into Table with Microsoft Copilot7:47
- Amazon Kindle Direct Publishing - Concept2:50
- Format a Book in Microsoft Word for Amazon KDP (Ebook Version)28:15
- Converting to Paperback (Paperback Version)9:42
- Understanding the Interface of Microsoft PowerPoint8:14
- Understanding PowerPoint UI6:42
- Managing, Duplicate & Layouts of Slides5:29
- Adding Text to Layouts & Formatting4:53
- Text Formatting From Scratch8:28
- Insert Images and Icons to Layout + Format11:50
- Insert Tables into Slides + Format11:45
- Insert Charts & Manage Datas14:20
- Insert Media: Audio & Video & Recording15:55
- Insert Action Buttons & Hyperlinks12:36
- Insert Smart Art & Shapes5:09
- Apply Animations13:19
- Apply Design3:33
- Apply Transitions6:56
- Slide Master and Operations4:35
- Advanced Formatting Options4:33
- Categorize into Sections4:40
- Fundamentals of Copilot for PowerPoint1:20
- Create Presentation from Scratch with Microsoft Copilot11:36
- Get Brain Storming Ideas for Presentation with Chat5:25
- Add New Slides to Existing Template PPT3:51
- Generate New Slides on The Basis of Topic8:36
- Create Presentations from Word Documents5:26
- Summarize & Translate any Presentation in One Click3:29
- Edit Slides of Presentation using Microsoft Copilot4:23
- Using AI Addon inside PowerPoint14:26
- Explore and Trying More AI Addons15:02
- Rules: Designing and Fixing Layout in PowerPoint11:15
- Action: Designing and Fixing Layout in PowerPoint7:54
- Introduction to Course Project1:32
- Master Slides, Cover Design & Overlays9:17
- Add Text to Slide in Professional Way16:11
- Animate the Object & Text Flow Design7:42
- Draw in PowerPoint6:27
- Header & Footer5:10
- Mathematical Equations2:38
- Creating First Excel Sheet8:34
- Download Resources2:35
- Rows, Columns, and Cells6:27
- Menus, Sheets, Undo, Footer9:04
- Cells, Commands, Mode, Arrows14:59
- Formatting Excel Cells & Commands12:42
- Basis of Formula From Scratch11:30
- Max, Min, Avg, % and More11:49
- Conditional Formatting26:40
- Sorting Data in Excel20:17
- Filter in Excel37:17
- Data Validation18:25
- Data Tools17:24
- Sheet & File Protection18:08
- Find, Replace & Special11:18
- Printing & Export as PDF12:24
- Excel Pivot Table18:59
- Excel Pivot Charts14:45
- Slicer & Settings20:23
- Timeline in Pivot Table6:22
- Grouping & Custom Grouping11:47
- Pivot Table Options and Settings23:38
- Show Values As19:48
- Calculated Fields15:45
- Filters & Filter Reports Page7:53
- Dynamic Pivot Tables16:31
- Pivot Table on Multiple Sheets8:31
- GETPIVOTTABLE Formula10:05
- Excel Dashboard Project - Overview2:07
- Create Pivot Tables8:42
- Create Pivot Charts8:10
- Create Slicer & Dashboard12:11
- Excel Functions & Formulas1:15:30
- Power Query Editor - Data Analysis27:10
- Setting Up Environment1:48
- Copilot for Formula - Hack 18:45
- Logic, Condition & Formula - Hack 29:17
- Copilot for Search Calculation - Hack 310:32
- Data Cleaning - Hack 45:41
- Analyze Data, Pivot Table & Charts - Hack 55:35
- Streaming with Copilot11:11
- Sorting, Filter and Fun with Copilot12:34
- Income, Expense and Saving - Tracker17:28
- Role Play0:00
- Bonus0:57
About this course
If you use a Mac and want full control over Microsoft Office for Mac, this course gives you real skills you can use at work, in business, or for personal projects — not just surface-level tips. Most Mac users only scratch the surface of Word, Excel, and PowerPoint. They know how to type, make a few slides, or add basic formulas. But when it comes to clean reports, strong presentations, smart dashboards, or working faster with AI, they often feel stuck. This course changes that. You will go step by step through M…
Before you start
- A Mac computer (macOS)
- Microsoft Office for Mac or Microsoft 365 for Mac installed
- Basic computer skills (mouse, keyboard, file saving)
- No prior experience with Word, Excel, or PowerPoint is required
Who it’s for
- Students who want strong document, data, and presentation skills
- Office workers who use Microsoft Office on Mac every day
- Business owners who create reports, trackers, and presentations
- Freelancers and remote workers who share files with clients
- Job seekers who want to improve their software skills for work
- Anyone moving from Windows to Office for Mac
Related
More in Office Productivity
Ôn thi Chứng chỉ MOS Word 2019 - Exam MO-100 Microsoft Word
TS. Dang Xuan Tho
5.0 (467)·5h 36m · 79 lectures$3.00$12–$199up to −98%The AI-Powered Business Writing & Communication Guide
Emmanuel Essien
5.0 (178)·1h 32m · 12 lectures$3.00$12–$199up to −98%Productivity Masterclass: Master GenAI Workflows
Emmanuel Essien
5.0 (157)·2h 51m · 18 lectures$3.00$12–$199up to −98%
$3.00$12–$199