Dive into advanced Excel 2019 techniques in this comprehensive tutorial designed for users of all levels seeking to enhance their spreadsheet skills and boost productivity. Learn to efficiently manage data through list design, table formatting, and filtering. Master advanced features like Flash Fill, multi-level sorting, and automatic subtotals. Explore data visualization with charts, custom templates, and sparklines. Gain expertise in pivot tables and charts, including filtering, report layouts, and data refreshing. Discover essential tools such as data validation, conditional formatting, and cell protection. Perfect your Excel proficiency with practical lessons on linking data and utilizing comments, equipping you to tackle complex spreadsheet tasks with confidence.
Overview
Syllabus
Start
Introduction
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
