Excel 2019 Intermediate Tutorial
Offered By: Learnit Training via YouTube
Course Description
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
Related Courses
Introduction to Computational Finance and Financial EconometricsUniversity of Washington via Coursera Excel 2010
Miríadax The Finance of Retirement & Pensions
Stanford Graduate School of Business via NovoEd Einführung in die Wahrscheinlichkeitstheorie
Johannes Gutenberg University Mainz via iversity Introduction to VBA/Excel Programming
Cal Poly Pomona via Open Education by Blackboard