Microsoft Office Essential Word Excel PowerPoint Course

Name: Microsoft Office Essential Word Excel PowerPoint Course
Rating: 4.2 (5 reviews)

Learn Word Excel PowerPoint All Together

Created byMarc Schmidt

Last updated 12/2022

English

What you'll learn

Function, Features, Tools and Uses of PowerPoint
Function, Features, Tools and Uses of Word
Function, Features, Tools and Uses of Excel
Project Preparation in Word, Excel, Powerpoint

Course content

3 sections • 74 lectures • 12h 2m total length

Introduction1:33
Getting started with Powerpoint15:04
Slides9:03
Font14:49
Explore how to format text with fonts, sizes, and colors in Word. Master bold, italic, underline, shadow, and advanced options like character spacing, change case, highlights, and clear formatting.
Paragraph12:14
Drawing10:50
Explore drawing tools in PowerPoint, creating shapes and text boxes, applying quick styles, fill, outline, and effects, and mastering arrange, align, and rotate for polished slides.
File and Home15:58
Explore the PowerPoint file and home tab, navigate the file menu to apply themes, save in ppt, pdf, png, or jpeg, and share, print, and protect your presentations.
Insert Image Table24:05
Illustration15:06
Add Ins2:58
Learn to use add ins in PowerPoint: install from the store, add to slides, manage via the ribbon, and delete or reload as needed.
Text14:04
Transitions and Animation10:44
Slide Show10:55
View8:47
Project56:36
Create a PowerPoint presentation by applying the 14 lesson sequence on slides, themes, text sizing, images, shapes, charts, SmartArt, links, transitions, and saving the project.

Getting Started with Word6:52
Create a Word Document2:52
Add and Edit a Template19:51
Navigate and Select Text2:48
Modify Text3:12
Find and Replace Text3:14
Formatting Text and Paragraphs4:10
Learn to format text in Word by changing font designs, size, color, and applying bold, italic, and underline, and format paragraphs with alignment, indents, spacing, and line breaks.
Apply Character Formatting6:06
Align Text Using Tabs7:45
Learn to align text using tabs by setting tab stops in selected paragraphs, then using left, center, right, decimal, and bar tab stops with optional leaders.
Display Text as List Items2:05
Control Paragraph Layout4:38
Borders and Shading2:25
Apply Styles5:19
Explore applying built-in styles to text and creating a custom style in Word. Build a blue bold italic underline style named 'Formatting Style' and apply it from the home tab.
Manage Formatting4:59
Adding Tables2:13
Insert a Table2:29
Modify a Table2:13
Format a Table4:47
Learn to format a table in Word by inserting, resizing, and organizing cells; merge and split cells, delete or insert rows and columns, and apply borders, shading, and alignment.
Convert Text to a Table2:21
Managing Lists2:23
Inserting Graphic Objects1:57
Learn how to insert graphical objects in Microsoft Word by using SmartArt and charts, selecting designs from categories like process and cycle, and applying them to your document.
Insert Symbols and Special Characters1:41
Add Images to a Document1:40
Apply a Page Border and Color1:23
Add a Watermark2:00
Learn to add and customize watermarks in Word using the design menu, choosing built-in or custom, and adjust text or picture watermark settings such as font size and layout.
Add Headers and Footers4:52
Use of Macro15:45
Pictures and Text Wrapping7:20
Spelling and Grammar8:06
Practice spelling and grammar with Word's proofing tools, using F7 and the spelling and grammar dialog, accept or ignore corrections, and explore word alternatives and word count for document accuracy.
Track Changes and Comments6:52
Using Mail Merge13:36
How to Page Setup5:58
About MS Word12:17

Introduction2:04
Explore Microsoft Excel’s core tools for data entry, data management, accounting, financial analysis, and charting, including pivot tables and macros, plus basic functions and formatting.
Excel Introduction3:50
Opening new workbook and worksheet8:34
Excel Menu Introducement5:47
Saving data4:01
Save your workbook to the PC or OneDrive by signing in to your Microsoft account, then use Ctrl+S or Save As and choose formats like Excel workbook or PDF.
Errors10:42
Logical functions28:27
Explore Excel's logical functions, testing true or false across conditions to drive calculations and display results, including and, or, not, xor, switch, and practical examples.
If functions18:32
If and ifs usage of calculating letter grade10:00
Filter function4:41
Date functions16:51
Now and today func2:54
Time Function11:42
Mathematical func36:26
Explore essential Excel mathematical functions such as count, round, sum, average, subtotal, power, mod, trunc, int, min, and max with practical, data-driven examples.
Text Function25:01
Lookup functions34:02
Hyperlink8:10
Google spreadsheet3:31
Explore Google spreadsheet in your web browser, collaborate in real time, and detect language in data using the detect language function.
Converting number into words5:08
learn to convert numbers into words in excel using the currency to English function, enable the developer tab, paste vba code in a module, and save as a macro-enabled workbook.
Drop down list5:53
Graph and chart10:59
Piviot Table35:16
Work sheets and workbook7:57
Sharing and collab11:49
Page settings6:38
Print4:48

Requirements

Understand English
Able to run computer

Description

This an essential office course where you will learn essential Microsoft Word, Powerpoint and Excel.

This is a course from beginning to advanced and you will be able to start from the very beginning to expert level. This course will teach you all the essential skills of Microsoft Word, Excel, Powerpoint so you will have all the essential skills in one courses.

This course is intended for beginner and inexperienced designers, who aspire to learn Microsoft Word, Excel, PowerPoint for professional or private use. No matter if you want to add a new skill to your portfolio, create videos, impress at work or start beeing an online entrepreneur. If you have very little experience with the software or are a total beginner and this will be the first time you open the software - this is the right course for you!

Lets take a look what you will learn from this course:

In Microsoft Word Section:

You will learn all the functions, tools, menus, uses so once you will complete Microsoft word section you will an expert of Microsoft word.

In Microsoft Excel Section:

You will learn excel functions, formulas, vlookup, hlookup, tools, menus, uses and many more so once you will complete Microsoft excel course you will be an expert of Microsoft Excel

In Microsoft Powerpoint Section:

You will learn all the essentials functions, creating slides, projects, tools, menus, uses and many more so once you will complete Microsoft powerpoint course you will be an expert of Microsoft powerpoint

Who this course is for:

Beginner who want to learn word excel powerpoint

Microsoft Office Essential Word Excel PowerPoint Course

What you'll learn

Explore related topics

Course content

Microsoft Powerpoint15 lectures • 3hr 43min

Word33 lectures • 2hr 56min

Excel26 lectures • 5hr 24min

Requirements

Description

Who this course is for: