Главная
Study mode:
on
1
- Simon Sez IT Intro
2
- Excel 2021 Course Introduction
3
- Excel 2021 vs. Excel 365
4
- Launching Excel
5
- The Start Screen
6
- Exploring the Interface
7
- Ribbons, Tabs, and Menus
8
- The Backstage Area
9
- Quick Access Toolbar
10
- Useful Keyboard Shortcuts
11
- Getting Help
12
- Exercise 01
13
- Working with Templates
14
- Workbooks and Worksheets
15
- Saving Workbooks
16
- Entering and Editing Data
17
- Cells, Rows, and Columns
18
- Exercise 02
19
- Formulas and Functions Explained
20
- SUM Function
21
- Counting Values and Blanks
22
- AVERAGE Function
23
- MIN and MAX Functions
24
- Handling Errors in Calculations
25
- Absolute vs Relative Referencing
26
- Autosum and AutoFill
27
- Flash Fill
28
- Word 2021 Course Introduction
29
- Exercise 01
30
- The Start Screeen
31
- Exploring the Word Interface
32
- Rulers and Zoom
33
- Check Spelling and Grammar
34
- Quick Access Toolbar
35
- Keyboard Shortcuts
36
- Screentips, Contextual Menus, and Ribbons
37
- Get Help
38
- Exercise 02
39
- Create and Save a Document
40
- Open Existing Documents
41
- Create a Document from a Template
42
- Navigate Around a Document
43
- Find Tools in Word
44
- Exercise 03
45
- Switch Document Views
46
- Immersive Reader and Focus
47
- Dark Mode
48
- Exercise 04
49
- Enter Text and Apply Basic Formatting
50
- Making Selections
51
- Advanced Text Formatting
52
- Move Text with Cut, Copy, and Paste
53
- Format Painter
54
- Paste Options
55
- Find and Replace
56
- Intro to PowerPoint 2021
57
- Creating Visually Stunning Presentations
58
- Presentation Tips and Best Practice
59
- Free Resources and Inspiration
60
- Exercise 01
61
- PowerPoint Interface
62
- Quick Access Toolbar
63
- Opening, Closing, and Saving Presentations
64
- Using Templates
65
- PowerPoint Options
66
- Exercise 02
67
- Slide Layouts
68
- Adding and Duplicating Slides
69
- Reusing Slides from Other Presentations
70
- Creating Sldes from an Outline
71
- Slide Themes and Backgrounds
72
- Exercise 01
73
- Resizing Background Image: Crop and Fill
74
- Transparent and Shape Overlays
75
- Drawing and Formatting Shapes
76
- Locking Shapes and Setting a Default Shape
77
- Merging Shapes
78
- Inserting a Logo: Filling Shapes with Images
79
- Adding Title and Subtitle
80
- Eyedropper Tool
81
- Exercise 04
82
- Selecting Objects
83
- Renaming and Changing the Z-Order
Description:
Embark on a comprehensive 9-hour journey through Microsoft Office 2021/365, mastering Excel, Word, and PowerPoint essentials. Learn fundamental formulas and functions in Excel, discover time-saving tips and tricks in Word, and explore best practices for creating impactful presentations in PowerPoint. Download course files to practice alongside the instructor, covering topics such as interface navigation, data entry, formatting, templates, and advanced features specific to each application. Gain practical skills through hands-on exercises and benefit from expert guidance on creating visually stunning presentations, utilizing keyboard shortcuts, and leveraging powerful tools like AutoSum, Flash Fill, and the Eyedropper. Perfect for beginners seeking a solid foundation in Microsoft Office, this course equips you with the knowledge to efficiently use these essential productivity tools in your personal or professional life.

Microsoft Office for Beginners - Excel, Word, and PowerPoint Training

Simon Sez IT
Add to list
0:00 / 0:00