Scribd Logo
Upload

Welcome to Scribd!

  • 112 views

    20779B 00

    Uploaded by

    douglas
    The document provides information about a Microsoft Official Course on analyzing data with Excel, including details about the instructors, objectives, prerequisites, outline, and certification opportunities. Students will learn how to import and analyze data from various sources using Excel and Power BI. Upon completion, students can pursue Microsoft certification to validate their skills and expertise in data analysis.

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd

    20779B 00

    Uploaded by

    douglas
    112 views20 pages
    The document provides information about a Microsoft Official Course on analyzing data with Excel, including details about the instructors, objectives, prerequisites, outline, and certification opportunities. Students will learn how to import and analyze data from various sources using Excel and Power BI. Upon completion, students can pursue Microsoft certification to validate their skills and expertise in data analysis.

    Original Description:

    ppt00

    Original Title

    20779B_00

    Copyright

    © © All Rights Reserved

    Available Formats

    PPTX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document provides information about a Microsoft Official Course on analyzing data with Excel, including details about the instructors, objectives, prerequisites, outline, and certification opportunities. Students will learn how to import and analyze data from various sources using Excel and Power BI. Upon completion, students can pursue Microsoft certification to validate their skills and expertise in data analysis.

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd
    Download as pptx, pdf, or txt
    112 views20 pages

    20779B 00

    Uploaded by

    douglas
    The document provides information about a Microsoft Official Course on analyzing data with Excel, including details about the instructors, objectives, prerequisites, outline, and certification opportunities. Students will learn how to import and analyze data from various sources using Excel and Power BI. Upon completion, students can pursue Microsoft certification to validate their skills and expertise in data analysis.

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd
    Download as pptx, pdf, or txt
    You are on page 1of 20

    Microsoft Official Course

    20779B
    Analyzing Data with Excel
    Welcome
    Thank you for joining us today.

    We’ve worked together with the At the end of class, please complete
    Microsoft Partner Network and an evaluation of today’s experience.
    Microsoft IT Academies to bring you We value your feedback!
    a world-class learning experience.
    Certification Exam Benefits. After
    Microsoft Certified Trainers + training, consider pursuing a
    Instructors. Your instructor is a Microsoft Certification to help
    premier technical and instructional distinguish your technical expertise
    expert who meets ongoing and experience. Ask your instructor
    certification requirements. about available exam promotions
    and discounts.
    Customer Satisfaction Guarantee.
    Our partners offer a satisfaction We wish you a great learning
    guarantee and we hold them experience and ongoing career
    accountable for it. success!
    Hello! Instructor introduction

    • Instructor: <Name>
    • <Title or other credentials, e.g.
    Microsoft Certified Trainer>
    • <Affiliation/Company>
    • <A few words about my technical
    and professional experience>
    Hello! Student introductions

    Let’s get acquainted:

    • Your name
    • Company affiliation
    • Title/function
    • Office 2016 experience
    • Product experience
    • Your expectations for the course
    Facilities

    • Class hours
    • Building hours
    • Parking
    • Restrooms
    • Meals
    • Phones
    • Messages
    • Smoking
    • Internet access
    • Recycling
    • Emergency procedures
    About this course: Audience

    • The audience for this course is anyone who has


    responsibility for analyzing data using Excel
    About this course: Prerequisites

    Before attending this course, students must have:

    • Basic knowledge of the Microsoft Windows


    operating system and its core functionality.
    • Working knowledge of Excel spreadsheets,
    functions and charts.
    • Working knowledge of relational databases.
    About this course: Objectives

    After completing this course, students will be able to:

    • Explore and extend a classic Excel dashboard


    • Explore and extend an Excel data model
    • Pre-format and import a .CSV file
    • Import data from a SQL server database
    • Import data from a report
    • Create measures using advanced DAX functions
    • Create data visualizations in Excel
    • Create a Power BI dashboard with Excel
    Your course materials (OPTIONAL)

    Designed to optimize your classroom learning experience


    and support you back on the job

    Microsoft Official Course handbook


    • Organized by modules
    • Includes Labs and Lab Answer Keys
    • Module Reviews and Takeaways
    make great on-the-job references

    NOTE
    This is an early-to-market edition of the course. Upon release of the next edition, you
    will be able to access the digital companion content from Microsoft Learning at:
    microsoft.com/learning/companionmoc
    Your course materials (OPTIONAL)

    Microsoft Official Course Handbook (Digital)


    • Access online using the Skillpipe reader by arvato, at
    http://skillpipe.com
    • Register/sign in and redeem your digital courseware
    • Easily add notes and comments, and highlight
    content
    • Organized by module
    • Includes Labs and Lab Answer Keys
    • Module Reviews and Takeaways make great on-the-
    job references

    Digital Companion Content


    • Supplemental content and helpful links
    • Download at:
    http://www.microsoft.com/learning/companionmoc
    Course outline

    Module 1
    Data Analysis in Excel

    Module 2
    The Excel Data Model

    Module 3
    Importing Data from Files

    Module 4
    Importing Data from Databases

    Module 5
    Importing Data from Excel Reports

    Module 6
    Creating and Formatting Measures
    Course outline

    Module 7
    Visualizing Data in Excel

    Module 8
    Using Excel with Power BI
    Microsoft Certification Program

    Get trained. Get certified.


    Get ahead.
    Microsoft Certifications demonstrate that Microsoft Certified
    you have the skills to design, deploy, and Solutions Expert
    optimize the latest technology solutions.
    (MCSE)
    Ask your Microsoft Learning Partner how you
    can prepare for certification.

    For more information about Microsoft Microsoft Certified


    Certifications, go to:
    Solutions Associate
    http://www.microsoft.com/learning/
    certification (MCSA)
    Preparing for the Labs

    Your lab activities will be centered around a fictitious company that we will call
    A. Datum Corporation, through which you will learn how to:

    • Implement Storage Spaces and Data Deduplication


    • Plan and configure high availability storage
    • Plan and configure disaster recovery solutions
    • Create and manage failover clusters
    • Manage highly available applications and services
    • Plan and configure storage with System Center 2012 R2
    Virtual Machine Manager
    • Plan and configure cloud-based storage
    • Implement a network load balancing cluster

    You will work in a VM environment to complete the labs.


    VM environment

    VM name Use as

    20779B-MIA-BI Windows 10 and Office 2016


    Microsoft Learning Azure Pass

    • You will use the Microsoft Learning Azure Pass to provide access to
    Microsoft Azure for demonstrations and labs

    • Microsoft Learning Azure Pass access and configuration

    • Best Practices for Microsoft Learning Azure Pass Usage:


    • Check the dollar balance of you Azure Pass within Microsoft Azure once you
    have set up your subscription, and be aware of how much you are
    consuming as you proceed through the labs.
    • Do not allow Microsoft Azure components to run overnight or for extended
    periods unless you need to do so.
    • Remove any Microsoft Azure–created components or services such as
    storage, virtual machines, or cloud services, after you finish your lab to help
    minimize cost usage and extend the life of your Microsoft Learning Azure
    Pass.
    WARNING – You May Experience UI Discrepancies
    (OPTIONAL)
    Given the dynamic nature of Microsoft cloud tools, you
    may experience Microsoft Office 365 and/or Azure user
    interface (UI) changes that were made following
    courseware development and that do not match up
    with lab instructions.

    The Microsoft Learning team will document these


    changes for instructors as they are brought to our
    attention. However, given the dynamic nature of cloud
    updates, you may run into changes before we become
    aware of them.

    If this occurs, you will have to adapt to the changes and


    work through them in the labs as necessary.
    Demonstration: Using Microsoft Labs Online (OPTIONAL)

    In this demonstration, you will learn how to:


    • Access the MLO lab environment
    • Switch between VMs

    Read the online Lab Notes carefully, because some procedures


    related to on-premises lab versus online labs may have slightly
    different steps. Any differences will be called out in the Lab Notes.
    Demonstration: Using Hyper-V Manager (OPTIONAL)

    In this demonstration, you will learn how to:


    • Open Hyper-V Manager
    • Navigate the various sections/panes within Hyper-V Manager:
    • VMs, snapshots, and actions (server-specific and VM-specific)
    • Identify the VMs you will use in the labs for this course
    • Take a snapshot and apply a snapshot
    • Connect to a VM
    • Start and sign in to a VM
    • Switch between full screen and window modes
    • Revert to the previous snapshot
    • Shut down a VM
    • Know when to shut down versus turn off a VM
    • Close Hyper-V Manager
    Demonstration: Navigation in Windows Server 2012
    (OPTIONAL)

    In this demonstration, you will learn how to:


    • Configure Hyper-V to use Windows key combinations in the VM
    • Sign in and sign out
    • Access applications
    • Access Control Panel
    • Use shortcut keys

    You might also like