name

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

  • 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.

  • 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 :