ADVANCED MICROSOFT EXCEL

Overview

Advanced Microsoft Excel 2013 certification will establish your proficiency in handling basic and advanced formulas and tools in the most commonly used spreadsheet software program. This certification training is critical for business and finance professionals and will enhance your understanding of the advanced tools used for organizing, visualizing, calculating and managing data in MS Excel 2013. It is ideal for those looking to improve their job prospects by adopting advanced Excel 2013 skills and knowledge.

[read more]

Why is this certification so desirable?

Expertise with Microsoft Excel 2013 is a highly desired skill set in today’s complex business environment where financial and business analysis creates a real competitive advantage. The Microsoft Excel 2013: MOS advanced certification verifies your ability to work with the feature-rich Excel 2013 application efficiently and effectively, helping you maximize the value of data, control costs more effectively through better analysis of business information and enhances your career opportunities. According to payscale.com, in high-growth industries, entry-level employees who hold a Microsoft Certified Solutions Associate (MCSA) certification or Microsoft Office Specialist (MOS) certification can earn up to $16,000 more annually than their peers.

ADVANCE MICROSOFT EXCEL TRAINING

LEARNING OUTCOME

At the end of JK Michaels training in advanced Microsoft Excel 2013, you will be able to:

Manage versions of a workbook and remove workbook metadata
Identify the steps for setting tracking options and limiting editors
Create custom accounting, colour and font formats
Manipulate options in existing pivot charts
List the steps for installing apps from the office store

PERSONAL IMPACT

Following are the learning benefits of the Advanced MS Excel training program:

Trained candidates will be able to carry out conditional formatting and apply it to tables, worksheets, PivotTables, and cells and also use formulas for applying conditional formatting.
It Creates Greater Efficiency and Heightens Productivity.
It Allows You to Better Use an Asset You Have Already Acquired.
Participants will be able to use VLOOKUP for finding relevant information or data from large spreadsheets.
Filter and sort data entailed here enables the professionals to quickly huge sets or lists of data and extract the necessary information.
Trained participants will be able to switch and upgrade to newer versions of MS Excel and begin with the new version.
Improving Productivity and Efficiency
Because of shortcuts that make work easier, the more proficient you are in Excel, the easier it will be to move around the system.

ORGANIZATIONAL IMPACT

Excel allows employees to deal with data and perform calculations, which increases productivity.
Excel helps to develop equations and offers additional information on critical business operations such as project efficiency and financial estimates.
Create an easy-to-understand data set that higher management can utilize to assess current initiatives or conditions in the firm.
Create spreadsheets that better organize data and give a clearer picture of what’s being entered.
Create tracking systems for multiple departments and operations and distinct workflow procedures.

JK Michaels institute also offers other products and courses, including BASIC AND INTERMEDIATE EXCEL, CISSP COURSE, MICROSOFT PROJECT, ADVANCED EXCEL, and BASIC EXCEL TRAINING.

[/read]

Training Calendar

Lagos Classes - WEEKDAY

MONTH	DAYS	Classroom	Virtual
January				Make Enquiry
February	8-9	N180,000	N170,000	Make Enquiry
March				Make Enquiry
April	17-18	N180,000	N170,000	Make Enquiry
May				Make Enquiry
June				Make Enquiry
July	10-11	N180,000	N170,000	Make Enquiry
August				Make Enquiry
September				Make Enquiry
October	23-24	N180,000	N170,000	Make Enquiry
November				Make Enquiry
December	11-12	N180,000	N170,000	Make Enquiry

testimonials

EJORH EBERECHUKWU COLLINS

Project Manager Nestoil

THE PROGRAM I ATTENDED HAS BEEN VERY ENLIGHTENING AND IMPACTFUL. I REALLY ENJOYED THE DELIVERY OF THE FACILITATORS.

AYOLUWA APATA

Project Manager MTN

JK MICHAELS EMBODIES A WEALTH OF EXPERIENCED AND KNOWLEDGEABLE FACILITATORS WITH A WONDERFUL DRIVE FOR COACHING AND SKILL DEVELOPMENT.THEIR INTERACTIONS AND EXAMPLES WERE REALLY HELPFUL.

DENNIS OSUBOR

NIGERITE LIMITED

IF YOU WANT AN INDEPTH UNDERSTANDING OF PROJECT MANAGEMENT DELIVERED EXCELLENTLY BY PLEASANT AND INTELLIGENT FACILITATORS WHO HAVE A DEEP KNOWLEDGE OF THE SUBJECT MATTER, COME TO JK MICHAELS.

MOWAIYE BAMIDELE

Process Improvement Manager Nigerian Brewery

JK MICHAELS HAS GOT FANTASTIC PROGRAMS WITH GREAT CONTENT DELIVERED WITH EXCELLENCE.

Curriculum

FAQs

WHO SHOULD ATTEND?

MS Excel Intermediate training program is ideal for- Candidates who are interested in extending their knowledge and understanding of Microsoft excel. Professionals who use Microsoft Excel to perform daily activities. Professionals working in marketing, accounting and is also best suited for pricing analysts and business analysts.

EXAMINATION FORMAT

Exam Type: Closed book, Multiple choice, multiple responses, matching, hotspot, etc. No Of Questions: 180 questions per paper, 175 scored Exam duration: 230 Minutes Result: The passing score is determined through psychometric analysis

Reviews

Features

JK Michaels is a PMI accredited ATP(Authorized Training Partner)
Earn 30 PDUs with Practical, live instructor led sessions
Ace the exam with 30 day, 60 day study plan by experts 2000 Free exam simulation question bank
Introduction to predictive and Agile software(microsoft project +JIRA) Poject Leadership Quotients Assessment
Regular monthly webinars,revisions and exam support.
Action-oriented learning through case studies,role plays ,games e.t.c

₦180,000.00

Course Features

Lectures 151
Quizzes 0
Duration 2 days
Skill level All levels
Language English
Students 0
Assessments Yes

PROJECT

PROCESS

PEOPLE