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