This course covers the basics of Microsoft Office 2021, focusing on Excel and PowerPoint. By the end of the training, learners will be able to enter and manipulate data in Excel, create and edit slides in PowerPoint, use basic formulas and functions, format text and graphics, and enhance presentations with animations and templates. The teaching method includes video tutorials and practical exercises. The course is designed for anyone looking to understand the fundamentals of Microsoft Office apps.
Overview
Syllabus
Start
Introduction
Excel Basics Overview
Opening Excel and Selecting the Blank Workbook Template
Excel Interface
Entering Data and Using AutoFill
Numbers
Sorting Lists and Saving Files
Basic Formulas
Basic Functions
SUM Function and Function Arguments
AutoSum
Average
MAX and MIN Functions
COUNT Function
IF Function
Relative and Absolute Cell References
Nested IF Functions
Adjusting Column Widths and Formatting Numbers
Using Cell Styles to Format Data
Inserting and Hiding Rows and Columns
Cutting, Copying, and Pasting Data
Inserting New Worksheets, Renaming Tabs, and Printing
Excel Basics Recap
PowerPoint Basics Overview
PowerPoint Interface
Creating Slides
Duplicating and Deleting Slides
SmartArt
Moving Slides
Keyboard Shortcuts
Formatting Graphics and Saving Presentations
Formatting Text and Using the Format Painter
Duplicating Slides and Updating Text
Inserting Images
Formatting Images
Inserting Shapes
Formatting and Aligning Shapes
Grouping Shapes
Animation
Themes
Reviewing with Spell Check and Rehearsing
PowerPoint Takeaways
PowerPoint Basics Recap
Conclusion
Taught by
Learnit Training
