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.

Enroll Now
Enquiry
BASIC AND INTERMEDIATE EXCEL TRAINING
Play Video about BASIC AND INTERMEDIATE EXCEL TRAINING

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

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
BASIC AND INTERMEDIATE EXCEL TRAINING

Course Benefits

BASIC AND INTERMEDIATE EXCEL

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.
BASIC AND INTERMEDIATE EXCEL

Course Outlines

  • 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
  • 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
  • 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
  • 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
    • 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
  • 5.1 Create and Manage PivotTables

Course Schedules

COURSE NAMEDURATIONCOURSE DATELOCATIONCOURSE FEE(excluding VAT)ENQUIRY FORMREGISTER
BASIC AND INTERMEDIATE EXCEL2 DAYSFEBRUARY 8TH-9THIKEJAN60,000ENQUIRY FORMENROLL NOW
BASIC AND INTERMEDIATE EXCEL2 DAYSAPRIL 12TH-13THIKEJAN60,000ENQUIRY FORMENROLL NOW
BASIC AND INTERMEDIATE EXCEL2 DAYSJULY 12TH-13THIKEJAN60,000ENQUIRY FORMENROLL NOW
BASIC AND INTERMEDIATE EXCEL2 DAYSOCTOBER 18TH-19THIKEJAN60,000ENQUIRY FORMENROLL NOW
BASIC AND INTERMEDIATE EXCEL2 DAYSDECEMBER 6TH-7THIKEJAN60,000ENQUIRY FORMENROLL NOW
Explore something new

Training Options

Classroom Trainings

N60,000

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

Live Online Virtual Training

N55,000

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

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
Contact Us

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.

FREE Template
FREE eBook
BASIC AND INTERMEDIATE 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
Action Now

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

british council
bat
accenture
addax
airtel logo
chevron
gsk
gzi
lagos business school
larfage
mainone
mrs
mtn
nigerian breweries
nlng
nnpc
oando
sahara group
saipem
schneider
shell
sundry foods
wav
Previous image
Next image

Related courses

Related Courses

View all
BASIC PRIMAVERA
Project Management Software
BASIC PRIMAVERA
3 DAYS
N180,000

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
ADVANCED MICROSOFT EXCEL TRAINING
Microsoft Suite
ADVANCED MICROSOFT EXCEL TRAINING
2 DAYS
N150,000

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
ADVANCED MICROSOFT PROJECT 2019
Project Management Software
ADVANCED MICROSOFT PROJECT 2019
2 DAYS
N180,000

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
ORACLE RISK ANALYSIS
Project Management Software
ORACLE RISK ANALYSIS
2 DAYS
N180,000

ORACLE RISK ANALYSIS
Oracle Risk Analysis course provides training for Oracle Primavera’s Risk Management solution. Participants will gain a thorough background in the ...
Intermediate
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

ENROLL Today
  • +234-1-293 3181
  • 0803 3596025
  • mails@jkmichaelspm.com
  • Plot 14 Odeniran Close,Off Opebi Road,Ikeja,Lagos State,Nigeria.

Project

  • Project Management Certifications
  • Project Manager Skills
  • Agile & Scrum
  • Project Management Software
  • Industry Specific Courses
  • Masters Degree

PROCESS

  • Lean Six Sigma Certifications
  • Business Analysis & Data Science
  • Supply Chain & Procurement
  • ISO Management System & Audit
  • Business Process Management
  • Facility & Maintenance Management

PEOPLE

  • Human Resource Management
  • Strategy,Management & Leadership
  • Interpersonal & Administrative Skills
  • Finance & Accounting Courses
  • Health Safety & Environment

ADVANCED TECHNOLOGY

  • IT Governance & Service Management
  • Cyber Security & Resilience
  • Data Science & Business Intelligence
  • AI & Machine Learning
  • Software Development & Testing

Weekly Newsletter