ADVANCED MICROSOFT EXCEL
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.
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
- 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
- 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.
Training Calendar
| MONTH | DAYS | Classroom | Virtual | |
|---|---|---|---|---|
| January | Make Enquiry | |||
| February | 6-7 | N305,000 | N305,000 | Make Enquiry |
| March | Make Enquiry | |||
| April | 16-17 | N305,000 | N305,000 | Make Enquiry |
| May | Make Enquiry | |||
| June | Make Enquiry | |||
| July | 9-10 | N305,000 | N305,000 | Make Enquiry |
| August | Make Enquiry | |||
| September | Make Enquiry | |||
| October | 22-23 | N305,000 | N305,000 | Make Enquiry |
| November | Make Enquiry | |||
| December | Make Enquiry |
testimonials
Curriculum
Curriculum
- 6 Sections
- 151 Lessons
- 2 Days
- Lesson 01 – Manage and Share Workbooks41
- 1.11.1 Introduction
- 1.21.2 Objectives
- 1.31.3 Modify Workbook Templates
- 1.41.4 – Business Scenario
- 1.51.5 Demo – Modify Workbook Templates
- 1.61.6 Merge Multiple Workbooks
- 1.71.7 Business Scenario
- 1.81.8 Demo – Merge Multiple Workbooks
- 1.91.9 Manage Multiple Versions Of A Workbook
- 1.101.10 Remove Workbook Metadata
- 1.111.11 Copy Styles Between Tables
- 1.121.12 Business Scenario
- 1.131.13 Demo – Copy Styles Between Templates
- 1.141.14 Copy Macros Between Workbooks
- 1.151.15 Business Scenario
- 1.161.16 Demo – Copy Macros Between Workbooks
- 1.171.17 External Data Connections
- 1.181.18 Business Scenario
- 1.191.19 Demo – External Data Connections
- 1.201.20 Protect Workbooks For Sharing
- 1.211.21 Business Scenario
- 1.221.22 Demo – Protect Workbooks For Sharing
- 1.231.23 Protect Worksheet Structure
- 1.241.24 Business Scenario
- 1.251.25 Demo – Protect Worksheet Structure
- 1.261.26 Set Tracking Options
- 1.271.27 Business Scenario
- 1.281.29 Restrict Editing And Limiting Editors
- 1.291.30 Business Scenario
- 1.301.31 Demo – Restrict Editing And Limiting Editors
- 1.311.32 Encrypt Workbooks With A Password
- 1.321.33 Business Scenario
- 1.331.34 Demo – Encrypt Workbook With A Password
- 1.341.35 Business Scenario
- 1.351.36 Demo – Mark Workbooks As Final
- 1.361.37 Control Calculations Options
- 1.371.38 Business Scenario
- 1.381.39 Demo – Control Calculations Options
- 1.391.40 – Summary
- 1.401.41 Mark Workbooks As Final
- 1.411.42 Quiz
- Lesson 02 – Apply Custom Formats and Layouts35
- 2.12.1 Apply Custom Formats and Layouts
- 2.22.2 Objectives
- 2.32.3 Create Custom Formats (number, Time, Date)
- 2.42.4 Business Scenario
- 2.52.5 Demo – Create Custom Formats Number Date
- 2.62.6 Create Custom Accounting Formats
- 2.72.7 Advanced Fill Series Options
- 2.82.8 Business Scenario
- 2.92.9 Demo – Advanced Fill Series Options
- 2.102.15 Create Advance Filters by SearchCopy
- 2.112.11 Create And Modify Cell Styles
- 2.122.12 Business Scenario
- 2.132.13 Demo – Create And Modify Cell Styles
- 2.142.14 Create Custom Color Formats
- 2.152.15 Business Scenario
- 2.162.16 Demo – Create Custom Color Formats
- 2.172.17 Create Custom Font Formats
- 2.182.18 Business Scenario
- 2.192.19 Demo – Create Custom Font Formats
- 2.202.20 Create Themes
- 2.212.21 Business Scenario
- 2.222.22 Demo – Create Themes
- 2.232.23 Create Form Fields
- 2.242.24 Business Scenario
- 2.252.25 Demo – Create Form Fields
- 2.262.27 Demo SummaryCopy
- 2.272.27 Summary
- 2.282.29 Business ScenarioCopy
- 2.292.30 Demo SummaryCopy
- 2.302.31 Proofing in other languagesCopy
- 2.322.33 Business ScenarioCopy
- 2.332.34 Demo SummaryCopy
- 2.342.35 Use international symbolsCopy
- 2.362.34 Demo SummaryCopy
- 2.372.37 Business ScenarioCopy
- Lesson 03 – Create Advanced Formulas35
- 3.03.1 Introduction
- 3.13.2 Objectives
- 3.23.3 Nested Functions
- 3.33.4 If, And, Or Functions
- 3.43.5 Business Scenario
- 3.53.6 Demo – If And Or Functions
- 3.63.7 Advanced Sumifs Function
- 3.73.8 Business Scenario
- 3.83.9 Demo – Advanced Sumifs Functions
- 3.93.10 Advanced Countifs Function
- 3.103.11 Business Scenario
- 3.113.12 Demo – Advanced Countifs Functions
- 3.123.13 Advanced Averageifs Function
- 3.133.14 Business Scenario
- 3.143.15 Demo – Advanced Averageifs Functions
- 3.153.16 What-if-analysis Tool
- 3.163.17 Watch Window
- 3.173.18 Business Scenario
- 3.183.19 Demo – Utilize Watch Window
- 3.193.20 Goal Seek
- 3.203.21 Business Scenario
- 3.213.22 Demo – Goal Seek
- 3.223.23 Create Scenarios
- 3.233.24 Business Scenario
- 3.243.25 Demo – Create Scenarios
- 3.253.26 Create Data Table
- 3.263.27 Business Scenario
- 3.273.28 Demo – Data Table
- 3.283.29 Consolidate Data
- 3.293.30 Business Scenario
- 3.303.31 Demo – Consolidate Data
- 3.313.32 Financial Functions
- 3.323.32 Financial Functions
- 3.333.33 Summary
- 3.343.34 Quiz
- Lesson 04 – Create Advanced Charts in Excel 201317
- 4.14.1 Introduction
- 4.24.2 Objectives
- 4.34.3 Pivotchart
- 4.44.4 Create New Pivotcharts
- 4.54.5 Business Scenario
- 4.64.6 Demo – Create New Pivotcharts
- 4.74.7 Pivotcharts With Animations
- 4.84.8 Business Scenario
- 4.94.9 Pivotcharts With Animations
- 4.104.10 Manipulate Options In Existing Pivotcharts
- 4.114.11 Business Scenario
- 4.124.12 Manipulate Options In Existing Pivotcharts
- 4.134.13 Pivotchart Styles
- 4.144.14 Business Scenario
- 4.154.15 Demo – Pivotcharts Styles
- 4.164.16 Summary
- 4.174.17 Quiz
- Lesson 05 – Excel 2013 Advance New Features22
- 5.05.1 Introduction
- 5.15.2 Objectives
- 5.25.3 Introduction To Apps For Office
- 5.35.4 Installing Apps From Office Store
- 5.45.4 Installing Apps From Office Store
- 5.55.5 Business Scenario
- 5.65.6 Demo – Installing Apps From Office Store
- 5.75.7 Inserting And Managing Apps
- 5.85.8 Business Scenario
- 5.95.9 Demo – Inserting And Managing Apps
- 5.105.10 Timeline Filter
- 5.115.11 Business Scenario
- 5.125.12 Demo – Timeline Filter
- 5.135.13 Introduction To Powerview Report
- 5.145.14 Create Powerview Report
- 5.155.15 Business Scenario
- 5.165.16 Demo – Creating Powerview Reports
- 5.175.17 Powerview Reports Options
- 5.185.18 Business Scenario
- 5.195.19 Demo – Powerview Reports Option
- 5.205.20 Summary
- 5.215.21 Quiz
- Lesson 06 – Creating Templates with Advanced Functions1
FAQs
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
You May Like
NEGOTIATION FOR RESULT
Negotiation for result are vital for career success. Learn to achieve results, create agreements and build relationships that last through effective negotiation. Negotiation skills...
SCRUM FUNDAMENTALS CERTIFICATION TRAINING (SFC)
SCRUM Fundamentals Certification Training (SFC) is a method for systematically identifying and eliminating flaws in all processes, products, and services. As a result, it...
PROBLEM SOLVING AND DECISION MAKING FOR MANAGERS
Problem Solving And Decision Making For Managers course will develop your skills as a critical thinker and problem solver. You learn to leverage your...
NEURO-LINGUISTIC PROGRAMMING TRAINING
Neuro-Linguistic Programming Training (NLP) course aims to teach some of the core principles of NLP in a simple, practical, and beneficial manner. This course...
SERVICE MARKETING COURSE
Service Marketing Course will strive to familiarize course members with marketing principles that can be applied explicitly to service businesses. This course will also...
Course Features
- Lectures 151
- Quizzes 0
- Duration 2 days
- Skill level All levels
- Language English
- Students 0
- Assessments Yes