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

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 variety of analytical capabilities for analyzing and comparing massive volumes of data.
  • You can generate 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

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

Maximize your Potential, Get Ahead

Download the JK Michaels Certified Cost Professional training FREE Self Improvement Template and 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

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