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 |
| Certificate |
Digital & Hard Copy |
| Prerequisites |
Basic Computing |
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
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.
- MIS Executive
- Project manager or Coordinator
- Market Research Analysis
- Retail Store manager
- Business Analysts
- Data Journalists
- Financial Analysts
- Administrative Assistant
- Billing executive
- Data entry operator
- Excel Expert
- Support Office
- Office Executive
- Financial Modeler
- Sr Accounts Executive
- Microsoft Excel Expert
- Excel Data Executive - MIS
- Executive -Logistics
- Admin Executive
- Accounts Executive
Our Recruiters :
