![](https://valigence.com/wp-content/uploads/2022/11/888850.png)
Advanced Excel Functions refers to the features and functions of Microsoft Excel, which helps the user to perform complex calculations, perform data analysis, and much more. In this article, you will learn some of the most commonly used advanced functions in Excel.
Pre-requisite for the course
- Familiar with Statistics
- Programing knowledge
- Basic Excel knowlede
What you will learn
- Perform complex mathematical calculations
- Generate complex reports
- Use advanced excle feaures for statistical data analysis, sales forecasting, dashboard
Formating: fonts, numbers, tables, charts
Hide / Unhide
Sort / filter
Paste special
Find and select
Functions: Sum / Average / Count / Max / Min
Basic Text / date / time / lookup / information functions
Name manager
Formula Auditing
Data
Import from web
Import from text
Text to columns
Remove duplicates
Grouping and ungrouping
Basic Formula
Formulae that Add Subtract Multiply Divide
BODMAS Formula Error Checking
The Sum Function
Absolute Referencing
Problems with Absolute Relative Cell Referencing
Creating Absolute Mixed References
LOOKUP Functions
VLOOKUP
HLOOKUP Functions
MATCH with VLOOKUP Functions
INDEX & MATCH Functions
OFFSET, INDIRECT functions
PivotTables
Creating and Formatting Simple PivotTables
Page Field in a PivotTable
Formatting a PivotTable
Creating Modifying a PivotChart
Adding new calculated Fields Items
Changing the Summary Function
Consolidate Pivot table
Logical Functions
IFs and Nested IF Functions
Using AND OR NOT Functions
If Loop and Nested IF Loop Functions
Using IF ISERROR Functions
Statistical Functions
Using SUMIF, COUNTIF Functions
Using AVERAGE, COUNT, LARGER, SMALLER Function, Anova, Variance, standard diviations
Graphical Charts
The Chart Wizard
Chart Types
Adding Title, Legends, Lables
Printing Charts
Adding Data to a Chart
Formatting Renaming Deleting Data Series
Changing the Order of Data Series
Date / Time Functions
Using The Today
Now & Date Functions
Using The Datedif , Networkdays, Eomonth Functions
Using The Weeknum Functions
Using The Edate, Networkdays, INTL Weekdays INTL Functions
Modelling Regression Analysis
Creating a Clustering Model
Loan Prediction Problem
Working on Iris Data Set
Titanic Data
Boston Housing Data Set
Predict Stock Prices
Classifying MNIST digits using Logistic Regression
Intrusion Detection using Decision
CIFAR Data set
ImageNet Data Set
Credit Risk Analytics using SVM in Python
Valigence technologies benefits
- Provide students the in-depth hands on practices on Microsoft excel
- Each chapter is thoroughly explained in the classroom
- Get all concepts and formulae explained by IIM alumni and industry experts
- Get your resume free written by our industry HR
- Mock interviews and additional lectures on how to stand out from others in the interview room
- Placement Assistance through our wide alumni base
- Opportunity to speak with industry leaders who belong the communities including IITs, IIMs, NIT and other top management colleges in India
Quick Link for Other Courses
Join our demo class
Our Esteemed faculties
![](https://valigence.com/wp-content/uploads/2022/12/Raju_soni-removebg-preview.png)
![](https://valigence.com/wp-content/uploads/2022/12/webinar-landing-template-speaker-img-1.jpg)
![](https://valigence.com/wp-content/uploads/2023/04/WhatsApp-Image-2023-04-26-at-2.08.48-PM.jpeg)
Other Courses
![Advanced Excel](https://valigence.com/wp-content/uploads/2022/11/download-150x150.png)
![MIS Reporting](https://valigence.com/wp-content/uploads/2022/11/517-5178230_analytics-icon-jpeg-1-150x150.png)
![Help you make your business strategy](https://valigence.com/wp-content/uploads/2022/11/depositphotos_22867114-stock-illustration-business-strategy-concept-world-icon-1-150x150.jpg)
![Python](https://valigence.com/wp-content/uploads/2022/11/13541540425_63372041e1_z-150x150.jpg)
![stock-vector-data-warehouse-icon-logo-design-vector-illustration-713235949](https://valigence.com/wp-content/uploads/2022/11/stock-vector-data-warehouse-icon-logo-design-vector-illustration-713235949-e1670953258227-150x150.jpg)
What Our Students Have to Say
![](https://valigence.com/wp-content/uploads/2022/11/testimonial4-free-img.jpg)
![](https://valigence.com/wp-content/uploads/2022/12/online-programming-course-review-02.jpg)
![](https://valigence.com/wp-content/uploads/2023/05/images.jpeg)
![](https://valigence.com/wp-content/uploads/2023/05/s200_vidya.kumari.jpg)