About The Course

In this Advanced course of our Specialization Excel Skills for Business. We will prepare you to become a power user of Excel - this is your last step before specializing at a professional level. The topics we have prepared will challenge you as you learn how to use advanced formula techniques and sophisticated lookups. You will clean and prepare data for analysis, and learn how to work with dates and financial functions. An in-depth look at spreadsheet design and documentation will prepare you for our big finale, where you will learn how to build professional dashboards in Excel.

MS Excel is a highly used software for office work and it requires in the day to day professional life. It is highly necessary for an office worker to learn the Advance level excel for their personal as well as professional work. Certificate in Advance Excel (CAE) delivers the combination complete depth knowledge of all features of MS Excel advance level about the tools required for the development of Excel worksheet.

Course Highlights

Duration

3 Months or 36 Classes

Free Books

1 Books as Study Matireal

Examination

Online

Mode

Digital & Hard Copy

Prerequisites

Basic Computing

Detailed Syllabus

Chapter 1: Introduction of Advance Excel

Introduction

Excel Online

Excel workbook in your one drive accont

Excel mobile apps

Become familiar with new features in advance excel

Moving around a worksheet

Getting startred on your worksheet

Filling in the month names

Formatting number using the format cells Dialog box

Selecting complete rows and columns

Selecting noncontiguous ranges

Using the paste special dialog box

Date-related functions

Adjusting the page margins

Adding a eader and footer to your reports

Selecting a predefined header or footer

Advance excel (Basic Short Question & Answers)

Formulas

Chapter 2: Quick reference (SHEET & MISC QUESTION WITH ANSWER)

Short question related to MS excel

Formula

Chapter 3: Flash fill & data validation

Flash fill

Advance conditional formatting

Data validation

Chapter 4 : Data Table, Solver & Advanced Financial Analysis Set up

Data table and solver

Double decline balance method of depreciation (DDB)

Lookup function

And, Autosome, Count blank, Count if, Dcount, Dsum, Db

Chapter 5 : Conditional logics, lookup and charts

V lookup, Lower, Upper, Match, Product, Sin, Sum if, Rank, Sum Product, Subtotal, Goal Seek, Chart, Scenario, Consolidate

Chapter 6 : PowerPivot and Woking with other formulas

Pivot Table and Charts

Index

Match index

Mround

Chapter 7 : Functions and formulas with formatting

Economic value of product

Name of product for each class

Practical AssignmentPractical Assignment

Chapter 8 :Quick Reference - Sheet & Misc. Questions with Answer

Practical Assignment

Career Opportunity

Spreadsheet MS Excel software remains one of the most ubiquitous pieces of software used in workplaces around the world. Learning to confidently operate this software means adding a highly valuable asset to your employability portfolio. Across the globe, millions of job advertisements requiring Excel skills are posted every day. At a time when digital skills jobs are growing much faster than non-digital jobs, completing this course will position you ahead of others, so keep reading.