Skip to content

This repo on Data Analytics In Excel will help to understand the various crucial functions available in Excel, such as vlookup, hlookup, sumif/s, counif/s, iferror and others. Finally, you will see how to use the Data Analysis Toolpak to perform various data analysis operations such as:

Notifications You must be signed in to change notification settings

AmirAli5/Data-Analytics-in-Excel

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

3 Commits
 
 
 
 

Repository files navigation

Data-Analytics-in-Excel

This repo on Data Analytics In Excel will help to understand the various crucial functions available in Excel, such as vlookup, hlookup, sumif/s, counif/s, iferror and others. Finally, you will see how to use the Data Analysis Toolpak to perform various data analysis operations such as:

  1. Basic of excel
  2. Lookup & functions
  3. Conditional formating
  4. Data validation
  5. Sorting and filtering
  6. Data analysis using toolpak

About

This repo on Data Analytics In Excel will help to understand the various crucial functions available in Excel, such as vlookup, hlookup, sumif/s, counif/s, iferror and others. Finally, you will see how to use the Data Analysis Toolpak to perform various data analysis operations such as:

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published