Microsoft Office Tutorial - Learn Excel, PowerPoint and Word

Overview

Embark on a comprehensive 9-hour journey through Microsoft Office, mastering Excel, PowerPoint, and Word. Gain a solid foundation in essential skills for work or school, from basic formulas and data manipulation in Excel to creating engaging presentations in PowerPoint and formatting professional documents in Word. Practice with downloadable exercises to reinforce your learning. Explore features like backstage view, file management, object formatting, SmartArt creation, and document navigation. Perfect for beginners, this tutorial covers everything from basic operations to advanced techniques, ensuring you become proficient in these crucial productivity tools.

Syllabus

- Intro to Excel
- What's New in Excel
- Course Overview
- Overview of the Excel Window
- Mouse Features
- BackStage View in Excel
- Text and Numbers
- Creating Basic Formulas
- Relative References
- Order of Operations
- Working with Ranges
- Practice Exercise
- Working with Save and Save As Commands
- File Extensions, Share, Exports & Publish Files
- Practice Exercise
- Opening a File
- Working with Larger Files
- Freeze Panes
- Split Screen
- Practice Exercise
- Headers & Footers
- Print Titles
- Comments in Excel
- Page Setup Options
- Fit to Print on One Page
- Printing Workbooks
- Practice Exercise
- Adding and Deleting Cells
- Chaing Column and Row Widths
- Practice Exercise
- Cut, Copy and Paste
- Copying Formulas
- Practice Exercise
- Overview of Formulas
- Create Formulas Using Functions Part 1
- Create Formulas Using Functions Part 2
- Absolute Values
- Practice Exercise
- Adding, Deleting, and Remaining Sheets
- Additional Sheet Tab Options
- Dimensional Functions
- Practice Exercise
- PowerPoint Welcome and Overview
- Navigating a PowerPoint Presentation
- Overview of the Screen and the Views
- PowerPoint Exercise 01
- Presentation Tips and Guidelines
- Creating New Presentation
- Working with Slides
- Saving Presentation
- PowerPoint Exercise 02
- Formatting Text
- Working with Bullets and Numbered Lists
- PowerPoint Exercise 03
- Inserting Shapes
- Inserting Graphics
- Inserting Icons and 3D Models
- Inserting Pictures
- PowerPoint Exercise 04
- Selecting Objects
- Editing Objects
- Formatting Objects - Part 1
- Formatting Objects - Part 2
- Arranging Objects
- Grouping Objects
- PowerPoint Exercise 05
- Picture Options
- Cropping Pictures
- Formatting Pictures
- Things You Can Do with Pictures
- PowerPoint Exercise 06
- Creating SmartArt
- Modifying SmartArt
- Creating a Flow Chart
- Word Course Overview
- Word Screen
- Backstage View
- Creating a New Document
- Non-printing Characters and Line Spacing
- Saving a Document
- Opening a Document
- Navigating a Document
- GoTo, Find and Replace
- Editing a Document
- Section 2 Practice Exercise
- AutoCorrect Options
- Selecting Text
- Cut, Copy and Paste
- Character Formatting Options
- Format Painter
- Working with Numbers
- Working with Bullets
- Creating an Outline
- Section 3 Practice Exercise
- Alignment Options
- Line Spacing Options
- Working with Indents
- Working with Tabs
- Section 4 Practice Exercise
- Sorting a List

Taught by

Simon Sez IT

Reviews

4.8 rating, based on 19 Class Central reviews

Start your review of Microsoft Office Tutorial - Learn Excel, PowerPoint and Word

Dakshayani

Good and valuable computer course
We know the MS office and Ms word and Ms power point and it is usefull for system operator
Operate the system fastest and it valuable knowledge about computer skills
very useful for me, because I really need to learn such courses in detail and clearly,
and also very helpful for my future performance
Sneak Attack TNT

This was such a thorough course. For someone who has tried to learn these things by trial and error, it blew me away. I plan on retaking this to grasp this information even more.
Tushar Kanta Patel

