BASIC AND INTERMEDIATE EXCEL TRAINING

Basic And Intermediate Excel Training enables professionals to learn to handle advanced formulas and tools. This certification training helps the users enhance their function skills with calculation, graphic tools, pivot tools, converting lists to a table and more. It is ideal for those who are looking to improve their job prospects by adopting Excel 2013 advanced skills and knowledge.

BASIC AND INTERMEDIATE EXCEL TRAINING COURSE OVERVIEW

Basic And Intermediate Excel Training enables professionals to learn to handle advanced formulas and tools. This certification training helps the users enhance their function skills with calculation, graphic tools, pivot tools, converting lists to a table and more. It is ideal for those looking to improve their job prospects by adopting Excel 2013 advanced skills and knowledge. Read More

The course teaches the trainee the fundamental ideas of spreadsheets and how to utilise a spreadsheet programme on a personal computer. They will comprehend and be able to do entire spreadsheet activities such as creating, formatting, and using a spreadsheet. In addition, trainees will be able to do fundamental mathematical operations utilising basic formulae and functions.
Learning to use this programme confidently adds a beneficial addition to your employability portfolio. Every day, millions of job adverts needing Excel abilities are placed in the United States alone. Moreover, according to Burning Glass Technologies and Capital One research, digital skills contribute to higher earnings and better career chances when digital occupations increase significantly faster than non-digital jobs.
It is the second course in our Excel speciality. Excel Skills for Business builds on the solid foundations established in the Essentials course. Intermediate Capabilities I will broaden your Excel expertise to new heights. You will learn the strategies that will become integral to your daily usage of Excel. In this course, you will develop a solid foundation of advanced abilities that will allow you to manage enormous datasets and provide valuable reports. In addition, these essential strategies and tools will enable you to add a complex layer of automation and efficiency to your daily Excel chores.
We have assembled a fantastic teaching facilitator that will be with you every step of the way. Work your way through each new task step by step, and you’ll be surprised at how far you’ve gone in no time. This time, we’ll follow Uma’s struggles and tribulations as she tries to find her footing in a new role at the imaginary corporation PushPin. Those who have completed the Essentials course will be familiar with the firm. Working through these obstacles, typical in our daily lives, will allow you to more readily relate to and apply the skills and strategies taught each week to familiar and new circumstances.

Why is the certification most sought-after?

Several responsible positions across various industry sectors require professionals with good MS Excel skills to harness the power of macros, who can set the macro-security levels for protecting the organization against viruses. Macros also help organizations in bypassing data-entry functions. Employers across the globe seek professionals who are proficient in Excel shortcuts and macros. Following are some of the significant reasons which make this course most sought after:

Many businesses seek professionals who have vital data analyzing and organizing skills. Getting Microsoft Excel certified can give you a competitive edge over the others.
Employers generally rush through resume hunting for credentials that add value to their business. MS Excel is one such credential that can quickly get your resume noticed by recruiters.
High-paying profiles such as business analysts, administrative assistants, marketing managers and project managers demand Excel skills.

JK Michaels institute also offers other products and courses, including CISSP COURSE, ADVANCED EXCEL, and BUSINESS ANALYTICS WITH EXCEL.

KEY FEATURES

Access to digital books, approve course materials and textbook
Regular monthly webinars,revisions and exam support.
Action-oriented learning through case studies,role plays ,games e.t.c
Supplemental deep dive video lectures
Assistance in CV preparation,career profiling and job hunting

Course Benefits

Personal Impact

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

Designing spreadsheets and presenting data in a more appealing manner.
Data from different departments and corporations are being analyzed.
Design and develop tracking systems for various processes and operations.
Create equations to compare and quantify the data that has been collected.
Create graphs and charts to help you better comprehend the data;
In a spreadsheet, look for specific items that match your criteria.
Identify and correct faults as soon as possible;

Organizational Impact

Excel assists you and your company, in working with the most up-to-date business data.
At the same time, reduce the size of spreadsheets and increase the recovery of damaged files.
The Microsoft Office Fluent user interface in MS Excel makes it easy to find powerful capabilities when you need them.
Massive data sets can be imported, organized, and explored using greatly larger spreadsheets.
It allows for seamless and simple data entry.
MS Excel has a variety of analytical capabilities for analyzing and comparing massive volumes of data.
You can generate a visual representation of data and information using MS Excel.
Addition, subtraction, multiplication, division, average, total, mod, product, and other mathematical and logical processes are all performed by MS Excel.

