Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ Microsoft AZ-900
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Personal Transformation Mindfulness Life Purpose Meditation CBT Emotional Intelligence
Web Development JavaScript React CSS Angular PHP Node.Js WordPress Vue JS
Google Flutter Android Development iOS Development React Native Swift Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
Microsoft Power BI SQL Tableau Business Analysis Data Modeling Business Intelligence MySQL Data Analysis Blockchain
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Business Plan Startup Freelancing Online Business Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Office Productivity Microsoft Excel

Excel Basic to Advance Training Course 2021

Excel Basics to Advance Training Course 2021 covers Vlookup , Pivot table , if conditions , dashboard reporting & more
Rating: 4.8 out of 54.8 (208 ratings)
614 students
Created by Accountech Training & Solutions
Last updated 2/2020
Hindi
30-Day Money-Back Guarantee

What you'll learn

  • Students will have a detailed understanding of advance excel each and every aspect

Requirements

  • To practice on this course , students must have an efficient system with good specifications as this software is large

Description

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

What People Say About Accountech Training & Solutions Courses:


Sageline 50 course review

“Yes, course is exactly what was looking for. I would like to see journal entries for car depreciation, purchase of cars etc... Plus after doing first year accounts, how to do roll over for next year. Learned quite a few short cuts. Thanks.” - Meera Patel

“Easy to follow, feels like a Pro already” - Kath Munyua

“This is a very Amazing course in Excel. In this course you learn how to use excel basic to advance program, formulas, etc. this is very helpful for beginners.” Ahsanpervaiz


Advance Excel Course Reviews

“Thanks ,You for everything.I have thoroughly enjoyed this course. The course is great and the concepts are easy to understand” - Qudsia Ali Manzar

“its just an amazing course for all the people who want to be an Excel expert in their offices. I have learnt so many new things and i will help my staff with my knowledge and I will definitely recommend this to many others. Thank you for bringing a lot of changes in my life. love this. Lock-down helped me a lot to learn this faster. Now i want the lock down to be lifted at the earliest to go to my office with this new learning experience.” Asif M Pathan


Tally ERP Course Reviews

“It's a fantastic course for grasping the knowledge of Tally software from scratch. It helped me a lot in building my foundation knowledge as well as other blocks level. Everything is perfect. Thank you !!!!! “- Devraj Raghuwanshi

“YES IT IS GOOD AND BEST TO UNDERSTAND AS THE EXPLANATION IS BEST...THANKS I ENJOYED” - Nitin P. Shah


Xero Cloud Accounting Course Reviews

“Great teaching, learned a lot, thanks. “ - Ewa Schreiber

“ i understand the course so far. very well explained “- Monica


Microsoft Word Course Reviews

“Very useful, especially for creating professional documents. Loved how each and every step was explained.” - Manisha Sharma

“Great Content love the way he is explaining it.” - Amit


Excel Business and Financial Modeling Course Review

“ Best course to go for........if you really want a zero to advance level course. everything was explained soo nicely that i got all the things in one go. Thank You. “- Ratnesh

“This course is highly recommended for anyone who wants to learn excel from the very basics to the most advanced level. The instructor has a very strong grip and deep experience about MS excel. It was a wonderful experience and that God that I have life time access to this course. I will surely keep watching the videos again and again and practice more and more to make my learning more useful for me in my job. Thank you Sir Saad “- Ziyad Khan


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:

  • students of finance , sales and marketing and hr professionals as well administration team all are equally suitable for the course

Course content

