Data Analysis – Advanced Excel: Analysis for Business Decisions

Data Analysis – Advanced Excel Course Overview

As the business world becomes more competitive, advancing your data analysis skills set is a decision that will keep you at the top of your career. The data analysis advance excel course covers advanced Excel techniques for collecting, presenting, describing and making inferences from sets of data. The course is suitable for individuals with good Excel skills.

Who Should Attend

  • Experienced individuals who manage data analysis activities in diverse fields
  • Working professionals seeking to change career, job or industry to data analysis related field
  • Individuals who meets the requirements and intend on starting a career in data analysis
  • Mid to senior-level executives in any sector

Handling Data in EXCEL

  • Lookup with VLOOKUP & HLOOKUP
  • Name Arrays for Reuse and Readability
  • Group Records with Nested IF Statements
  • Avoid Errors with IF and ISNUMBER
  • Create Dropdown Lists for Filtering & Create Unique Lists
  • Fast Lookup with INDEX and MATCH
  • Multi-Condition Lookup with DSUM, INDEX and MATCH
  • Create Rankings with SMALL and LARGE

Financial Functions

  • Conditional Math Functions
  • Internal Rate of Return (IRR)
  • Net Present Value (NPV) and Cash Multiple
  • Loan Amortization Table
  • Compound Annual Growth Rate (CAGR)

Introduction to Statistics in EXCEL

  • Mean, Median, & Mode
  • Percentile and PercentileRank
  • Frequency Distributions
  • Standard Deviation and Variance
  • Trends in Data
  • Introduction to Correlation

Data Modelling Tools

  • Rank
  • CHOOSE
  • Goal Seek
  • Perform Sensitivity Analysis

Using Excel’s Macro Recorder Tools

  • Inserting and Formatting Text
  • Running A Macro
  • Running a Macro with a Button
  • Edit Macro
  • Saving an Excel File that contains Macros

Pivot Tables & Dashboards

  • Inserting a Pivot Table
  • Prepare Data for Pivoting
  • Sort, Filter & Slicer
  • Creating Dashboards

Data Reporting With Excel Charts

  • Line Chart
  • Pie Chart
  • Bar Chart
  • Column Chart: Clustered, Stacked, 100% Stacked
  • Combination Chart

ALADE Oladele Tunmise

A rudimentary programmer with a vast understanding of failed business and investments. I’m an autodidact, in Crypto Trading, financial modeling business development and quite recently programming. My career has cut across several roles, organizations, and sectors. At the core I’m an individual in the early stages of his career with a reasonable level of analytical reasoning, research, planning and strategy implementation.

Adeola Badmus

I am Adeola, my 15-year professional career has spanned several roles, organizations, and sectors. I served as a project manager in IntroIT Consulting, Head of Institute / Chief Operating Officer for the Institute for Advance e-Studies, I currently hold the position as the senior project consultant & marketing director for Piston & Fusion. My qualification includes MSc. In Marketing, BSc. In Business Administration, Digital Marketing, Data Analytics, PMP, PRINCE 2, NEBOSH, Level 3 Award in Education & Training. I have been privileged to attend some of the best institutions globally, University of Lagos, Lagos Business School, and University of Liverpool (UK). I am a member of AMA, PMI & IOSH. I have trained over 4000+ professionals in marketing, branding, project management, data analytics and other business related programmes.

Participants enrolling for this programme will be required to have basic computing skills. Participants who meet the programme requirement should pay the course fee and complete the enrollment form 2 weeks before the programme kick off date.

Prospective applicants who do not meet the programme requirement but wants to join the programme should should follow the process detailed below.

Application Process

  1. Start a chat with the online course adviser or complete the application form
  2. Application will be reviewed by programme committee
  3. Application acceptance will be communicated by programme committee
  4. Pay the programme fee after receiving acceptance from the committee
  5. Check your mail for programme schedule and payment confirmation

    Participant’s Experience

    Preview Course

    What is included in the Course Programme Pack

    • Practice Manual & Textbook
    • Participants workbook & Exercises
    • Templates for professional practice
    • Local & international case studies
    • Recognized Certification of Completion
    • Branded Personalized programme pack & stationaries
    • Breakfast & Lunch – Buffet Menu
    • 3 Star Accommodation (Optional – Available on Request)

    Kindly note all training materials for the Virtual Online classes will be in electronic formats (PDF & MS Word)

    Data Analysis – Avanced Excel Course Fees & Dates for  Upcoming Classroom Classes In 2021

    Piston and Fusion offer the Course as Classroom in Lagos and Virtual Online Class in other states in Nigeria. See dates and fees for classroom and virtual online class.

    Programme Information

    Course Objective: The Programme focus is to impart the skills to manage data analysis processes and the use of data analysis tools
    Classroom Fee: ₦130,000
    Weekday Date: 16th Mar – 19th Mar 2021 | 4 Days: Tue – Fri| 9am – 4pm
    Weekend Date: 8th May – 29th May 2021 | 4 Weeks: Saturdays | 9am – 4pm
    Location: 122a Obadina Street, Omole Phase 1 Ikeja Lagos

    Why Piston & Fusion Ranked Amongst the Best Business Institute In Nigeria?

    • We have trained 6000+ professionals
    • We have over 10 years industry experience
    • Our facilitators are experienced and certified
    • We offer post training career advice and support

    Partners

    Companies we have trained

    image

    image

    image

    image

    Add to Wishlist

    Archive

    Working hours

    Monday 9:30 am - 6.00 pm
    Tuesday 9:30 am - 6.00 pm
    Wednesday 9:30 am - 6.00 pm
    Thursday 9:30 am - 6.00 pm
    Friday 9:30 am - 5.00 pm
    Saturday Closed
    Sunday Closed