International Trade Specialist Online Programme - Enrolments Open for 26 September Start - Click for Info

Microsoft Excel 365 Part 1 - eBSI Export Academy
Microsoft Excel 365 Part 1 - eBSI Export Academy
Microsoft Excel 365 Part 1 - eBSI Export Academy

Microsoft Excel 365 Part 1

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
  • Review Questions

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

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

Lesson 7. Working with Data

TOPIC A: A Closer Look at Formulas

  • The Formula Bar
  • Elements of an Excel Formula
  • Mathematical Operators
  • The Order of Operations
  • Types of References
  • Activity 2-1: A Closer Look at Formulas

TOPIC B: Using Formulas and Functions

  • About Functions
  • Creating a Function with AutoComplete
  • Using the Insert Function Dialog Box
  • Using AutoSum
  • Viewing AutoSum Calculations in the Status Bar
  • Automatic Workbook Calculations
  • Activity 2-2: Using Formulas and Functions

TOPIC C: Working with Data

  • Selecting Cells
  • The Cut, Copy, and Paste Commands
  • Using Paste Options
  • Moving Data with Drag and Drop
  • The Undo and Redo Commands
  • Using AutoFill
  • Using Flash Fill
  • Activity 2-3: Working with Data

TOPIC D: Working with Rows and Columns

  • Inserting Rows and Columns
  • Deleting Rows and Columns
  • Clearing Data from Cells
  • Changing Column Width and Row Height
  • The Hide and Unhide Options
  • Activity 2-4: Working with Rows and Columns

TOPIC E: Sorting and Filtering Data

  • The Difference Between Sorting and Filtering
  • Sorting Data
  • Enabling Filtering
  • Using the Filter Dialog Box
  • Using Text Filters
  • Clearing a Filter
  • Activity 2-5: Sorting and Filtering Data
  • Course Summary