Play all

Start

Introduction

What is Excel?

Excel Interface Overview

Search and Help

Navigating and Selecting Cells

Entering, Replacing, and Deleting Data

Adjusting Cells

Calculations, Formulas, and Functions

Basic Functions

AutoFill

Relative and Absolute Cell Reference

Saving and Sharing Workbooks

Comments

Inserting Rows and Columns

Cut, Copy, and Paste

Formatting Data with Cell Styles

Managing Worksheets

Hiding Row and Columns

Creating Custom Views

Reviewing Worksheets

Printing Worksheets

Conclusion

Introduction

Creating Tables

Flash Fill

Introduction to Sorting Data

SORT Function

SORTBY Function

UNIQUE Function

Filters

Slicers

Subtotals

Quick Analysis Tool

Inserting Charts

Formatting Charts

Creating Chart Templates

Printing Charts

Using Sparklines

Introduction to Pivot Tables

Pivot Charts

Using Slicers with Pivot Tables

Data Validation

Conditional Formatting

Custom Conditional Formatting

Linking Data

Conclusion

Introduction

Named Ranges

Multiple Named Ranges

XLOOKUP

Data Mining with XLOOKUP

IF Function

Database Functions

Goal Seek

PMT Data Tables

Macros

IF-THEN Statements

Do Until Loops

Creating Games with Excel VBA Code

Conclusion

Description:

Embark on a comprehensive 4.5-hour journey through Microsoft Excel, designed for both beginners and experienced users looking to enhance their skills. Learn to navigate the Excel interface, perform calculations with formulas and functions, and master data organization techniques. Explore advanced features like sorting, filtering, and creating dynamic charts and pivot tables. Dive into XLOOKUP, database functions, and macros to automate tasks. Gain practical knowledge on data validation, conditional formatting, and VBA coding for Excel. By the end of this tutorial, you'll be equipped with the tools to efficiently analyze data, create insightful visualizations, and streamline your spreadsheet workflows.

Excel Full Course Tutorial - From Basics to Advanced (4+ Hours)

Learnit Training

Add to list

#Business #Business Software #Microsoft Office 365 #Microsoft Excel #Data Science #Data Analysis #Data Visualization #Spreadsheets #Pivot Tables #Macros #VBA

0:00 / 0:00