We've noticed this is not your region.
Redirect me to my region
What do you want to learn today?

Advanced Excel Formulas and Functions Course

ENDED
Inquire Now
In-Person / Short Course
Ended last May 08, 2020
USD  1,000.00

Details

Click to view course content & register here as individual or group to attend:   https://tinyurl.com/syhg8j5

Click to download course calendar in PDF - https://bit.ly/2T3aCPv

Organizer: Foscore Development Center (www.fdc-k.org)

Course Fee: $ 1,000.00

INTRODUCTION

The course focuses on those aspects that are important in everyday day operation of organization. Intermediate users will also benefit from this course as it covers the in-depth topics of Complex Charts, PivotTables, Pivot Charts and management Dashboards. The program explores an advanced approach t data validation and excel. Participants will be able to boost their excel reporting expertise as a result of this training program.

 

DURATION

5 days

 

WHO SHOULD ATTEND?

Accountants, senior and junior accountants, business analysts, accounting and finance professionals, research professionals, marketing and sales, administrative staff, supervisors, general business professionals and staff from any function who need to learn and apply state-of-the-art techniques to their daily business reporting, reconciliations, and analysis.

 

COURSE OBJECTIVES

By the end of this course the participants will be able to:

  • Understand business analytics and its importance to business
  • Learn the functions of excel analytics
  • Learn the use of different datasets using slicers and pivotal tables
  • Understand solving of problems using Excel tools
  • Learn the application of statistical tools and concepts such as ANOVA and regression analysis using Excel
  • Use tables, and charts to represent the results
  • Learn the use of Power BI

 

DURATION

5 Days

 

WHO SHOULD ATTEND

This course targets professionals who are utilizing Excel and want to learn more on reporting, preparation, and analysis. The course also targets individuals who want to learn about business analytics via the use of  Advanced Excel.

 

COURSE OUTLINE

Business analytics introduction

  • Understanding business analytics
  • Analytics versus analysis
  • Forms of analytics
  • Analytics areas

 

Formatting using Excel

  • Custom Formatting
  • Conditional Formatting
  • Excel Functions
  • Logical Functions
  • Statistical Function
  • SUMIFS Function
  • HLOOKUP Function
  • Look up and Reference Functions
  • MATCH Function
  • COUNTIFS Function
  • INDEX and OFFSET Function
  • VLOOKUP Function

 

PIVOT Tables

  • Introduction to Pivotal tables
  • Groups of pivotal tables
  • Calculations (Custom)
  • Differentiation between calculated field and calculated item
  • Slicer creation

 

Excel dashboard

  • Meaning of a Dashboard
  • Designing a Dashboard
  • Chart Formatting
  • Interactive Dashboards and Charts

 

Business Analytics using Excel

  • Solver Addin
  • Histogram
  • Goal Seek
  • Data Table
  • Scenario Manager
  • Descriptive Statistics

 

Statistical Analysis using Excel

  • Testing hypothesis
  • ANOVA
  • Covariance
  • Correlation
  • Regression

 

Excel VBA

  • MsgBox
  • VBA variables
  • Events
  • Array
  • VBA functions
  • Application Object

 

Power BI

  • Power Pivot
  • Power View
  • Power Query
  • Power Map

 

General Notes

  • All our courses can be Tailor-made to participants needs
  • The participant must be conversant with English
  • Presentations are well guided, practical exercise, web based tutorials and group work. Our facilitators are expert with more than 10years of experience.
  • Upon completion of training the participant will be issued with Foscore development center certificate (FDC-K)
  • Training will be done at Foscore development center (FDC-K) center in Nairobi Kenya. We also offer more than five participants training at requested location within Kenya, more than ten participant within east Africa and more than twenty participant all over the world.
  • Course duration is flexible and the contents can be modified to fit any number of days.
  • The course fee includes facilitation training materials, 2 coffee breaks, buffet lunch and a Certificate of successful completion of Training. Participants will be responsible for their own travel expenses and arrangements, airport transfers, visa application dinners, health/accident insurance and other personal expenses.
  • Accommodation, pickup, freight booking and Visa processing arrangement, are done on request, at discounted prices.
  • One year free Consultation and Coaching provided after the course.
  • Register as a group of more than two and enjoy discount of (10% to 50%) plus free five hour adventure drive to the National game park, in Nairobi.
  • Payment should be done two week before commence of the training, to FOSCORE DEVELOPMENT CENTER account, so as to enable us prepare better for you.

 

  • For any enquiry at: [email protected] or +254712260031
  • Click to download our brochure here - http://fdc-k.org/FDC%20Brochure.pdf
  • Click to view course content and register using this link -https://tinyurl.com/syhg8j5
  • Click to view Business and Governance courses calendar –http://bit.ly/2FERaSh
  • Click to view all Courses calendar -http://bit.ly/2mB2p5w

Schedules

May 04, 2020 - May 08, 2020
ENDED
Weekdays 08:00 AM — 04:00 PM
No. of Days: 5
Total Hours: 40
No. of Participants: 10
Reviews
Be the first to write a review about this course.
Write a Review
Foscore Development Center(FDC-K) is a global training and consulting firm that has been serving leading businesses in many countries. We specialise in capacity building and talent development solutions for individuals and organisations, through our highly customised courses and experienced consultants, in a wide array of disciplines.
Foscore Development Center (FDC-K)
NAIROBI, NAIROBI, Kenya 208
+254712260031
Sending Message
Please wait...
× × Speedycourse.com uses cookies to deliver our services. By continuing to use the site, you are agreeing to our use of cookies, Privacy Policy, and our Terms & Conditions.