Udemy, Coursera, 2U/edX Face Lawsuits Over Meta Pixel Use

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Excel 2019 Expert Tutorial

Learnit Training via YouTube

Start learning Write review

Overview

This course aims to help beginners to experienced Excel users sharpen their skills and increase efficiency in Microsoft Excel. By covering basic navigation, data calculation, sorting, filtering, Pivot Tables, IF functions, Database functions, Macros, and automation, learners will gain the skills needed to work effectively with data in Excel. The teaching method includes video tutorials and practical exercises. The course is intended for individuals looking to enhance their Excel proficiency and automate common tasks.

Syllabus

Start
Introduction
Creating & Applying Named Ranges
Navigating with Named Ranges
IF Functions Part 1
IF Functions Part 2
Introduction to Nesting Functions
The Round Function
Formula Auditing Tools
Introduction to VLOOKUP
VLOOKUP
IFERROR
Database Functions – SUMIF & AVERAGEIF
Database Functions – SUMIFS
Text Functions
Consolidate by Position
Consolidate by Category
Goal Seek
Introduction to Data Tables
Data Tables
Scenario Manager
Macros – Adding the Developer Tab
Macros – Recording & Running the Header Macro
Macros – Visual Basic Editor & Form Control
Macros – Adding Macros to the Ribbon
Macros – Exercise

Taught by

Learnit Training

Reviews

Start your review of Excel 2019 Expert Tutorial

Start learning

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.