Office 2021 Basics - Excel & PowerPoint

Dive into a comprehensive tutorial on Microsoft Office 2021 basics, focusing on Excel and PowerPoint. Learn essential skills for data manipulation, calculations, and presentation creation. Start with Excel fundamentals, including data entry, AutoFill, sorting, and saving files. Master basic formulas, functions like SUM, AVERAGE, MAX, MIN, COUNT, and IF, as well as cell referencing. Explore formatting techniques, cell styles, and worksheet management. Then, transition to PowerPoint, understanding its interface and slide creation process. Discover how to work with SmartArt, format text and graphics, insert and manipulate images and shapes, and apply animations and themes. Conclude with reviewing and rehearsing techniques to polish your presentations. Ideal for beginners seeking to enhance their productivity with Microsoft Office applications.

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