MICROSOFT EXCEL & POWER BI FOR PROFESSIONALS

Microsoft Excel and Power BI are the world’s most widely used business intelligence technologies. Having a deeper practical knowledge on how to perform different operations is essential for increased efficiency and productivity. In addition, knowledge of Excel and Power BI generally increases the employability portfolio of job seekers and professionals; and it a powerful transferable skill that is useful anywhere in the world.

In this course, participants will learn to expertly analyze given data using built-in functions, formulas, tools, tips and tricks. Furthermore, participants will be taught how to create a visually and insightful charts for decision making.

DURATION – 2 DAYS

WHO SHOULD ATTEND

This course is designed for Data, Business, Financial Analyst, Sales, HR, Marketing, Engineering, Administration, Production and all professionals who use the efficiency tools. All our course contents are developed and delivered by the highly experienced Excel MVP

OBJECTIVES

  • To understand drivers of business growth and sustainability
  • To learn the tips and techniques of improved customer relationships, marketing strategies and sales
  • To deepen participants’ knowledge of how to manage employees for retention and higher productivity
  • To learn how to prepare effective business planning
  • To help in finding solutions to most challenging and pressing problems in the business right now.

CONTENT

  1.  In-depth Excel Course Outline – Day 1
    • Introduction to Spreadsheet and General Excel Tabs • Quick Access Toolbar
    • Collapse and un-collapse ribbon tabs • Fill Handle and flash fill
    • Normal view, page layout and page break view • How to Split spreadsheet
    • Freeze Panes, Freeze Top Row, Freeze First Column
    • Basic Functions: SUM, AUTOSUM, AVERAGE, MAX, MIN, COUNT
    • Move/Copy sheet into a new workbook • Understanding relative and absolute cell references
    • Using formulas in context: Calculating Profit Margin, Subtotal, Discount and Total
    • Across sheets calculations • General Formatting in Excel • Using Format Painter tool
    • Center Across Selection • Alignment tools, Wrap Text and Orientation • Changing theme colors and fonts
    • Enabling Nigerian Naira currency symbol • Working with rows and columns
    • How to clean & transform data using Find and Replace • Filtering and Sorting: Single and Multiple criteria
    • Advanced Conditional Formatting • Data visualization using regular charts – Pie, Column, Line, Bar charts
    • Pros and cons associated with Pie charts. • Working with regular charts
    • Sharing charts to MS Word and PowerPoint

     

     

     

    In-depth Excel Course Outline – Day 2 (including Power BI)

    • Creating named ranges using Name Box, Defined Name and Create from Selection
    • Data analysis using COUNT, COUNTA, COUNTBLANK functions
    • Data analysis using COUNTIFS, SUMIFS & AVERAGEIFS functions
    • Data analysis using MAXIFS & MINIFS functions. • Understanding how Sparklines works.
    • Advanced Charting and Forecasting. •Creating and working with Table. • Structured References
    • Performing Subtotal. • Logical Functions: IF, AND, OR, Nested IF Statement
    • Data analysis using Pivot Table & Charts. • Understanding the pros and cons of Pivot Table
    • Working with Pivot Table. • Pivot Table Sorting & Filtering. • Introduction to VLOOKUP. • INDEX/MATCH
    • Excel shortcuts

     

    Power BI

    Power BI is a business data analytics program that provide interactive visualizations and business intelligence capabilities with an interface for end users to create reports and dashboards. Power BI Desktop is equipped with the tools required to import, transform, analyze and visualize data for sound decision making.

     

    In-depth Power BI Course Outline

    • Introduction to Power BI – Data Preparation, Cleaning & Transformation, Creating DAX Measures and Dashboard using visualization All training workbooks will be delivered in CD as discussed