Course Outlines

Lesson 00 – Overview Of MOS Intermediate Course

0.1 Welcome
0.2 Overview Of MOS Intermediate Course
0.3 Table Of Content
0.4 Course Objectives
0.5 Course Overview
0.6 Value Of Excel For Professionals
0.7 Value Of Excel For Organizations
0.8 Lessons Covered
0.9 Exam Pattern
0.10 Microsoft Excel 2013 Mos Intermediate Certification
0.11 Sources Of Information
0.12 Thank You

Lesson 01 – Manage And Share Workbooks In Ms Excel 2013

1.1 Manage And Share Workbooks In Ms Excel 2013
1.2 Objectives
1.3 Share Workbooks
1.4 Share workbooks (Contd.)
1.5 Business Scenario
1.6 Demo Summary
1.7 Track Changes
1.8 Highlight Changes And Comments
1.9 Business Scenario
1.10 Demo Summary
1.11 Accept And Reject Changes
1.12 Business Scenario
1.13 Demo Summary
1.14 Formula Errors
1.15 Error Tracing
1.16 Business Scenario
1.17 Demo Summary
1.18 Quiz
1.19 Summary
1.20 Thank You

Lesson 02 – Apply Custom Formats and Layouts

2.1 Apply Custom formats and layouts
2.2 Objectives
2.3 Create Custom Conditional formats
2.4 Conditional Formatting Rule Types
2.5 Business Scenario
2.6 Demo Summary
2.7 Formatting cells Using Formulas
2.8 Formatting Celis Using Formulas (contd.)
2.9 Business Scenario
2.10 Demo Summary
2.11 Manage Conditional Format Rules
2.12 Manage conditional format Rules (contd.)
2.13 Business Scenario
2.14 Demo Summary
2.15 Create Advance Filters by Search
2.16 Business Scenario
2.17 Demo Summary
2.18 Create Advance Filters Using Values
2.19 Business Scenario
2.20 Demo Summary
2.21 Create Advance Filters by Colors
2.22 Business Scenario
2.23 Demo Summary
2.24 Modify Worksheets with Accessibility Tools
2.25 Modify Worksheets with Accessibility Tools (Contd.)
2.26 Business Scenario
2.27 Demo Summary
2.28 Display Data in Multiple international Formats
2.29 Business Scenario
2.30 Demo Summary
2.31 Proofing in other languages
2.32 Proofing in Other languages (Contd.)
2.33 Business Scenario
2.34 Demo Summary
2.35 Use international symbols
2.36 Use international Symbols (contd.)
2.37 Business Scenario
2.38 Demo Summary
2.39 Manage body and heading fonts
2.40 Manage body and Heading fonts (contd.)
2.41 Business Scenario
2.42 Demo Summary
2.43 Quiz
2.44 Summary
2.45 Thank You

Lesson 03 – Create Advanced Formulas in Excel 2013

3.1 Create Advanced Formulas in Excel 2013
3.2 Objectives
3.3 LOOKUP Functions
3.4 VLOOKUP Function
3.5 Syntax Arguments in VLOOKUP Function
3.6 Business Scenario
3.7 Demo Summary
3.8 HLOOKUP Function
3.9 Syntax Arguments in HLOOKUP Function
3.10 Business Scenario
3.11 Demo Summary
3.12 LOOKUP Function
3.13 Syntax Arguments in LOOKUP Function
3.14 Business Scenario
3.15 Demo Summary
3.16 TRANSPOSE Function
3.17 Business Scenario
3.18 Demo Summary
3.19 TODAY and NOW Functions
3.20 Business Scenario
3.21 Demo Summary
3.22 DAY MONTH and YEAR Functions
3.23 Business Scenario
3.24 Demo Summary
3.25 HOUR MINUTE and SECOND Functions
3.26 Business Scenario
3.27 Demo Summary
3.28 DATEVALUE and TIMEVALUE Functions
3.29 Business Scenario
3.30 Demo Summary
3.31 CONCATENATE Function
3.32 WEEKDAY and WEEKNUM Functions
3.33 Syntax Arguments in WEEKDAY and WEEKNUM Function
3.34 Business Scenario
3.35 Demo Summary
3.36 WORKDAY and WORKDAY INTL Functions
3.37 Business Scenario
3.38 Demo Summary
3.39 NETWORKDAYS and NETWORKDAYS INTL Functions
3.40 Business Scenario
3.41 Demo Summary
3.42 Quiz
3.43 Summary
3.44 Thank you

