eBSI Export Academy - Corona Virus - COVID-19 Response - Info Resources. Click to learn more...

Microsoft Excel Online - eBSI Export Academy
Microsoft Excel Online - eBSI Export Academy
Microsoft Excel Online - eBSI Export Academy

Microsoft Excel Online

Vendor
eBSI Export Academy
Regular price
€40.00
Sale price
€40.00
Tax included. Shipping calculated at checkout.

In this course, you will become familiar with some of the terms used when working with Excel, and how to use the basic features of the Excel interface. You will also learn how to create, view, navigate in, save, share, and print workbooks. The course also provides information on using Excel Online’s help features.

In this lesson you will learn how to:

  • Get started with Excel Online
  • Describe the basic components of Excel
  • Manage workbooks
  • Get help in Excel Online

    Course Topics:

    Lesson 1 - Getting Started

    TOPIC A: Getting Started with Excel Online

    • Logging into Office 365
    • Launching Excel Online
    • The Excel Online Interface
    • Creating a New Workbook
    • Closing Excel Online
    • Activity 1-1: Getting Started with Excel Online

    TOPIC B: Getting to Know Excel

    • What are Spreadsheets, Worksheets, and Workbooks?
    • What are Columns, Rows, Cells, and Ranges?
    • Navigating in Excel
    • Keyboard Navigation Options
    • Excel Formulas
    • Activity 1-2: Getting to Know Excel

    TOPIC C: Managing Workbooks

    • Opening a Workbook
    • Editing Your Workbook in Excel Desktop
    • Accessing Save Options
    • Using the Accessibility Checker
    • Printing a Workbook
    • Sharing a Workbook
    • Activity 1-3: Managing Workbooks

    TOPIC D: Getting Help in Excel Online

    • Using Tell Me
    • Accessing Advanced Help Options
    • Getting Accessibility Help
    • Activity 1-4: Getting Help in Excel Online
    • Course Summary
    • Review Questions
    • Review Questions Answers
    • Lesson Lab 1-1
    • Course Completion

    Lesson 2 - Adding Pictures and Shapes

    TOPIC A: Inserting Pictures

    • Inserting Pictures
    • Resizing Pictures
    • Rotating Pictures
    • Deleting Pictures
    • Adding Alternative Text
    • Activity 4-1: Inserting Pictures

    TOPIC B: Inserting Shapes

    • Inserting Shapes
    • The Drawing Tools – Format Contextual Tab
    • Resizing Shapes
    • Deleting Shapes
    • Activity 4-2: Inserting Shapes

    TOPIC C: Formatting Shapes

    • Changing the Shape Type
    • Applying a Style
    • Customizing Shape Fill and Outline
    • Adding Alternative Text
    • Activity 4-3: Formatting Shapes
    • Course Summary
    • Review Questions
    • Review Questions Answers
    • Lesson Lab 4-1
    • Lesson Lab 4-2
    • Course Completion

    Lesson 3 - Finalizing Workbooks

    TOPIC A: Using Comments

    • Inserting Comments
    • Showing and Hiding the Comments Pane
    • Editing Comments
    • Deleting Comments
    • Activity 7-1: Working with Comments

    TOPIC B: Managing Worksheets (Part One)

    • Viewing Worksheets
    • Inserting Worksheets
    • Deleting Worksheets
    • Duplicating Worksheets
    • Worksheet References in Formulas
    • Activity 7-2: Managing Worksheets (Part One)

    TOPIC C: Managing Worksheets (Part Two)

    • Hiding and Unhiding The Hide and Unhide Worksheets
    • Reordering Worksheets
    • Renaming Worksheet Tabs
    • Changing Tab Color
    • Activity 7-3: Managing Worksheets (Part Two)

    TOPIC D: Changing View Options

    • Using the Workbook Views Group
    • Showing and Hiding Workbook Elements
    • The Freeze Panes Options
    • Activity 7-4: Changing View Options
    • Course Summary
    • Review Questions
    • Review Questions Answers
    • Lesson Lab 7-1
    • Lesson Lab 7-2
    • Course Completion

    Lesson 4 - Formatting a Worksheet

    TOPIC A: Formatting Text

    • What is a Font?
    • The Font Group
    • The Format Painter
    • Creating Links
    • Activity 3-1: Formatting Text

    TOPIC B: Formatting Cells

    • Applying a Border
    • Applying a Fill
    • Changing the Number Format
    • Formatted Numbers and Cell Width
    • Customizing Number Formats
    • Activity 3-2: Formatting Cells

    TOPIC C: Aligning Cell Content

    • Alignment Options
    • The Indent Commands
    • The Wrap Text Command
    • Merge ​&​ Center Options
    • Activity 3-3: Aligning Cell Content

    TOPIC D: Using Find ​&​ Select Tools

    • The Find Command
    • The Replace Command
    • The Go To Command
    • Activity 3-4: Using Find ​&​ Select Tools

    TOPIC E: Applying Conditional Formatting

    • What is Conditional Formatting?
    • Applying Conditional Formatting Rules
    • Setting Conditional Formatting Options
    • Clearing Conditional Formatting
    • Activity 3-5: Applying Conditional Formatting
    • Course Summary

    Lesson 5 - Organizing Worksheet Data with Tables and Charts

    TOPIC A: Inserting Tables

    • What is a Table?
    • Creating a Table
    • Customizing Row Display
    • Inserting and Deleting Table Rows and Columns
    • Sorting and Filtering Table Data
    • Activity 5-1: Inserting a Table

    TOPIC B: Inserting Charts

    • Chart Types
    • Chart Elements
    • Inserting a Chart
    • The Chart Tools – Chart Contextual Tab
    • Moving Charts
    • Resizing Charts
    • Activity 5-2: Inserting Charts

    TOPIC C: Modifying Charts

    • Switching Row and Column Display
    • Using the Select Data Command
    • Changing the Chart Type
    • Adding a Chart Title
    • Modifying Chart Labels
    • Modifying Chart Axes
    • Modifying Charts
    • Course Summary
    • Review Questions
    • Review Questions Answers
    • Lesson Lab 5-1
    • Lesson Lab 5-2
    • Course Completion

    Lesson 6 - Using Pivot-Tables

    TOPIC A: Inserting PivotTables

    • What is a PivotTable?
    • Creating a PivotTable
    • The PivotTable Fields Task Pane
    • Working with PivotTable Data
    • Activity 6-1: Inserting PivotTables

    TOPIC B: Working with PivotTable Data

    • Expanding and Collapsing Data
    • Refreshing Data
    • Renaming Fields
    • Summarizing Values
    • Changing Value Display
    • Activity 6-2: Working with PivotTable Data

    TOPIC C: Sorting and Filtering PivotTable Data

    • Sorting Data
    • Using the Filters Pane
    • Using Label and Value Filters
    • Clearing Filters
    • Activity 6-3: Sorting and Filtering PivotTable Data
    • Course Summary
    • Review Questions
    • Review Questions Answers
    • Lesson Lab 6-1
    • Course Completion