Excel 365 Apps (MO-210) Notes

Introduction

• LearnKey provides multimedia coursework for computer software, certifications, and application development.
• Expert instruction with dynamic video-based courseware and learning management systems.
• Course and support resources available on LearnKey.

Best Practices Using LearnKey Online Training

• Flexible for private students and organizations.
• Endorsed by recognized organizations (Certiport, CompTIA, Cisco, Microsoft).
• Expert instructors with high-level certifications.
• Training accommodates various learning styles (auditory, visual, kinesthetic).

Using This Workbook

• Contains practice projects to reinforce video knowledge.
• Aims to prepare for the MO-210 exam and enhance spreadsheet skills.
• Download a copy to save answers; cannot save on the web version.

Skills Assessment

• Rate skills on a scale of 1-5 for various Excel tasks (Importing data, navigating workbooks, etc).

Course Video Times

• Domain 1: Total time: 01:03:16
• Domain 2: Total time: 00:44:32
• Domain 3: Total time: 00:16:16
• Domain 4: Total time: 00:32:05
• Domain 5: Total time: 00:19:22

Domain 1: Starting an Excel Workbook

Overview

• Excel document = workbook; multiple pages = worksheets.
• Cells identified by column letter and row number (e.g., B2).

Steps to Start

1. Create a new workbook.
2. Add a worksheet.
3. Enter data in specified cells.
4. Save and familiar with worksheet structure.

Domain 1: Import Data

Import from Text Files

• Import data is quicker and more accurate than manual entry.
• Key is consistent delimitation (tabs, commas).

Steps to Import

1. Open blank workbook.
2. Import specified text files using the Text Import Wizard.
3. Save as Excel file.

Import from Online Files

• JSON and XML files can be imported as tables.

Domain 1: Navigate and Search

Search for Data

• Use Find tool to locate data across workbooks.

Navigate to Specific Areas

• Use Go To feature for quick navigation.

Domain 1: Hyperlinks

• Insert and remove hyperlinks for easy navigation.

Domain 1: Page Setup

• Change page size, margins, and orientation.

Domain 1: Adjust Rows and Columns

• Use AutoFit, manual adjustments for aesthetics.

Domain 1: Headers and Footers

• Add identifiers (file names, dates) to printed pages.

Domain 1: Quick Access Toolbar

• Customize toolbar for frequently used tasks.

Domain 1: Display Options

• Different views (Normal, Page Layout, Page Break) to manage worksheets.

Domain 1: Print Area and Settings

• Designate specific print areas; ensure information is clear when printed.

Domain 2: Manipulate Data

Use Paste Options

• Different methods to paste data (values, transpose).

Use AutoFill

• Fill data efficiently by dragging.

Insert and Delete Rows/Columns

• Improve worksheet appearance and organization.

Domain 3: Manage Tables

Create Tables from Ranges

• Organize data and enable filtering.

Apply Table Styles

• Enhance readability and visual appeal.
• Configure table style options (header row, banded rows).

Domain 4: Formulas and Functions

Insert References

• Understand and use relative, absolute, and mixed references.

Use Basic Functions

• Utilize functions like SUM, AVERAGE, MIN, MAX.

Use Count and Conditional Functions

• Apply COUNT, COUNTA, COUNTBLANK, IF functions.

Domain 5: Charts

Create and Modify Charts

• Visualize data through appropriate chart types (Column, Pie).

Add Data Series

• Update charts with new data.

Apply and Modify Chart Elements

• Customize titles, legends, labels for clarity.

Chart Styles and Layouts

• Predefined styles for quick formatting.

Accessibility Features

• Add alternative text for visually impaired users.

Appendix

Glossary of Terms

• Definitions for key Excel terms and functions (e.g., Absolute Reference, Conditional Formatting, etc.).

Keyboard Shortcuts

• A list of useful shortcuts to enhance productivity in Excel.