Microsoft Excel at Work - From Beginner to Expert in 9 Hours
4.4 (95 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,247 students enrolled

Microsoft Excel at Work - From Beginner to Expert in 9 Hours

Master Excel in no time, also learn to automate through MACRO and other most valuable tools
4.4 (95 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,247 students enrolled
Created by Himanshu Dhar
Last updated 5/2020
English
Current price: $35.99 Original price: $59.99 Discount: 40% off
3 days left at this price!
30-Day Money-Back Guarantee
This course includes
  • 9.5 hours on-demand video
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Manage Data in Excel
  • How to apply Logical and Lookup Functions
  • How to apply Pivot Table and other organising tool
  • Learn to use Chart in Excel
  • Learn to use Mathematical Function
  • Secure and Protect your Excel File
  • Learn to automate Excel task through VBA - Macro
  • Understanding Macro Recording
  • Learn to work on Variables and Object
  • Understanding IF and Loop in Excel VBA
  • Work on Access - Table, Form Queries and Reports
  • Data import and export in Access
  • Learn SQL Queries
  • Learn Styles, Quick Parts and Mail merge in documentation
Requirements
  • Basic of Computers
Description

Excel is very vast. There are plenty of topics may take lots of time and efforts to be mastered in. However on the basis of my experience I have made this crash course so that you may learn Excel quickly. This course is the combination of all the important topics that will be required in the real time Excel related work. Moreover it prepares you for the interview. In many profile knowing Excel is compulsory skill sets. So this short Excel course will get you ready for it.

Who this course is for:
  • Anyone want to learn Excel
Course content
Expand all 94 lectures 09:34:59
+ MS Excel
47 lectures 04:44:34

Download the practice File, follow the module plan

Preview 08:12
Autofill Date
02:26
Autofill Advance Tools
04:40
Equation - Functions Based
12:35
Advance Math Function
07:13
Advance Math Function 2
06:36
Using of Wild Card in Math Function
02:42
If Function - With Equation And Task
03:04
If Function - Nested If
03:51
If Function - Advance
04:43
If Function - Task Solution
04:53
And , Or Function
06:40
And, Or, If Nested
05:07
And, Or Advance
02:17
Print option in Excel - Part 1
11:48
Print option in Excel - Part 2
08:20
Vlookup Function
08:10
Hlookup Function
02:43
Match Function
03:42
Match and Index Function Nested
08:18
VLOOKUP with True
04:40
Protect Workbook
04:01
Protect Sheet
07:27
Pivot Table - Intro
05:18
Pivot Table - Manage Field Area
07:16
Pivot Table - Value Field, Report And More
05:18
Pivot Table - Slicer And Duplicate Pivot
06:51
Pivot Table - Group To Mange Date And Values
05:07
Chart Preparation
14:30
Chart Preparation - Advance
05:21
Chart Preparation - Customize
03:54
Text to Column
08:58
Conditional Formatting
05:22
Conditional Formatting - Types of Rules
11:30
Conditional Formatting - Mange Rules
04:10
Conditional Formatting - New Rules 1
03:09
Conditional Formatting - New Rules 2
04:35
Data Validation
10:46
Data Validation - Input message and Error Alert
04:56
Workbook protect
04:01
Protect sheet
07:27
Hide Formulas and unlocked Cell
04:12
Protect File with password
02:29
+ Excel VBA - MACRO
37 lectures 03:46:00
Macro Recording
15:17
Types of ways to run macros
05:59
Introduction to Macro
08:57
Start Macro Programming
07:06
Macro Task Basic
04:06
Methods to Refer Range
06:55
Selection of multiple cell
05:56
Formatting through VBA
07:18
End Command in VBA
06:17
Offset in VBA
04:49
Task on Data Entry Automate
02:14
Solution for the task
05:11
Methods to refer to sheets
08:31
Methods related to sheets
10:05
Sheet related task
01:52
Sheet Related Task Solution
03:48
Methods to Refer to Workbooks
02:50
Methods related to workbook
03:20
Workbook related project
10:35
Declared Variable
10:02
Data Types in Variable
06:16
Object variable related task
02:16
Solution of task 2
03:43
Variable Project
07:42
Apply IF in VBA
05:22
AND OR in VBA
08:13
Task for IF
01:28
Solution of IF task
03:03
Understanding Loop
05:39
Loop Practical example
05:02
Loop Related Task Solution
04:14
How to create Events
09:25
Events Example and task
03:04
Event Task Solution
02:37
Sheet Specific Events
03:18
Create Userform
18:41
Late Binding Technique in Macro
04:49
+ Bonus - MS Access
5 lectures 34:35
Get to know Access Application
05:56
Create table in MS Access
14:19
How to Import and Export in Access
07:00
Create Form from table
04:23
Creating Report in Access
02:57
+ Bonus - SQL Queries
2 lectures 12:35
SQL Queries part 1
08:13
SQL Queries part 2
04:22
+ Bonus - Documentation
3 lectures 17:15
Styles in word - Heading Pattern
05:31
Quick Parts Technique
02:08
Mail Merge
09:36