A colorful illustration of a character named Piko4
Advance Excel Banner

...

COURSE DESCRIPTION

Explore GDF Education for an intensive course designed to enhance your Excel skills. Our program covers advanced formulas, data analysis, automation techniques, and more. Join GDF Education to unlock the full potential of Excel and excel in your career or academic pursuits.

CERTIFICATION

GDF Skills' Advanced Excel Certificate will take you on a revolutionary experience. Develop the skills necessary to flourish in the Advanced Excel era and establish yourself as a leader in the competitive field of Advanced Excel. Join us to become a certified Advanced Excel professional!

  • 3 Months
  • 6 Months
  • 1 year

ELIGIBILITY:
Graduation/DBA/ Diploma/
Equivalent/10+2

COURSE FEE:
Rs 20k

  • 1.M W F
  • 2.T T S

COURSE PLACEMENT:

WHY TO CHOISE US:

  • 1.M W F
  • 2.T T S
MODULES
Module 1 - ADVANCED EXCEL
expand_more

    Objective

    Provide Basic Understanding of Excel, Make user Familiar to Create Formula and give Platform to Make Good Analysis and Introduce Powerful Tools of Advanced Excel so that user can Make Advanced Analysis with the help of Those Tools
  1. Introduction to Excel
    • o Basic Understanding Menu and Toolbar, Introduction to different category of functions like Basics, Mathematical and Statistical, Date and Time, Logical, Lookup and References, Text and Information.
  2. Mathematical Functions
    • Sum, Sumif, Sumifs, Count, Counta, Countblank, Countif, Countifs, Average, Averagea, Averageif, Averageifs, Subtotal,
    • Aggregate, Rand, Randbetween, Roundup, Rounddown, Round, Sumproduct
  3. Date & Time Function
    • Date, Day, Month, Year, Edate, Eomonth, Networkdays, Workday, Weeknum, Weekday, Hour, Minute, Second, Now, Today, Time
  4. Text Functions & Data Validation
    • Char, Clean, Code, Concatenate, Find, Search, Substitute, Replace, Len, Right, Left, Mid, Lower, Upper, Proper, Text, Trim, Value, Large, Small Filters (Basic, Advanced, Conditional), Sort (Ascending, Descending, Cell/ Font Color), Conditional Formatting, Data Validation, Group & Ungroup, Data split.
  5. Statistical Function & Other Functions
    • Isna, Isblank, Iserr, Iseven, Isodd, Islogical, Isytext, Max, Min, Len, Right, Left, Mid, ,Maxa, Maxifs, Median, Minifs, Mina, Vara, Correl, Geomen
  6. Logical Functions
    • And, Or, If, Iferror, Not, Nested If
  7. Lookup & Reference Functions
    • VLookup, HLookup, Index, Match, Offset, Indirect, Address, Column, Columns, Row, Rows, Choose, Arrays Concept In Lookup Formula’s, Past Special, Past link
  8. Power Pivot- MIS, Data Analysis & Visualization
    • Pivot Table, Power Pivot, What-if Analysis, Data Table –One Variable and Two Variables, Data Analysis Using Statistics, Descriptive Statistics, ANOVA, Moving Average, Testing Hypothesis, Measuring Covariance and Correlation, Distribution, Regression, Graphs & Charts, Analysis Tool Pack, Solver, Histogram, Pareto, Water Fall, Import and Export data, Protect/Unprotect sheets/workbooks, Worksheet formatting and Print Display
  9. Data Collection Method
    • With Data Quality, Collaboration & Security Like Share Your Workbook On Share Drive With Quality
  10. Analysis Single/Multidimensional Analysis
    • Like Three Dimensional (3D) Tables, Sensitive Analysis Like Data Table, Manual What-If Analysis, Threshold Values, Goal Seek, One-Variable Data Table, Two-Variable Data Table
  11. Advanced Dashboard in Excel
    • Overview of Chart types, Chart Formatting, Active X Form Controls, Principle of great dashboard design, Selecting Correct Chart to display data, Interactive Charts with Form Controls, Combo box, Check Box, Scroll Bar and Radio Button, Interactive Dashboard with Form Controls, Form Controls for reports automation, Data Models using Power Pivot
Document

HOW TO APPLY

1

REGISTRATION

Begin your adventure with GDF Skills by registering in person at a branch. Fill out the offline form to get your admission. This step establishes your presence on the platform and sets the stage for your skill development.

2

DOCUMENTATION

Complete the paperwork procedure after registering. This might include giving extra information, validating your identification, or submitting academic and professional credentials. GDF Skills provides a safe and efficient documentation method to validate your profile.

3

GET STARTED NOW

You can begin after your documentation is accepted. Explore GDF Skills' extensive range of courses and select those that are relevant to your objectives. Make any required fees and obtain access to the learning materials, resources, and tools required for your chosen courses.

Related Courses

JAVA
PHP
IT-EXPERT
BLOG

You're a beginner or have little bit knowledge of web designing and want to set a career in Web Designing, then you should learn from the beginning. In our complete web designing course, we will train you with all the knowledge of web designing and teach you on all the latest web-based technologies. This course will enable you to make your own web site in a single day. We bring students through a live environment in which you get an opportunity to work on live web sites as per to your skill sets. We will teach you how to create a web site as well as how to make it appear on google. We guarantee you an edge over others. The Advanced Website designing certification course is totally practical web design training that includes all the prerequisites of responsive web design on the basis of latest market demands and trends. This course is one of the professional practical courses offered by Arth, a top web designing organization. Arth is very good in its student’s placement by its 100% placement help policy. There are many companies tied up with Arth; all companies are good and trending in IT field. We offer best than best placement assistance to our students for his/her brighten future. To know more information about Arth’s placement Assistance, you can visit here.

1 COMMENT

JASON ANDERSON

DECEMBER 14 , 2022

Lorem ipsum dolor sit amet, consectetur adipiscing elit. In et ipsum sit amet ex pulvinar mattis. Pellentesque vitae purus viverra, aliquet lacus in, fringilla massa. Suspendisse ac est a nisi aliquet sollicitudin. Interdum et malesuada fames.

LEAVE A COMMENT

Document