ADVANCED MICROSOFT EXCEL TRAINING

Microsoft Excel 2013 Advanced certification will establish your proficiency in handling both basic and advanced formulas and tools in the most commonly used spreadsheet software program.

ADVANCE MICROSOFT EXCEL
Play Video about ADVANCE MICROSOFT EXCEL

ADVANCED MICROSOFT EXCEL COURSE OVERVIEW

Microsoft Excel 2013 Advanced 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 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

KEY FEATURES

ADVANCE EXCEL TRAINING

Course Benefits

ADVANCE EXCEL TRAINING

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 offer 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 clearer picture of what’s being entered.
  • Create tracking systems for multiple departments and operations, as well as distinct workflow procedures.

Course Outlines

  • 1.1 Introduction
  • 1.2 Objectives
  • 1.3 Modify Workbook Templates
  • 1.4 – Business Scenario
  • 1.5 Demo – Modify Workbook Templates
  • 1.6 Merge Multiple Workbooks
  • 1.7 Business Scenario
  • 1.8 Demo – Merge Multiple Workbooks
  • 1.9 Manage Multiple Versions Of A Workbook
  • 1.10 Remove Workbook Metadata
  • 1.11 Copy Styles Between Tables
  • 1.12 Business Scenario
  • 1.13 Demo – Copy Styles Between Templates
  • 1.14 Copy Macros Between Workbooks
  • 1.15 Business Scenario
  • 1.16 Demo – Copy Macros Between Workbooks
  • 1.17 External Data Connections
  • 1.18 Business Scenario
  • 1.19 Demo – External Data Connections
  • 1.20 Protect Workbooks For Sharing
  • 1.21 Business Scenario
  • 1.22 Demo – Protect Workbooks For Sharing
  • 1.23 Protect Worksheet Structure
  • 1.24 Business Scenario
  • 1.25 Demo – Protect Worksheet Structure
  • 1.26 Set Tracking Options
  • 1.27 Business Scenario
  • 1.29 Restrict Editing And Limiting Editors
  • 1.30 Business Scenario
  • 1.31 Demo – Restrict Editing And Limiting Editors
  • 1.32 Encrypt Workbooks With A Password
  • 1.33 Business Scenario
  • 1.34 Demo – Encrypt Workbook With A Password
  • 1.35 Business Scenario
  • 1.36 Demo – Mark Workbooks As Final
  • 1.37 Control Calculations Options
  • 1.38 Business Scenario
  • 1.39 Demo – Control Calculations Options
  • 1.40 – Summary
  • 1.41 Mark Workbooks As Final
  • 1.42 Quiz
  • 2.1 Apply Custom Formats and Layouts
  • 2.2 Objectives
  • 2.3 Create Custom Formats (number, Time, Date)
  • 2.4 Business Scenario
  • 2.5 Demo – Create Custom Formats Number Date
  • 2.6 Create Custom Accounting Formats
  • 2.7 Advanced Fill Series Options
  • 2.8 Business Scenario
  • 2.9 Demo – Advanced Fill Series Options
  • 2.10 Create Custom Templates
  • 2.11 Create And Modify Cell Styles
  • 2.12 Business Scenario
  • 2.13 Demo – Create And Modify Cell Styles
  • 2.14 Create Custom Color Formats
  • 2.15 Business Scenario
  • 2.16 Demo – Create Custom Color Formats
  • 2.17 Create Custom Font Formats
  • 2.18 Business Scenario
  • 2.19 Demo – Create Custom Font Formats
  • 2.20 Create Themes
  • 2.21 Business Scenario
  • 2.22 Demo – Create Themes
  • 2.23 Create Form Fields
  • 2.24 Business Scenario
  • 2.25 Demo – Create Form Fields
  • 2.26 Control The Tab Order Of Objects
  • 2.27 Summary
  • 2.28 Quiz
  • 3.1 Introduction
  • 3.2 Objectives
  • 3.3 Nested Functions
  • 3.4 If, And, Or Functions
  • 3.5 Business Scenario
  • 3.6 Demo – If And Or Functions
  • 3.7 Advanced Sumifs Function
  • 3.8 Business Scenario
  • 3.9 Demo – Advanced Sumifs Functions
  • 3.10 Advanced Countifs Function
  • 3.11 Business Scenario
  • 3.12 Demo – Advanced Countifs Functions
  • 3.13 Advanced Averageifs Function
  • 3.14 Business Scenario
  • 3.15 Demo – Advanced Averageifs Functions
  • 3.16 What-if-analysis Tool
  • 3.17 Watch Window
  • 3.18 Business Scenario
  • 3.19 Demo – Utilize Watch Window
  • 3.20 Goal Seek
  • 3.21 Business Scenario
  • 3.22 Demo – Goal Seek
  • 3.23 Create Scenarios
  • 3.24 Business Scenario
  • 3.25 Demo – Create Scenarios
  • 3.26 Create Data Table
  • 3.27 Business Scenario
  • 3.28 Demo – Data Table
  • 3.29 Consolidate Data
  • 3.30 Business Scenario
  • 3.31 Demo – Consolidate Data
  • 3.32 Financial Functions
  • 3.33 Summary
  • 3.34 Quiz
  • 4.1 Introduction
  • 4.2 Objectives
  • 4.3 Pivotchart
  • 4.4 Create New Pivotcharts
  • 4.5 Business Scenario
  • 4.6 Demo – Create New Pivotcharts
  • 4.7 Pivotcharts With Animations
  • 4.8 Business Scenario
  • 4.9 Pivotcharts With Animations
  • 4.10 Manipulate Options In Existing Pivotcharts
  • 4.11 Business Scenario
  • 4.12 Manipulate Options In Existing Pivotcharts
  • 4.13 Pivotchart Styles
  • 4.14 Business Scenario
  • 4.15 Demo – Pivotcharts Styles
  • 4.16 Summary
  • 4.17 Quiz
  • 5.1 Introduction
  • 5.2 Objectives
  • 5.3 Introduction To Apps For Office
  • 5.4 Installing Apps From Office Store
  • 5.5 Business Scenario
  • 5.6 Demo – Installing Apps From Office Store
  • 5.7 Inserting And Managing Apps
  • 5.8 Business Scenario
  • 5.9 Demo – Inserting And Managing Apps
  • 5.10 Timeline Filter
  • 5.11 Business Scenario
  • 5.12 Demo – Timeline Filter
  • 5.13 Introduction To Powerview Report
  • 5.14 Create Powerview Report
  • 5.15 Business Scenario
  • 5.16 Demo – Creating Powerview Reports
  • 5.17 Powerview Reports Options
  • 5.18 Business Scenario
  • 5.19 Demo – Powerview Reports Option
  • 5.20 Summary
  • 5.21 Quiz

