Essential Microsoft Excel from Beginner to Advance level
Beginner LevelOffice ProductivityExcel

Essential Microsoft Excel from Beginner to Advance level

Microsoft Excel Beginner to Professional. Includes Pivot Tables, Power Query, NEW Formulas,Excel Charts,Projects & More

Created by Tech Bunny, Zechariah Tech
6 hours
Video Content
44
Lectures
44,880
Students
4.3
Rating
4.3
(44,880 students enrolled)

What you'll learn

Excel formulas and features
Pivot Tables, Pivot Charts, Slicers and Time Lines for Interactive Excel Reports
Data Selection
Data Navigation
Excel Charts
X-lookup

Course Content

7 sections • 44 lectures • 05:57:36 total length

Introduction

5 lectures • 25:34

Introduction01:05
Getting Started With Excel07:47
Create and open Workbook03:04
Create New Worksheets02:01
Tabs and Ribbon11:37

Data Handeling

3 lectures • 36:50

Data Formats07:05
Data Handling Basics - Cut, Copy and Paste20:44
Saving and Printing in Excel09:01

Formulas and Functions

8 lectures • 01:28:51

Basic Formula Operations24:28
Mathematical Functions - 106:57
Mathematical Functions - 204:30
Textual Functions - Part06:24
Textual Functions06:57
+3 more lectures

Lookups

2 lectures • 24:43

Handling #NA and Approximates match in Xlookup09:00
XLookup as a replacement of Vlookup15:43

Pivot Table

1 lectures • 15:13

Pivot table15:13

Excel Charts

19 lectures • 02:17:28

Excel Charts - Categories of messages that can be conveyed04:31
Elements of charts07:44
Bar and column charts07:56
Formatting charts21:47
Search modes in XLookup05:39
+14 more lectures

Project

6 lectures • 28:56

Intro02:20
Monthly salary slip part 101:08
monthly salary slip part 209:44
monthly salary slip part 313:12
MS Excel Frequently used shortcuts00:00
+1 more lectures

Description

Looking to learn Microsoft Excel and improve your data analysis skills but don't know where to start?

OR, you've been using Microsoft Excel for a while but don't feel 100% confident?

There is so much information out there. What do you need to succeed at work?

I’ve picked out the Excel Essential skills a Data Analyst needs and packaged them in a structured course.

In fact, We collected the most common Excel problems faced by my clients. We added in our 15+ years' experience in finance and project management. We included all the hidden tips and tricks We came to learn as an Excel MVP and put it ALL in THIS course. We also made sure it covers the absolute Excel beginners.

These practical, real-world examples help you understand the full potential of each feature. You'll learn how to use Excel for quick and painless data analysis.

There are many helpful and time-saving Excel formulas and features. We tend to forget what these are if we don't use them. This Microsoft Excel Essentials Course will give you the practice you need to be able to apply the best solution for the task at hand. This way you can do more in less time.

This Microsoft Excel Course include all the basic to intermediate Excel Curriculum like:

1.Introducing Excel.     

2.Excel Formulas and Functions which we used in daily use.

3.Pivot Tables.

4.Excel Charts.

5.Power Query

6.Projects and Many More


We will update projects in our Excel course as students demand.


Thankyou.







Who this course is for:

  • Who wants to learn excel
  • Any student
  • Who want to increase his / her excel skills
  • Anyone who have little bit of excel knowledge

This course includes:

  • 6 hours on-demand video
  • 1 articles
  • 1 downloadable resources
  • Access on mobile and TV
  • Full lifetime access
  • Certificate of completion

Instructors

Tech Bunny

Zechariah Tech

Students also download

Explore related courses to expand your learning journey.