Microsoft Excel Online

Time & Location

Contact us to Schedule Courses
Virtual Instructor Led Hands on Courses

About the Course

Organizations the world over rely on information to make sound decisions regarding all manner of affairs. But with the amount of available data growing daily, the ability to make sense of all that data is becoming more and more challenging. Fortunately, this is where the power of Microsoft® Office 365 Excel® Online can help. Excel can help you organize, calculate, analyze, revise, update, and present your data in ways that will help the decision makers in your organization steer you in the right direction. It will also make these tasks much easier for you to accomplish, and in much less time, than if you used traditional pen-and-paper methods or non-specialized software. This course aims to provide you with a foundation for Excel knowledge and skills, which you can build upon to eventually become an expert in data manipulation.

COURSE CONTENT

GETTING STARTED WITH M365 EXCEL ONLINE

• Navigate the Excel User Interface

• Use Excel Commands

• Create and Save a Basic Workbook

• Enter Cell Data

• Use Excel Help

PERFORMING CALCULATIONS

• Create Worksheet Formulas

• Insert Functions

• Reuse Formulas and Functions

MODIFYING A WORKSHEET

• Insert, Delete, and Adjust Cells, Columns, and Rows

• Search For and Replace Data

• Sort Data

• Filter Data

FORMATTING A WORKSHEET

• Apply Text Formats

• Apply Number Formats

• Align Cell Contents

• Apply Basic Conditional Formatting

• Create and Modify Tables overview

VISUALIZING DATA WITH CHARTS

• Create Charts

• Modify and Format Charts

USING PIVOT TABLES

• Create a PivotTable

• Analyze PivotTable Data

MANAGING AND PRINTING WORKBOOKS

• Manage Worksheets

• Print a Worksheet or Workbook

PRESENTING VISUAL INSIGHTS WITH DASHBOARDS IN EXCEL

• Visualize Data with PivotCharts

• Filter Data Using Slicers and Timelines

• Create a Dashboard in Excel

CREATING GEOSPATIAL VISUALIZATIONS IN EXCEL

• Create Map Charts in Excel

• Customize Map Charts in Excel

PERFORMING STATISTICAL ANALYSIS

• Visualize Trendlines and Sparklines with Excel

• Analyze Data with the Data Analysis ToolPak

GETTING AND TRANSFORMING DATA

• Connect to Data with Queries

• Clean and Combine Data

• Shape and Transform Data

MODELING AND ANALYZING DATA WITH POWER PIVOT

• Create Data Models with Power Pivot

• Create Power Pivots

• Perform Advanced Data Analysis and Visualization

PRESENTING INSIGHTS WITH REPORTS

• Plan a Report

• Create a Report

Register
Prix
Qté
Total
  • 4 or more Course Participants
    $299
    +$38.87 HST
    $299
    +$38.87 HST
    0
    $0
  • 2 - 3 Course Participants
    $399
    +$51.87 HST
    $399
    +$51.87 HST
    0
    $0
  • Course Calendar Date Pricing
    $299
    +$38.87 HST
    $299
    +$38.87 HST
    0
    $0
  • 1 on 1 Training
    $499
    +$64.87 HST
    $499
    +$64.87 HST
    0
    $0
Total$0

Share This Event