MS Excel & Power BI

Start Date Batch Name Timings Days Duration Mode Amount Slots Available Cart
Nov 19,2018 Nov 2018 07:00 PM - 08:00 PM (PST) Monday - Friday 6 Weeks Online (Instructor Led) $399 ($299.00) 25

MS Excel & Power BI

Microsoft Excel is a powerful tool essential for managing and presenting data in today’s working environment. In this Microsoft Office training course, you gain the knowledge and skills to create and edit worksheets, use formulas and functions, simplify complex tasks, save time from repetitive tasks, and present your results in a consumable and professional format.

You will learn how to achieve the ICAgile Certified Professional in Foundations of DevOps (ICP-FDO) recognition , execute Continuous Deployment (CD) by coding sharp deployment pipelines, create real-time feedback by configuring continuous integration and building automation tools, Optimize operations by leveraging virtualization, containers, and cloud technologies.

  • Curriculumestimated time

  • Introduction to Microsoft Excel
    • Importing data from outside sources
      • Integrating data from other Excel sheets

      • Utilizing data from servers

      • Managing external links

      • Finding and removing duplicates

    • Excel tables and lists
      • How Excel tables work

      • Converting text to columns

      • Sorting and grouping table data

      • Adding data in a table or list

  • Acquiring and Conforming Data
    • Initial formatting
      • Configuring cell numeric formats

      • Aligning data within cells

      • Fitting cells to data size

      • Naming cells and cell ranges

    • Worksheet presentation
      • Hiding content in worksheetsFreezing worksheet areas

      • Freezing worksheet areas

      • Editing, modifying and saving templates

    • Innovative formatting
      • Styling cells and sheets with prebuilt styles

      • Conditionally formatting cells and data

      • Rotating and wrapping text

  • Worksheet Formatting and Presentation
    • Formula basics
      • Performing simple calculations

      • Specifying relative and absolute cell references

      • Examining formulas with the auditing tools

      • Concatenating text with the & operator

      • Introducing functions with the Wizard and Formula tabs

      • Working with statistical functions: SUM, MAX, MIN,COUNT and COUNTA

    • Cleaning up data and manipulating data further
      • Introduction to data analysis

      • Introduction to data visualization

      • Overview of self-service BI

  • Leveraging Formulas and Functions
    • Charting your data
      • Using Excel as a Power BI data source

    • Printing workbooks
      • Power BI desktop queries

  • Creating a Visual Presentation of Data
    • PivotTable basics
      • Relationships

      • DAX queries

      • Calculations and measures

    • Final workbook touches
    • Creating and managing macros
  • Introducing Advanced Excel Features
    • Course Outline Module
      • Creating Power BI reports

      • Managing a Power BI solution

    • Introducing Power BI
    • Power BI Data
    • Shaping and Combining Data
    • Modelling Data
    • Interactive Data Visualizations
  • Power BI