Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Microsoft Excel 2016 - Beginners Tutorial Video

Learnit Training via YouTube

Overview

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.

Syllabus

Introduction
Structure of Excel
Quick Access Toolbar
Strikethrough Tool
File Tab
New Features
Share Tool
Tell Me Bar
Smart Lookup
Other Fundamentals
Navigation
Keyboard Shortcuts
Expanding the Menu
Replacing Values
AutoSum Tool

Taught by

Learnit Training

Reviews

Start your review of Microsoft Excel 2016 - Beginners Tutorial Video

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.