Dive into this comprehensive intermediate Excel 2019 tutorial designed for beginners to experienced users looking to enhance their spreadsheet skills. Learn to efficiently navigate the user interface, calculate data using formulas and functions, and master advanced features like sorting, filtering, and Pivot Tables. Explore list design, table formatting, data validation, and conditional formatting. Discover how to create and customize charts, use Sparklines, and implement data protection. Practice linking data, working with comments, and automating tasks. By the end of this 1 hour and 31 minute tutorial, gain the confidence to manipulate data, create insightful visualizations, and streamline your Excel workflow for increased productivity.
Overview
Syllabus
Start
Overview of List Design
Formatting Lists as Tables
Filtering Records from Lists or Tables
Removing Duplicates from Lists or Tables
Flash Fill
Single & Multi-Level Sorting
Inserting Automatic Subtotals in Lists
Inserting Data Charts Using Recommended Charts
Formatting & Editing Chart Elements
Creating & Applying Custom Chart Templates
Adding & Removing Data from Charts
Inserting Sparklines
Printing Charts
Inserting Pivot Tables
Filtering Pivot Tables
Using Report Layouts in Pivot Tables
Refreshing & Changing Source Data in Pivot Tables
Inserting Pivot Charts
Data Validation
Applying Built-In Conditional Formatting
Creating Custom Conditional Formats
Linking Data
Comments
Protection
Taught by
Learnit Training
