Excel Essentials: The Complete Excel Series - Level 1, 2 & 3

Offered byUDEMY

Excel Essentials: The Complete Excel Series - Level 1, 2 & 3
at
UDEMY
Overview

Excel: The WHOLE Excel Mastery Series In One! From Excel Novice To VBA Programmer - Excel 2013, 2016, 2019 & Excel 365

Duration	28 hours
Total fee	₹549
Mode of learning	Online
Difficulty level	Beginner
Credential	Certificate

Excel Essentials: The Complete Excel Series - Level 1, 2 & 3
at
UDEMY
Highlights

Certificate of completion
28 hours on-demand video
133 downloadable resources
Access on mobile and TV
30-Day Money-Back Guarantee
Full Lifetime Access

Excel Essentials: The Complete Excel Series - Level 1, 2 & 3
at
UDEMY
Course details

Skills you will learn

Excel

Who should do this course?

For those who want to get a thorough knowledge of Excel

What are the course deliverables?

With this course learner will:
Build own spreadsheets from scratch, and actually understand how they work
Create a fully functioning relational database using Excel
Understand coding, and the thought process behind it
Create Word documents using VBA code right from Excel

More about this course

This isn't just a course with a bunch of formulas, it's hands on guide through real life projects
Learner will learn how to build complex solutions using the different methods

Excel Essentials: The Complete Excel Series - Level 1, 2 & 3
at
UDEMY
Curriculum

Excel Essentials: Level 1 Basics - Master Excel Step-By-Step

Introduction To Level 1

Before We Start...Viewing The Lectures, And Following Along On A Single Screen

An Introduction To Level 1

Where Are My Practice Files?

Start Here - All The Basics

Opening Excel, and Creating a Shortcut

The Anatomy Of A Workbook: Where Everything Is, And What It Does!

A Quick Review Of What's Where

Accessing The "F" Keys (Function Keys) On A Laptop

Always Do This First! - Save Your New Workbook!

Let's Enter Some Data

Quiz 1

Editing Data

Ooops. I Made A Mistake - Undo and Redo

Changing Appearance Of Text With Formatting - Fonts

A Quick Word On Formatting

Formatting Text - Alignment

Saving Time With AutoFilling Sequences

POWER USER - Adding Your Own Lists To Autofill

Saving Time With Format Painter

Changing The Column Width

Quiz Number 2

Tidy Large Titles With Merge And Centre

Entering Data - A Couple Of Shortcuts

Doing The (Simple) Math

Sums - The Old Fashioned Way!

Sums - Using Autosum

Quiz Number 3

Copying Formulas

SUMming Horizontally

Basic Formulas - Subtraction

Basic Formulas - Multiplication

Basic Formulas - Division

Average Function

The Order Of Mathematical Operation

POWER USER - Evaluate Formula

Rearranging Things

Inserting New Columns And Rows

Moving Existing Columns And Rows

Cutting, Copying, Inserting And Deleting

Hiding Columns And Rows

Quiz Number 4

Formulas: Learning The Clever Stuff!

ROUNDing Functions

Formatting Numbers

A Primer In Building Complex Formulas

Buliding a Compex Formula

Excel Essentials: The Complete Excel Series - Level 1, 2 & 3
at
UDEMY
Faculty details

Alan Jarvis

Hi, my name is Alan, and I have over thirty years of experience in teaching various subjects and have held senior management positions at several blue chip and Times Top 100 companies. I now specialise in consultancy, interim work and teaching here on Udemy.