BUSINESS ANALYTICS WITH EXCEL TRAINING COURSE

The Business Analytics With Excel course is a compilation of the company’s core financial analysis approaches. The first section introduces financial modelling (from selecting tools to conceptual model building). The portion that follows is about practical application, in which we deal with various scenarios to discover new approaches and sophisticated Excel capabilities required in business analysis. The final session focuses on constructing financial models and overcoming common financial analysis issues with the help of the trainer.

BUSINESS ANALYTICS WITH EXCEL TRAINING COURSE
Play Video about BUSINESS ANALYTICS WITH EXCEL TRAINING COURSE

BUSINESS ANALYTICS WITH EXCEL TRAINING COURSE OVERVIEW

The Business Analytics With Excel course is a compilation of the company’s core financial analysis approaches. The first section introduces financial modelling (from selecting tools to conceptual model building). The portion that follows is about practical application, in which we deal with various scenarios to discover new approaches and sophisticated Excel capabilities required in business analysis. The final session focuses on constructing financial models and overcoming common financial analysis issues with the help of the trainer. Business analytics training course aims to introduce you to business analytics as a foundational part of your business education. Read More

BUSINESS ANALYTICS WITH EXCEL Training Key Features

Benefits

KEY FEATURES

KEY FEATURES

PERSONAL IMPACT

ORGANIZATIONAL IMPACT

Course Outlines

  • Differences between Spreadsheet and financial model
  • Types of financial models in Excel
  • Choosing the right tools
    Skills that will make you successful

Conceptual model
Golden rules in model building
Spreadsheet planning
Steps in model building
Data management
Version control and documentation

Problems with Excel
Strategies to avoid
How to create complicated formulars in easy way
Linking to external files
Model validation
Circular reference

Formulas and functions in Excel
Excel Shortcuts
Mathematical and Statistical functions
Logical functions and flow control
Nesting Functions
Best practices

Aggregating
Vlookup Hlookup
Working with dates
Index functions
Financial functions

Simple formating tools
Conditional formating
Sparklines charts

 

  • Formatting of Excel Sheets
  • Use of Excel Formula Function
  • Data Filter and Sort
  • Charts and Graphs
  • Table formula and Scenario building
  • Lookups
  • Pivot tables

Analysis of support; skill sets; Change management

 

  • Reading and Writing Data
  • Data types
  • Important Packages
  • Data Manipulation
  • Building models using learned algorithms
  • Evaluating and optimizing models

 

  • Awareness of Big Data and Hadoop
  • Nosql vs Sql
  • The four V’s
  • Is Big Data = Hadoop
  • Big Data and Cloud Computing
  • Generators of Big Data
  • Applications of Big Data

 

  • Text Analytics
  • Sentiment Analytics
  • Click Analytics, Google Analytics
  • Difference between Web and Mobile Analytics

Course Schedules

COURSE NAMEDURATIONCOURSE DATELOCATIONCOURSE FEE(excluding VAT)ENQUIRY FORMREGISTER
BUSINESS ANALYTICS WITH EXCEL3 DAYSAPRIL 12TH-14THIKEJAN280,000ENQUIRY FORMENROLL NOW
BUSINESS ANALYTICS WITH EXCEL3 DAYSJUNE 14TH-16THIKEJAN280,000ENQUIRY FORMENROLL NOW
BUSINESS ANALYTICS WITH EXCEL3 DAYSAUGUST 9TH-11THIKEJAN280,000ENQUIRY FORMENROLL NOW
BUSINESS ANALYTICS WITH EXCEL3 DAYSOCTOBER 25TH-27THIKEJAN280,000ENQUIRY FORMENROLL NOW
Explore something new

Training Options

Classroom Trainings

N280,000

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

Live Online Virtual Training

N280,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 Business Analytics Training FREE Self Improvement Template and eBook.

BUSINESS ANALYTICS WITH EXCEL TRAINING

Examination and Certification

Who should attend

Professionals from any department or organization looking to eliminate waste, reduce costs, and increase product and process successes – including engineering, operations, manufacturing, finance and accounting, purchasing, and general management.

 

 

  • Application Development Managers/Directors
  • Business Analysts
  • Systems Analysts
  • Systems Architect
  • Business Owners,
  • Accountants
  • Business development

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

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