×
1
  • Class and Course

    The Complete Excel and Power BI workshop -from beginner to advanced skills

    This course will introduce participants, or remind participants of the basic functionality of Excel and Power BI and then move them quickly on to the more intermediate and advanced features of these applications which will provide the users with a great skillset back in the workplace.

    In Excel, we go from calculations, formatting and tables, to Pivot tables, automation and multiple workbook synchronization.

    Power BI is a key tool in displaying data in a user friendly way, enabling users to visualize key points and ideas.

    Day 1 - Beginning Excel

    1. Getting Started

    2. Performing Calculations

    3. Modifying a Worksheet

    4. Formatting a Worksheet

    5. Printing Workbooks

    6. Managing Large Workbooks




    Day 2 - Intermediate Excel

    1. Creating Advanced Formulas

    2. Analyzing Data with Logical and Lookup Functions

    3. Organizing Worksheet Data with Tables

    4. Visualizing Data with Charts

    5. Analyzing Data with PivotTables, Slicers, and PivotCharts



    Day 3 - Advanced Excel

    1.       Inserting Graphics

    2.       Enhancing Workbooks

    3.       Automating Worksheet Functionality

    4.       Working with Multiple Workbooks

    5.       Customizing the Excel Environment

    Day 4 - Introduction to Power BI

    1. Getting Started
    2. Working with Files
    3. Data Sources
    4. Working with Reports


    Day 5 - Next steps with Power BI

    1. Closer Look at Visualizations
    2. Advanced Visualization Features
    3. Working with Data and Calculations
    4. Power BI Web App


    Anyone who wants to improve their skills in Excel and Power BI

    Beginning Excel

    Getting started; calculations; modifying worksheets; formatting; printing

    Intermediate Excel

    Advanced formulas; logical and lookup functions; tables; charts; PivotTables

    Advanced Excel

    Graphics; enhancing; automation; multiple workbooks; customizing

    Power BI Part 1

    Getting started; working with reports; creating and modifying visualizations

    Power BI Part 2

    Advanced visualizations; working with data and calculations; web app

    None

    Currently there are no scheduled classes for this course.

    Click below to be alerted when scheduled

    Set a training goal, and easily track your progress

    Customize your own learning journey and track your progress when you start using a defined learning path.

    Icon
    In just few simple steps, you can customize your own learning journey in the discipline of your interest based on your immediate, intermediate and transitional goals. Once done, you can save it in NExTpert, the digital learning ecosystem, and track your progress.
    © 2024 SLB Limited. All rights reserved.