Course Schedules

COURSE NAMEDURATIONCOURSE DATELOCATIONCOURSE FEE(excluding VAT)ENQUIRY FORMREGISTER
ADVANCED MICROSOFT EXCEL2 DAYSFEBRUARY 9TH-10THIKEJAN150,000ENQUIRY FORMENROLL NOW
ADVANCED MICROSOFT EXCEL2 DAYSAPRIL 13TH-14THIKEJAN150,000ENQUIRY FORMENROLL NOW
ADVANCED MICROSOFT EXCEL2 DAYSJULY 13TH-14THIKEJAN150,000ENQUIRY FORMENROLL NOW
ADVANCED MICROSOFT EXCEL2 DAYSOCTOBER 19TH-20THIKEJAN150,000ENQUIRY FORMENROLL NOW
ADVANCED MICROSOFT EXCEL2 DAYSDECEMBER 7TH-8THIKEJAN150,000ENQUIRY FORMENROLL NOW
Explore something new

Training Options

Classroom Trainings

N150,000

  • Interactive,excitingly serious action oriented learning methodology
  • Classroom training by top instructors and practitioners

Live Online Virtual Training

N140,000

  • 90 days of flexible access to online classes
  • Live, online classroom training by top instructors and practitioners

Corporate Trainings

Customized to your team learning needs and organizational goals

  • Customized learning delivery model (digital material and/or instructor-led)
  • Flexible pricing options
  • Enterprise grade Learning Management System (LMS)
  • Enterprise dashboards for individuals and teams
  • 24×7 learner assistance and support

See WHAT OUR CUSTOMER SAYS

Testimonials

Maximize your Potential, Get Ahead

Download the JK Michaels Certified Cost Professional training FREE Self Improvement Template and eBook.

ADVANCE MS EXCEL Certification Training.

Examination and Certification

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

Why JK Michaels

You will gain practical,useful and impactful skills from our experienced faculties.

CONSULTANTS: Our consultants are Practical, Professional,Experienced, Licensed & Effective personnel with minimum experience of over 25years.
CONSULTANT RATING: 96% of our training consultants scored A+ rating from our customers in 2020

JK Michaels joins the prestigious group of organizations approved by Project management institute USA,American Academy of Project Management (USA),Scrum Study institute USA, to provide world class Effective project management training; After a rigorous audit of our curriculum design, delivery, facilitators, and content of our courses.

We are also accredited by government as a management training and consulting firm.In addition to other international institutes including :International institute of Business analysis(IIBA);(APMG)Association of Project Management Group;International institute of Six Sigma Certification;Peoplecert,Clover Health and Safety,Nebosh,Pregen Business School Atlanta,Simplilearn;International institute of Supply Chain Management (UK).
JK Michaels is in alignment with International Standard in Quality and Safety

We are committed on delivering on our customers trust.

CUSTOMER RATING: 95% of our customers rated JK Michaels program excellent and of great value compared to what they pay.
REFERRALS: 95% of our business comes from referrals.
TRUST: Our customer retention rate is 95%.
TRACK RECORD: In year 2019, 96.4% of our customers rated JK Michaels as EXCELLENT.

Excitingly different, action learning system focused on improving talents & impacting bottom-line results.

JK MICHAELS LEARNING SYSTEM™ : Practical Action Learning + fun + intellectual intensity = Uncommon Performance
JK MICHAELS CONSULTING SYSTEM™ : Excellent project +process +People + Technology = Uncommon Performance .
CONDUCIVE LEARNING ENVIRONMENT: 99% of our customers rate our facility conducive serene and secure with unmatched technology, gourmet lunch, free refreshment, and WIFI.

After undergoing our training, our customers reported a minimum of 35% boost in their productivity,70% of them get promoted to a higher level at work, 98.5 % pass professional exam at their first sitting and 100% get to network and share experience with employers and top management.

We promise to support you until you succeed.

COURTESY: You are assured of a courteous and friendly customer service that will work with you until you succeed.
RESPONSIVENESS: We guarantee that your enquiries will be responded to, in three minutes.

Extensive topical resources, white paper, articles.

 

Our Awesome Clients

Related courses

Get Started

Get Ahead,Accelerate your professional growth,Gain Mastery and Catapult yourself and organization to Outstanding Success

Project

PROCESS

PEOPLE

ADVANCED TECHNOLOGY

Weekly Newsletter

Layer 1