Главная
Study mode:
on
1
- Introduction
2
- Course Intro
3
- Excel 2021 vs Excel 365
4
- Launching Excel
5
- The Start Screen
6
- Exploring the Interface
7
- Ribbons, Tabs and Menus
8
- 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
- Navigating and Selecting Cells, Rows, and Columns
18
- Exercise 02
19
- Formulas and Functions Explained
20
- SUM Function
21
- COUNT Function
22
- AVERAGE Function
23
- MIN and MAX Function
24
- Handling Errors in Calculations
25
- Absolute vs Relative Referencing
26
- Autosum and Autofill Options
27
- Flash Fill
28
- Exercise 03
29
- What are Named Ranges
30
- Managing Named Ranges
31
- Using Named Ranges
32
- Exercise 04
33
- Applying Number Formats
34
- Applying Date and Time Formats
35
- Formatting Cells, Rows and Columns
36
- Format Painter
37
- Exercise 05
38
- Working with Rows and Columns
39
- Deleting and Clearing Cells
40
- Aligning Text and Numbers
41
- Applying Themes and Styles
Description:
Build a solid foundation in Excel 2021/365 with this comprehensive 4.5-hour tutorial. Learn the differences between Excel versions, explore the interface, and master essential features including formulas, functions, formatting, and themes. Practice with downloadable exercise files to reinforce your learning. Cover topics such as navigating the Excel environment, working with templates, entering and editing data, using basic functions, managing named ranges, applying number formats, and customizing worksheets. Gain practical skills applicable to both work and academic settings, progressing from beginner concepts to more advanced Excel techniques.

Microsoft Excel Tutorial - Getting Started in Microsoft Excel 2021

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