Главная
Study mode:
on
1
Introduction
2
Structure of Excel
3
Quick Access Toolbar
4
Strikethrough Tool
5
File Tab
6
New Features
7
Share Tool
8
Tell Me Bar
9
Smart Lookup
10
Other Fundamentals
11
Navigation
12
Keyboard Shortcuts
13
Expanding the Menu
14
Replacing Values
15
AutoSum Tool
Description:
Dive into a comprehensive 2-hour tutorial on Microsoft Excel 2016 for beginners. Master the basics, from selecting cells and entering data to calculating with formulas and functions. Progress through intermediate skills like sorting, filtering, and creating Pivot Tables. Explore advanced features, including IF and VLOOKUP functions, and conclude with an introduction to Macros. Cover essential topics such as the Start Screen, Ribbon, QAT, Backstage View, and new features like Share Pane, Tell Me, and Smart Lookup. Learn practical skills in formatting, data manipulation, chart creation, and data analysis. Gain proficiency in worksheet management, custom views, data validation, and file security. Enhance your Excel experience with time-saving techniques and powerful tools for data visualization and reporting.

Microsoft Excel 2016 - Beginners Tutorial Video

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