Excel Basic to Advance Training Course Project Based 2020
4.2 (60 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.
692 students enrolled

Excel Basic to Advance Training Course Project Based 2020

Excel Basic to Advance Training Course Project Training is for Freelancers and has Excel Macros,Pivot table,Dashboard,IF
4.2 (60 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.
692 students enrolled
Last updated 2/2020
English
English [Auto]
Current price: $72.99 Original price: $104.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 6.5 hours on-demand video
  • 4 articles
  • 21 downloadable resources
  • 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
  • work comfortably with Microsoft excel and many of its advance features
  • Become one of the top Excel users in your team
  • Be much quicker at carrying out regular tasks
  • Know how to create a model with multiple scenarios
Requirements
  • existing user of excel is an ideal student for this course
Description

Excel Basic to Advance Training Course Project Training includes Excel VBA , Excel Macros , Pivot table , Dashboard, IF

If you have already been using Microsoft Excel then you know that the calculation, graphing and tables available help you track, manipulate and report important data. There is more to excel than a few SUMs, though, and this is the training course to get you into the advanced uses of Excel so you can really use the data and numbers you are tracking to your advantage.  

No matter if you are beginner or existing user of excel , this course is suitable both. It will improve your skills and open the hidden secrets and wonders of excel possibilities with this versatile spreadsheet program. In this course we will discuss and bring your excel knowledge & skills to the next level.  

The course is tremendously comprehensive and the best part is you will learn advance functionalities in small chunks of real practical industry scenario based assignments that is easier for you to digest and follow along  

The Ultimate Excel course over 60+ precise videos. Not by discussing only the functionalities but discussing the functionalities and possibilities in excel while doing a real client project.  

 In this course I have provided you with free downloadable Excel workbooks for each tutorial  

I have been helping thousands of people further their careers by teaching them Excel the easiest and most comfortable way. These tutorials will give you career-building skills that you can use to become better and more efficient at your job.  

The Ability to Master Excel  

By the end of this course you will be able to grasp most of the excel advance features that excel amazing tools has to offer. Which enables you to get more power and incredibly reducing you time & effort by increasing your efficiency in data analysis & reporting tasks  

What is the target audience?  

  • New users, beginners, intermediates and advanced Excel users

What am I going to get from this course?  

  • Over 60 lectures and 6 hours of content!

  • Well-designed and easy-to-understand materials

  • Detailed explanations with comprehensible Case Studies based on real situations

  • Downloadable course materials & Workbooks to follow along

  • Lifetime Access to all the lectures on the course.

  • Regular Video updates!

  • Fast and responsive support for any feedback or questions !

  • If you're not Satisfied, there's a 30 day money back guarantee !


By the completion of this course you will:  

  • Work comfortably with Microsoft Excel and many of its advanced features

  • Become one of the top Excel users in your team

  • Be much quicker at carrying out regular tasks

  • Know how to create a model with multiple scenarios


Note:  

Learning Excel if you are completely new to excel , becoming an excel guru is very easy. But it takes effort & continuous practice. For that we have provided compressive project based assignments videos with downloadable workbooks to follow along. Watch the lectures , try dong that by yourself, pause where ever it is required. But don't try to take it in all at once.  

If you feel like you can do 1 section a week, do 1 section a week.  

If you have time, do 1 section a day.  

But don't stress out.  

Best of Luck with Your amazing journey of unfolding unlimited possibilities of excel !

Who this course is for:
  • New users, beginners, intermediates and advanced Excel users
Course content
Expand all 64 lectures 06:43:36
+ Fill Series & Excel Key Shortcuts
6 lectures 24:28

Fill series plays a vital role in reducing your time and effort to write the values when in series by yourself, you can even drag the formula with a double click

Preview 07:35
FAQ's
00:56
Important Info
00:55
Excel Short keys & Golden Key
04:22
Introduction to Absolute & Relative References (Fixed & Variable)
07:20
+ The Marksheet
12 lectures 01:06:51
The Marksheet
04:08
Random Number Generation
02:21
Clearing Formula With Intact Values
03:37
Key Components of Marksheet
04:28
Introduction to IF-Then Conditions
03:27
Nested IF's (Looping Function)
06:17
Ranking Positions
05:46
Freeze Panes
03:18
Table Formatting & Range Conversion
04:52
Sort & Filters
08:31
Max Min Average Countblank Count if and Much More
12:39
+ Sales & Bonus Report
9 lectures 58:36
Prepare a Sales and Bonus Report With Manual Totalling
08:28
Grouping and Auto totalling
07:29
Quick Reminder
01:30
Hiding and Unhiding Rows Grouping and Auto Totalling
05:41
Removing Duplicates and Sales Summary With Sum if Function
05:12
Understanding Absolute and Relative Refrencing
09:09
Applying Sumif With Absolute and Relative Refrencing
05:19
Sumif with External Sheet Refrences
03:48
IF Conditions With Multiple Logics
12:00
+ The Aged Debtors Analysis
9 lectures 01:14:36
Introduction to Aged Debtors Analysis
05:27
Arranging the data to get Started
07:52
FAQ's Leaving a Review
02:40
Automate data arrangement
08:17
Quick Trick Formatting
03:15
Conditional formatting Advance
08:31
Applying Advance Formatting Tricks
06:59
Formula Analysis for Aging
19:40
Absolute , Relative Functions & Date values
11:55
+ Live Aging Analysis
2 lectures 08:38
Live Aging
08:06
Quick Reminder
00:32
+ Advance Search Tricks
10 lectures 01:00:47
Introduction to Vlookup
08:58
Using Named Ranges and IF ERROR
03:01
Simplifying Even More With data Validation
02:34
Quick Reminder
01:30
Using Combo Boxes
06:14
The Hlookup Function
05:56
Lookup for Inverse Data
10:15
Introduction To Index Match
07:38
Quiz Assignment Remington Pharma Explanation
02:21
+ Advance Analysis Tricks
3 lectures 33:22
Sum If and IFS
08:47
Forget filters - use DSUM Search Box
04:30
Amazing Advance Filters & Macros
20:05
+ Pivot Table & Dashboard Reporting
6 lectures 44:07
Introduction to Pivot tables
08:24
Grouping In Pivot Tables
08:17
Calculated Fields
05:59
FAQ's Leaving a Review
02:40
Pivot Charts
09:11
Dashboard Reporting
09:36
+ Some Other Amazing Tricks & Time Savers
6 lectures 32:06
Automated Cheque Printing System (Using Mail Merge)
13:29
Introduction to Hyperlinks
04:45
Hyperlinks With External Sheet Refrences
02:09
Columns Seperation & Concatenation
06:10
Excel Flash Fill Saves The day
04:03
Quick Reminder
01:30