I literally made me very skillful for excel sheet. I learned about the modules and shortcuts the methods. I got skillfull in the methods and data analysis formats.
Kingsley Ovie

it a little bit difficult but i was able to grab thanks a lot for the class it was really tough,so what next for me please so i can continue the class.
Ouko Ochieng Polycarp

It's very elaborate and easy to understand. The voices are also clear and audible. Videos are HD making it to follow the tutorials.
Nolwazi Nokukhanya Dube

I really enjoy this course it helps me alots ,to other students who would like to do this course I would like to recommend this
Pss Saikiran

Good topics learned a lot i gained new skills and very much happy by learning this course very brief explanation
Jawad Qamar

I have learned a lot in this course and it has benefited me so much that it is not possible to describe in words All wisdom ends on this word that there is no other course like it
Cool Art

"Essential for Productivity - A Must-Have!" Rating: ⭐⭐⭐⭐⭐ (5/5) Microsoft Office has been a game-changer for me both personally and professionally. This suite of applications is nothing short of essential for anyone looking to boost their producti…

"Essential for Productivity - A Must-Have!"

Rating: ⭐⭐⭐⭐⭐ (5/5)

Microsoft Office has been a game-changer for me both personally and professionally. This suite of applications is nothing short of essential for anyone looking to boost their productivity and streamline their work processes.

Word: Microsoft Word is the go-to word processing software for a reason. It's user-friendly, packed with features, and perfect for creating everything from simple documents to complex reports and manuscripts. The collaboration tools are especially handy for team projects.

Excel: Excel is the undisputed king of spreadsheet software. Whether you're managing finances, analyzing data, or creating charts and graphs, Excel makes it a breeze. The array of formulas and functions is truly impressive.

PowerPoint: Creating captivating presentations is a cinch with PowerPoint. The vast library of templates and design tools allows you to make professional-looking slideshows in no time. And the integration with other Office apps is seamless.
Muhammad Waleed

1. "This course exceeded my expectations! The instructor's expertise and engaging teaching style made learning enjoyable and easy to understand. The content was comprehensive, well-organized, and relevant. I highly recommend this course to anyone looking to expand their knowledge."
Farida Hanapi

The instructors were amazing, I learned every single word,and step by steps procedure on how to apply microsoft,how to create a power point,and many more about computer.These online courses is very helpful to every individual who want to learn a new skills.
Varun Pothrapally

It was a informative course to learn. It was a great experience. Good content explained in a well manner. Easy to understand. Covered all the topics in limited time.
Celumusa Mdhladhla

Great course ! The videos are short and easy tou understand making it easy for me to learn.There are many videos but I assure you that they are easy to understand.
M Bhavana

The "Microsoft Office Tutorial: Learn Excel, PowerPoint, and Word - 9 HOUR MS Office Course" on Coursera is an exceptional resource for mastering essential office tools. In just 9 hours, it covers Excel, PowerPoint, and Word comprehensively. The course's clear and concise modules make it easy to follow, even for beginners. The practical exercises and real-world examples enhance proficiency rapidly. Whether you're a student or a professional, this course is a valuable investment in your productivity skills. Highly recommended!
M Asary

very useful for me, because I really need to learn such courses in detail and clearly,
and also very helpful for my future performance
YASIN SHARIEF

Good and valuable computer course
We know the MS office and Ms word and Ms power point and it is usefull for system operator
Operate the system fastest and it valuable knowledge about computer skills
Shafikul Islam

it was a great course. learned a lot from it. though it was long, I enjoyed it.
Thank you so much for this great course.
everyone should try this course. if you are in a hurry .you can go for it
YANDAPALLE VENKATAKISHORE

Great learning place for beginners, well understanding explanations and videos. It would be very useful for students and employees to get a certificate.
Reshad Malikzada

Its useful courses and help us to improve our educational potentioal with this lessons we could study much usefull things that help us in our job career.