Certified Excel Professional™ | Certification | Universal Business Council

MODULES INCLUDED

Introduction to Certified Excel Professional™

  • MS Office Version
  • Excel Terminology: Workbook, Worksheet, Row, Column, Cell
  • Excel Menu Navigation
  • Excel Home Menu
  • Data and sheet formatting: Bold, Italic, Underline, Font family, font size, Color
  • Vertical, and Horizontal Alignment
  • Orientation & Indent
  • Wrap Text
  • Merge Cell
  • Data format: $, %, decimal position
  • Format Table & Format Cell
  • Insert Row, and Column
  • Delete Row, and Column
  • Column width, Row Height
  • Sum(), Max(), Min(), Average()
  • Find, Replace, Go To
  • Format Cells
  • Paste Special
  • Hide & Unhide
  • Cell Reference
  • Fix Cell Range
  • Data Menu
  • Sorting, Soring Level management
  • Filter, Advance Filter
  • Remove Duplicate
  • Define Name
  • Spell Check
  • Translate
  • Comments
  • Hyperlink
  • Protect sheet, and workbook
  • Data Consolidated
  • Goal Seek
  • Group & Ungroup
  • Text Functions
  • Math’s. Functions
  • Header & Footer
  • Object  m Symbol & Equation
  • Page layout
  • Header Freeze
  • Gridlines
  • Headings
  • Formula bar
  • Zoom in / Zoom out
  • Excel shortcut keys
  • Date Functions
  • Lookup functions: Vlookup, Hlookup, Index, Offset
  • Logical Function: if condition , And, Or, True, False
  • Financial Functions
  • Conditional Formatting – System defined option
  • Conditional formatting – Custom
  • Data from text file, MS access, other file system
  • Data from MS SQL Server
  • Text to Column
  • Data Validation: Number, Text, Date, List, Validation error message
  • Pivot Table: Filter, Row, Column, Filter
  • Power Pivot
  • Slicer
  • Graph and Its Type: Column , Line, Pie, Bar, Scatter
  • Graph axis, Data level, Legend
  • Reporting Best Practice
  • Report Sample Format
  • Dashboard Format
  • Dashboard Examples
  • There will be an online training followed by a multiple choice exam of 100 marks.
  • You need to acquire 60+ marks to clear the exam.
  • If you fail, you can retake the exam after one day.
  • You can take the exam no more than 3 times.
  • If you fail to acquire 60+ marks even after three attempts, then you need to contact us to get assistance for clearing the exam

Certification Benefits

  • Prove your skills as an expertExcel Professional.
  • Grasp the core methodology of Excel.
  • Gain a competitive advantage over others.

What you get?

  • Universal Business Council Certification
  • 24*7 Support for all your queries

CAREER FACTS

Top job functions

  • Business Development
  • Event Managers
  • Sales and Marketing Executives
  • Accountant and Auditors
  • Others

What does a Certified Facebook Marketer do?

Works with Excel tools and techniques to manage vast sets of data excellently.

The Growth Curve ahead:
Jr. Excel Expert
Sr. Excel Expert

Domains Blockchain experts work in

Retail, eCommerce, Banks, Telecom, FMCG, Manufacturing, and other domains.

Final Outcome

After completing this certification, you will master the core concepts and methods of Excel.

Success Stories

The following two tabs change content below.

ankita matreja

Latest posts by ankita matreja (see all)

Universal Business Council