Главная
Study mode:
on
1
Start
2
Introduction
3
Excel Basics Overview
4
Opening Excel and Selecting the Blank Workbook Template
5
Excel Interface
6
Entering Data and Using AutoFill
7
Numbers
8
Sorting Lists and Saving Files
9
Basic Formulas
10
Basic Functions
11
SUM Function and Function Arguments
12
AutoSum
13
Average
14
MAX and MIN Functions
15
COUNT Function
16
IF Function
17
Relative and Absolute Cell References
18
Nested IF Functions
19
Adjusting Column Widths and Formatting Numbers
20
Using Cell Styles to Format Data
21
Inserting and Hiding Rows and Columns
22
Cutting, Copying, and Pasting Data
23
Inserting New Worksheets, Renaming Tabs, and Printing
24
Excel Basics Recap
25
PowerPoint Basics Overview
26
PowerPoint Interface
27
Creating Slides
28
Duplicating and Deleting Slides
29
SmartArt
30
Moving Slides
31
Keyboard Shortcuts
32
Formatting Graphics and Saving Presentations
33
Formatting Text and Using the Format Painter
34
Duplicating Slides and Updating Text
35
Inserting Images
36
Formatting Images
37
Inserting Shapes
38
Formatting and Aligning Shapes
39
Grouping Shapes
40
Animation
41
Themes
42
Reviewing with Spell Check and Rehearsing
43
PowerPoint Takeaways
44
PowerPoint Basics Recap
45
Conclusion
Description:
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.

Office 2021 Basics - Excel & PowerPoint

Learnit Training
Add to list
#Business #Business Software #Microsoft Office 365 #Microsoft Excel #Microsoft Powerpoint #Art & Design #Visual Arts #Animation #Data Science #Data Manipulation #Computer Science #Text Formatting
0:00 / 0:00
1 of 45

Start