Главная
Study mode:
on
1
- Intro to Excel
2
- What's New in Excel
3
- Course Overview
4
- Overview of the Excel Window
5
- Mouse Features
6
- BackStage View in Excel
7
- Text and Numbers
8
- Creating Basic Formulas
9
- Relative References
10
- Order of Operations
11
- Working with Ranges
12
- Practice Exercise
13
- Working with Save and Save As Commands
14
- File Extensions, Share, Exports & Publish Files
15
- Practice Exercise
16
- Opening a File
17
- Working with Larger Files
18
- Freeze Panes
19
- Split Screen
20
- Practice Exercise
21
- Headers & Footers
22
- Print Titles
23
- Comments in Excel
24
- Page Setup Options
25
- Fit to Print on One Page
26
- Printing Workbooks
27
- Practice Exercise
28
- Adding and Deleting Cells
29
- Chaing Column and Row Widths
30
- Practice Exercise
31
- Cut, Copy and Paste
32
- Copying Formulas
33
- Practice Exercise
34
- Overview of Formulas
35
- Create Formulas Using Functions Part 1
36
- Create Formulas Using Functions Part 2
37
- Absolute Values
38
- Practice Exercise
39
- Adding, Deleting, and Remaining Sheets
40
- Additional Sheet Tab Options
41
- Dimensional Functions
42
- Practice Exercise
43
- PowerPoint Welcome and Overview
44
- Navigating a PowerPoint Presentation
45
- Overview of the Screen and the Views
46
- PowerPoint Exercise 01
47
- Presentation Tips and Guidelines
48
- Creating New Presentation
49
- Working with Slides
50
- Saving Presentation
51
- PowerPoint Exercise 02
52
- Formatting Text
53
- Working with Bullets and Numbered Lists
54
- PowerPoint Exercise 03
55
- Inserting Shapes
56
- Inserting Graphics
57
- Inserting Icons and 3D Models
58
- Inserting Pictures
59
- PowerPoint Exercise 04
60
- Selecting Objects
61
- Editing Objects
62
- Formatting Objects - Part 1
63
- Formatting Objects - Part 2
64
- Arranging Objects
65
- Grouping Objects
66
- PowerPoint Exercise 05
67
- Picture Options
68
- Cropping Pictures
69
- Formatting Pictures
70
- Things You Can Do with Pictures
71
- PowerPoint Exercise 06
72
- Creating SmartArt
73
- Modifying SmartArt
74
- Creating a Flow Chart
75
- Word Course Overview
76
- Word Screen
77
- Backstage View
78
- Creating a New Document
79
- Non-printing Characters and Line Spacing
80
- Saving a Document
81
- Opening a Document
82
- Navigating a Document
83
- GoTo, Find and Replace
84
- Editing a Document
85
- Section 2 Practice Exercise
86
- AutoCorrect Options
87
- Selecting Text
88
- Cut, Copy and Paste
89
- Character Formatting Options
90
- Format Painter
91
- Working with Numbers
92
- Working with Bullets
93
- Creating an Outline
94
- Section 3 Practice Exercise
95
- Alignment Options
96
- Line Spacing Options
97
- Working with Indents
98
- Working with Tabs
99
- Section 4 Practice Exercise
100
- Sorting a List
Description:
Embark on a comprehensive 9-hour journey through Microsoft Office, mastering Excel, PowerPoint, and Word. Gain a solid foundation in essential skills for work or school, from basic formulas and data manipulation in Excel to creating engaging presentations in PowerPoint and formatting professional documents in Word. Practice with downloadable exercises to reinforce your learning. Explore features like backstage view, file management, object formatting, SmartArt creation, and document navigation. Perfect for beginners, this tutorial covers everything from basic operations to advanced techniques, ensuring you become proficient in these crucial productivity tools.

Microsoft Office Tutorial - Learn Excel, PowerPoint and Word

Simon Sez IT
Add to list
#Business #Business Software #Microsoft Office 365 #Microsoft Excel #Microsoft Powerpoint #Microsoft Word #Document Formatting
0:00 / 0:00
1 of 100

- Intro to Excel