Главная
Study mode:
on
1
Start
2
Introduction
3
What is Excel?
4
Excel Interface Overview
5
Search and Help
6
Navigating and Selecting Cells
7
Entering, Replacing, and Deleting Data
8
Adjusting Cells
9
Calculations, Formulas, and Functions
10
Basic Functions
11
AutoFill
12
Relative and Absolute Cell Reference
13
Saving and Sharing Workbooks
14
Comments
15
Inserting Rows and Columns
16
Cut, Copy, and Paste
17
Formatting Data with Cell Styles
18
Managing Worksheets
19
Hiding Row and Columns
20
Creating Custom Views
21
Reviewing Worksheets
22
Printing Worksheets
23
Conclusion
Description:
Master the fundamentals of Microsoft Excel in this comprehensive beginner tutorial. Dive into the essential features of this powerful spreadsheet application, starting with an overview of the interface and navigation techniques. Learn to efficiently enter, manipulate, and format data, while exploring basic formulas and functions for calculations. Progress through intermediate skills such as sorting, filtering, and creating charts to effectively analyze and present information. Discover time-saving tools like AutoFill, custom views, and worksheet management. Gain insights into advanced topics including XLOOKUP, database functions, and an introduction to macros for automating tasks. Whether you're new to Excel or looking to enhance your existing skills, this tutorial provides a solid foundation for organizing, analyzing, and presenting data effectively in various professional and personal contexts.

Excel Beginner Tutorial - From Basics to Advanced Features

Learnit Training
Add to list
0:00 / 0:00