This 9-hour Microsoft Office tutorial covers Microsoft Excel, PowerPoint, and Word, providing a solid grounding in these applications. The course includes downloadable exercises for practical application. The learning outcomes include mastering Excel functions, PowerPoint presentation creation, and Word document formatting. The course teaches skills such as creating formulas, working with slides, and editing documents. The teaching method involves video tutorials with practical exercises. This course is intended for beginners new to Microsoft Office, individuals needing basic skills for work or school, or anyone looking to enhance their proficiency in Excel, PowerPoint, and Word.
Overview
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
Related Courses
-
MS Office; Excel, Word, Access & PowerPoint 2019 - Beginners
-
Microsoft Excel, PowerPoint and Word 2016 for Beginners
-
Microsoft Office 365 | Ultimate Bootcamp 2023
-
Ultimate Microsoft Office; Excel, Word, PowerPoint & Access
-
Microsoft Office Word, Excel, Power Point | For Beginners
-
Microsoft Office Complete Course | All in one MS Office
Related articles
Reviews
4.8 rating, based on 11 Class Central reviews
-
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
-
Muhammad Waleed1. "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." -
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… -
Varun PothrapallyIt 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. -
M Asaryvery useful for me, because I really need to learn such courses in detail and clearly,
and also very helpful for my future performance -
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!
-
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.
-
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 Islamit 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 VENKATAKISHOREGreat learning place for beginners, well understanding explanations and videos. It would be very useful for students and employees to get a certificate. -
Farida HanapiThe 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.
