Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Data Management and Analysis with Advance Excel
Rating: 4.5 out of 5(105 ratings)
354 students

Data Management and Analysis with Advance Excel

Learn and Master Excel functions and tools for data analytics. Course compatible with Excel 2007, 2010, 2013 & 2016
Created bySam Parulekar
Last updated 10/2021
English

What you'll learn

  • After taking the course the students would be able to do Autofill, Data Validation
  • Analytical Functions like - Goal Seek, Scenario Manager and Data table
  • Functions like PMT, Vlookup, Hlookup, Multiple vlookup, Identifying and deleting duplicates
  • Importing and exporting data, creating subtotal based reports
  • Pivot tables, Pivot Charts
  • Functions like count, countif, countifs, sum, sumif,sumifs,
  • Introduction to basic Macros and Mail Merge
  • Fun, interactive, and highly effective lessons from a best-selling Excel instructor.
  • Unique tips, tools and case studies that you won't find in ANY other course.
  • Lifetime access to reference materials and practice files

Course content

15 sections • 75 lectures • 6h 57m total length

  • Introduction2:13

    In this part of the course there would be a brief introduction of the trainer i.e. me and you would also get to know what you would be able to learn by the end of this course.

    I have also shared with you the list of files required for practicing the examples (in the resources section) which you should download on your computer as you would be requiring them to learn the concepts in this training.

  • Autofill Data and Creating Custom Lists9:38

    After completing this Lecture students would be able to Autofill data for repeated tasks and would also be able to create their own custom lists and also sort data with this created custom list. This lecture would also create an impetus among the student to think about how he can apply this studied module in his or her line of business.

Requirements

  • Microsoft Excel should be installed on your system, this course is compatible with Excel 2007, Excel 2010, Excel 2013, or Excel 2016
  • Some experience with basic formulas is recommended, but not required.

Description

This course will give you a deep understanding of the advanced formulas and functions that transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool. While most Excel courses focus on simply what each formula does, I would teach you on how to apply the formula and understand its business and analytical application as well.

By the end of the course you'll be writing robust, elegant formulas and functions which would help you to analyze data by allowing you to:

Understanding basics:

  • AutoFill a Series

  • Creating a Custom List

Data Tools

  • Data Validation

  • Drop-Down Lists

  • Text to Columns

  • pmt

  • Goal Seek

  • Scenario Manager

  • Data Table

  • Vlookup

  • hlookup

  • Importing and Exporting Data

  • Identifying and deleting duplicates

 Outline, Sort, Filter and Subtotal

  • Introduction

  • Group and Ungroup and subtotals

  • Subtotals

  • Consolidate

 Pivot Tables

  • Introduction

  • Creating Pivot Tables

  • Choosing Fields

  • Pivot Table Layout

  • Filtering Pivot Tables

  • Modifying Pivot Tables Data

  • Pivot Charts

Special Functions

  • Count / Counta / Countif / Countifs

  • Sum /sumif / sumifs

 Macros

 Mail merge


Who this course is for:

  • This course is suitable for any individual who wants to go beyond the basics of Excel and learn to master excel.
  • Anyone hoping to expand their analytics skill set, work more efficiently with data, and take their career to a new level
  • Students looking for an engaging, hands-on, and highly interactive approach to Excel analytics training

Report abuse