Главная
Study mode:
on
1
- Intro Simon Sez IT
2
- Course Introduction
3
- Excel 365 Online Portal
4
- Exercise 01
5
- Launch Excel
6
- Explore the Interface
7
- Contextual Menus and Ribbons
8
- The Quick Access Toolbar
9
- Keyboard Shortcuts
10
- Exercise 02
11
- Excel Templates
12
- Work with Workbooks and Worksheets
13
- Save Workbooks to OneDrive
14
- Enter Text, Numbers, and Dates
15
- Custom Lists
16
- Exercise 03
17
- Order of Operations
18
- A Simple Formula
19
- The 'Big 6' Functions
20
- Absolute vs Relative Referencing
21
- Quick Calculations with Autosum
22
- Autofill and Flash Fill
23
- Exercise 04
24
- What are Names Ranges?
25
- Create Named Ranges
26
- Use Named Ranges in Formulas
27
- Exercise 05
28
- Apply Number Formats
29
- Format Cells, Rows and Columns
30
- AutoFormat
31
- Find and Replace Formatting
32
- Format Painter
33
- Clear Cells
34
- Exercise 06
35
- Tables Explained
36
- Format as Table
37
- Table Reference in Formulas
38
- Exercise 07
39
- Work with Columns and Rows
40
- Align Text and Numbers
41
- Merge Cells vs Center Across Selection
42
- Apply Themes and Styles
43
- Exercise 08
Description:
Embark on a comprehensive 4-hour tutorial designed to elevate your Excel 365 skills from beginner to proficient. Navigate the Excel 365 Online Portal, master the interface, and learn essential features like the Quick Access Toolbar and keyboard shortcuts. Explore workbook and worksheet management, data entry techniques, and custom lists. Dive into formula creation, understanding the 'Big 6' functions, and grasping absolute vs. relative referencing. Discover time-saving tools such as Autosum, Autofill, and Flash Fill. Learn to create and utilize named ranges, apply various formatting techniques, and work efficiently with tables. Master column and row manipulation, text alignment, and apply professional themes and styles. With hands-on exercises throughout, gain practical experience to boost your spreadsheet proficiency and streamline your workflow in Excel 365.

Excel 365 for Beginners: Learn the Basics to Boost Your Spreadsheet Skills

Simon Sez IT
Add to list