This course aims to teach learners how to efficiently navigate and utilize Microsoft Excel 2019. By the end of the course, students will be able to calculate data using basic formulas and functions, sort and filter data effectively, create Pivot Tables, work with advanced functions like IF and Database functions, automate tasks using Macros, and save time by automating common Excel tasks. The course is designed for beginners to experienced users who want to enhance their Excel skills and productivity. The teaching method includes hands-on exercises and demonstrations to reinforce learning.
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