7 sections • 149 lectures • 20h 10m total length

  • Preview06:36
  • Preview00:53
  • Advance Excel Portal Usage Guide
    13:51
  • Preview06:22
  • Important Info
    02:14
  • Preview08:47
  • Preview20:30
  • Marksheet Part 2
    12:00
  • Marksheet Part 3
    27:57
  • Marksheet Part 4
    14:54

  • Introduction to Modules and Keyboard Shortcuts
    09:07
  • A Unique Searching Technique
    07:04
  • Vlookup Made Even Easier Using Named Ranges
    09:02
  • Preview05:58
  • Data Validation with Error Alerts
    02:53
  • Vlookup in Discount Tables
    10:09
  • Vlookup Dynamic Application
    12:55
  • Vlookup and Error Modification
    07:09
  • HLookup Application
    09:19
  • Test Assignment
    02:04
  • Home Assignment Vlookup Solved
    05:20
  • Repositioning of Data for Advance Vlookup Technique
    10:22
  • Quick Reminder
    01:30
  • 1. VLookup with Payroll Taxation
    06:01
  • Additional Fixed charge Taxation with Vlookup
    04:16
  • Preview08:14
  • Index Match Function
    11:07
  • Vlookup for Large Data Reconciliation
    04:23
  • Vlookup for Large Data Reconciliation Part 2
    06:19
  • Introduction to Hyperlinks
    05:23
  • Hyperlinks for Data Mapping
    05:00

  • How to Edit Multiple Sheets at same time
    06:25
  • Creating Master Total from multiple sheets
    03:18
  • FAQ's Leaving a Review
    02:40
  • Introduction to Sum If Function
    06:44
  • Sumif Method 2
    01:34
  • Countif By Both Methods and Test Assignment
    03:47
  • Two D Sum by Sumifs Using Absolute Relative Ref Mix
    13:25
  • Mix of Absolute and Relative Reference Logic
    06:23
  • Sumifs using Named Ranges From Selection
    05:11
  • Sumifs With Full Column Criteria ref
    03:54
  • Sumif By Class
    03:49
  • Sumif and D formulas Req 1
    03:35
  • Quick Reminder
    01:30
  • Sumif and D formulas Req 2
    09:26
  • Sumif and D Formulas Req 3
    08:58
  • Concept of Auto Totalling Within Data
    09:31
  • Removing and Reapplying Subtotals with different Criteria
    02:01
  • Application of Multiple Subtotals
    04:58
  • Subtotal and Sumif Situations with data Validation
    07:21
  • Preview06:46
  • Advance Filter Part 2
    07:09
  • Advance Filter Part 3
    04:20
  • Additional Point in Advance Filter Part 4
    01:43

  • Introduction to Module 3 and group function
    03:54
  • Date Functions In Excel
    11:48
  • Time Functions In Excel
    04:37
  • Text Functions and Comments in Excel
    07:50
  • More Text Related Functions in Excel
    07:49
  • Calculate Years of Experience
    10:18
  • Remove Unnecessary Blanks for Data Cleaning
    04:33
  • Conditional Formatting Traditional Method Revision
    01:50
  • Conditional Formatting Self Defined Formula
    07:46
  • Quick Reminder
    01:30
  • Bank Book Reconciliation
    06:59
  • Bank Reconciliation with conditional formatting
    06:29
  • 42. Dealing with If Scenarios Excel
    06:15
  • Preview05:44
  • Dealing with IF OR Scenarios
    04:06
  • How to Seperate Data of A cell into Multiple Columns
    08:57
  • Removing Blank Fields (Entire Row)
    05:20
  • Practical Assesment Part 1
    09:57
  • Practical Assesment Part 2
    03:13
  • Practical Assesment Part 3
    06:05
  • Flash Fill Practical Assesment
    05:02
  • Practical Assesment P4- Conditions
    04:05
  • FAQ's Leaving a Review
    02:40
  • Practical Assesment P4- Conditions Solved
    06:54
  • Aged Debtors Analysis Start
    10:10
  • Aged Debtors Analysis Conditions Application
    10:49
  • Aged Debtors Analysis Reconcilliation
    09:45
  • Aged Debtors Analysis Advance Totalling Technique
    11:01
  • Preview05:21
  • Aged Debtors Analysis Applying Advance Conditional Formatting
    07:55
  • Quick Reminder
    01:30
  • Aged Debtors Analysis Conditional Formatting Part 2
    03:04
  • Print Settings in Excel Part 1
    07:53
  • Print Settings in Excel Part 2
    06:00
  • Print Settings in Excel Part 3
    04:18
  • Print Settings in Excel Part 4
    08:23
  • Preview07:01
  • Cheques Printing System Part 2
    07:08
  • Cheques Printing System Part 3
    07:21
  • Cheques Printing System Part 4
    05:34

  • Introduction to Module 4
    06:20
  • Data Summary Report With Subtotal
    06:32
  • Data Summary outside data with 1 criteria
    03:42
  • Data summary Outside Data with muliple criterias
    07:12
  • Data Analysis Using Pivot Table
    08:24
  • Data Analysis With Pivot Part 2
    07:07
  • Data Analysis With Pivot Part 3
    04:10
  • Data Analysis With Pivot Part 4
    09:09
  • Data Analysis With Pivot Part 5
    04:16
  • Dashboard Reporting Part 1
    12:57
  • Quick Reminder
    01:30
  • Dashboard Final
    20:33
  • Days Calculation According to Working Days
    04:38

  • Day 1 Part 1
    20:26
  • Day 1 Part 2
    20:01
  • Day 2 Part 1
    24:51
  • Day 2 Part 2
    04:06
  • Day 3 Part 1
    18:54
  • Day 3 Part 2
    05:51
  • Day 4 Part 1
    11:55
  • Day 4 Part 2
    10:20
  • Day 5 Part 1
    14:09
  • Day 5 Part 2
    11:01
  • FAQ's Leaving a Review
    02:40
  • Day 5 Part 3
    01:53
  • Day 6 Part 1
    11:30
  • Day 6 Part 2
    04:01
  • Day 7 Part 1
    20:48
  • Day 7 Part 2
    11:36
  • Quick Reminder
    01:30
  • Day 8 Part 1
    11:52
  • Day 8 Part 2
    17:36
  • Day 9 Part 1
    15:31
  • Day 9 part 2
    08:12
  • Day 9 Part 3
    14:52
  • Day 10 Part 1
    23:24
  • Day 10 Part 2
    02:38
  • Day 11 Part 1
    08:15
  • Day 11 Part 2
    04:43
  • Day 11 Part 3
    10:52
  • Day 12 Part 1
    13:12
  • Day 12 Part 2
    12:35
  • Day 13 Part 1
    23:09
  • Day 13 Part 2
    18:36
  • Day 14 Part 1
    11:23
  • Day 14 Part 2
    18:08
  • Day 15 Part 1
    15:48
  • Day 15 Part 2
    16:45
  • Quick Reminder
    01:30

  • Pivot Table Practical Assessment Requirement 1
    08:59
  • Pivot Table Practical Assessment Requirement 2
    04:07
  • Pivot Table Practical Assessment Requirement 3
    04:34
  • Pivot Table Practical Assessment Requirement 3 Part 2
    05:29
  • Convert Date to Proper Format
    07:38
  • Bonus Section
    00:04

Instructor

Accountech Training & Solutions
Helpful Instructor
Accountech Training & Solutions
  • 4.3 Instructor Rating
  • 1,142 Reviews
  • 11,409 Students
  • 24 Courses

Accountech Training & Solutions is professional courses institute and have trained more than +85000 students on different platforms . Accountech is also a resourceful udemy instructor portal with more than a decade of experience in Multiple industry dimensions

Since 2010, Many individuals, industries, and Big Companies with thousands of employees have benefited from the easy and hands-on software training offered by Accountech Training & Solutions.

Whether you want to aquire a new set of skills or implement a software or technological advancement in your business or company you work for , Accountech is the most trusted and preferred ELeaning choice for individuals and companies

You can also google our Exceptional social presence by searching Accountech Training & Solutions


  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.