Lesson 04 – Create Advanced Charts in Excel 2013

Lesson 04 – Create Advanced Charts in Excel 2013
- 4.1 Create Advanced Charts in Excel 2013
- 4.2 Objectives
- 4.3 Trendlines
- 4.4 Linear Trendline
- 4.5 Logarithmic Trendline
- 4.6 Polynomial Trendline
- 4.7 Power Trendline
- 4.8 Exponential Trendline
- 4.9 Moving Average Trendline
- 4.10 Business Scenario
- 4.11 Demo Summary
- 4.12 Chart Elements
- 4.13 Filters in Charts
- 4.14 Dual Axis Charts
- 4.15 Business Scenario
- 4.16 Demo Summary
- 4.17 Create Custom Chart Templates
- 4.18 Business Scenario
- 4.19 Demo Summary
- 4.20 Quiz
- 4.21 Summary
- 4.22 Thank You

Lesson 05 – Create and Manage PivotTables

5.1 Create and Manage PivotTables

Course Schedules

COURSE NAME	DURATION	COURSE DATE	LOCATION	COURSE FEE(excluding VAT)	ENQUIRY FORM	REGISTER
BASIC AND INTERMEDIATE EXCEL	2 DAYS	FEBRUARY 8TH-9TH	IKEJA	N60,000	ENQUIRY FORM	ENROLL NOW
BASIC AND INTERMEDIATE EXCEL	2 DAYS	APRIL 12TH-13TH	IKEJA	N60,000	ENQUIRY FORM	ENROLL NOW
BASIC AND INTERMEDIATE EXCEL	2 DAYS	JULY 12TH-13TH	IKEJA	N60,000	ENQUIRY FORM	ENROLL NOW
BASIC AND INTERMEDIATE EXCEL	2 DAYS	OCTOBER 18TH-19TH	IKEJA	N60,000	ENQUIRY FORM	ENROLL NOW
BASIC AND INTERMEDIATE EXCEL	2 DAYS	DECEMBER 6TH-7TH	IKEJA	N60,000	ENQUIRY FORM	ENROLL NOW

Explore something new

Training Options

Classroom Trainings

N60,000

Interactive,excitingly serious action oriented learning methodology

Classroom training by top instructors and practitioners

Live Online Virtual Training

N55,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

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

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.

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.

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

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

BASIC AND INTERMEDIATE EXCEL Certification Training.

Examination and Certification

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

Why JK Michaels

Academic Excellence

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

INTERNATIONAL ACCREDITATION

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

WORLD CLASS REPUTATION

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.

UNIQUE LEARNING AND CONSULTING SOLUTION

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.

CORPORATE IMPACT

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.

DEDICATED CUSTOMER SERVICE

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.

INTERNATIONAL THOUGHT LEADERSHIP

Extensive topical resources, white paper, articles.

Our Awesome Clients

Related courses

Related Courses

View all

Project Management Software

ADVANCED PRIMAVERA

N280,000

admin

ADVANCED PRIMAVERA

Advance primavera P6 at JK Michaels will equip delegates with the project planning and analysis skill ,especially in resource management, cost cont...

Intermediate

2 DAYS

Preview this course

Add to Wishlist

N280,000

Project Management Software

BASIC PRIMAVERA

N180,000

admin

BASIC PRIMAVERA

Basic Primavera p6 will equip delegates with a thorough background in the concepts of planning and scheduling while learning P6.

Intermediate

3 DAYS

Preview this course

Add to Wishlist

N180,000

Microsoft Suite

ADVANCED MICROSOFT EXCEL TRAINING

N150,000

admin

ADVANCED MICROSOFT EXCEL TRAINING

Advanced Microsoft Excel Training will establish your proficiency in handling both basic and advanced formulas and tools in the most commonly used ...

Intermediate

2 DAYS

Preview this course

Add to Wishlist

N150,000

Project Management Software

ADVANCED MICROSOFT PROJECT 2019

N180,000

admin

ADVANCED MICROSOFT PROJECT 2019

Advanced Microsoft Project 2019 course has been designed for those who have some experience with Microsoft Project and wish to become familiar with...

Advanced

2 DAYS

Preview this course

Add to Wishlist

N180,000

Get Started

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

BASIC AND INTERMEDIATE EXCEL TRAINING

BASIC AND INTERMEDIATE EXCEL TRAINING COURSE OVERVIEW

Why is the certification most sought-after?

KEY FEATURES

Course Benefits

Personal Impact