Skip to main content
Page

Microsoft Office Excel 2019: Part 1

Microsoft Office Specialist (MOS): Microsoft Excel


ARMY IGNITED CRITERIA

TRAINING NAME:


  • Microsoft Office Excel 2019: Part 1
         

FORMAT:

  • Online, On Demand

ASSOCIATED CREDENTIAL:


  • Microsoft Office Specialist (MOS): Microsoft Excel
  •  
  LOCATION &
SCHEDULES:

  • Virtual - Can be taken from any location, any time according to your schedule.
COST:
  • Contact Learn@AristaLearn.com for $
                TESTING VOUCHER or CERTIFICATE OF COMPLETION?
  • Certificate of completion
TARGET STUDENT:
  • This course is best suited for students looking to further their experience with Microsoft Office or Microsoft Excel. 
  PREREQUISITES:


  • There isn’t professional or academic eligibility required to apply for the MS Excel Certification. Candidates are just required to have the latest software installed on their computers to be able to run through the online exam. The requisites include: Microsoft Windows Vista SP2 or higher MS Office .NET Framework 4.0 or higher Adobe Flash Player 10.0 or higher High-Speed Broadband Internet Explorer


COURSE MATERIALS INCLUDE:

  • Access to on-line Learning Portal
  • Videos, training content, examples, quizzes, labs, and all items needed to learn the material and successfully pass this course!

                

HOW TO ENROLL:
  • Email Learn@AristaLearn for a Quote and Detailed Upload instructions


Course Overview

This course will introduce students to Microsoft Office Excel 2019, and teach students about performing calculations, modifying a worksheet, formatting a worksheet, printing workbooks, managing workbooks, adding borders and colors to worksheets, and basic Excel customization.

Chapter 01 - Getting Started with Microsoft Office Excel 2019

  • Topic A: Navigate the Excel User Interface
  • Spreadsheets, Worksheets, and Workbooks
  • Cells and Ranges, Cell and Range References
  • The General Excel UI
  • The Workbook and Worksheet UI Elements
  • Excel Window Commands
  • The Backstage View, Mouse Navigation, Mouse Cursor Icons
  • Keyboard Navigation, The Active Cell, Basic Data Entry
  • Demo - Navigating the Excel User Interface
  • Topic B: Use Excel Commands
  • The Ribbon, The Ribbon Tabs, Tell Me, ScreenTips and KeyTips
  • The Quick Access Toolbar, The Mini Toolbar and Context Menus
  • Demo - Using Excel Commands
  • Topic C: Create and Save a Basic Workbook
  • The New Tab, Excel 2019 File Formats
  • The Save and Save As Commands, The Save As Screen
  • Compatibility Mode, The Convert Option, The Compatibility Checker
  • Demo - Creating and Saving a Basic Workbook
  • Topic D: Enter Cell Data, It's Not WYSIWYG
  • Data Types, The Cut, Copy, and Paste Commands
  • Drag-and-Drop Cut and Paste
  • The Undo and Redo Commands
  • The AutoFill Feature
  • AutoFill Options, Flash Fill, The Clear Command
  • Demo - Entering Cell Data
  • Topic E: Use Excel Help, The Help Task Pane
  • Demo - Using Excel Help

Chapter 02 - Performing Calculations

  • Topic A: Create Worksheet Formulas
  • Excel Formulas, The Formula Bar
  • A Basic Mathematical Formula, Elements of Excel Formulas
  • The Order of Operations, Reference Operators
  • Intersection Operator Example
  • Demo - Creating Worksheet Formulas
  • Topic B: Insert Functions
  • Functions, The Function Library Group
  • The Insert Function Dialog Box
  • The Function Arguments Dialog Box
  • Graphical Cell and Range Reference Entry
  • The AutoSum Feature, Other Commonly Used Functions
  • Basic Function Syntax, The Formula AutoComplete Feature
  • The Arguments Tooltip, Demo - Inserting Functions
  • Topic C: Reuse Formulas and Functions
  • Formulas and the Cut, Copy, and Paste Commands
  • The Paste Options, The Paste Special Dialog Box
  • Relative References, Absolute References, Mixed References
  • AutoFill and Formulas, Worksheet References
  • Excel Errors and Display Issues, Error Indicators
  • Demo - Reusing Formulas and Functions

Chapter 03 - Modifying a Worksheet

  • Topic A: Insert, Delete, and Adjust Cells, Columns, and Rows
  • The Insert and Delete Options
  • Manual Width and Height Adjustments
  • Manual Fit, The AutoFit Feature
  • The Row Height and Column Width Dialog Boxes
  • The Hide and Unhide Commands
  • Demo - Adjusting Cells, Columns, and Rows
  • Topic B: Search for and Replace Data
  • The Find Command, The Replace Command
  • The Go To Dialog Box, The Go To Special Dialog Box
  • Demo - Searching for and Replacing Data
  • Topic C: Use Proofing and Research Tools
  • The Spelling Dialog Box, The Thesaurus Task Pane
  • The Smart Lookup Task Pane
  • Demo - Checking the Spelling in a Worksheet

Chapter 04 - Formatting a Worksheet

  • Topic A: Apply Text Formats 
  • Fonts, The Font Group, Live Preview
  • The Format Cells Dialog Box, The Colors Dialog Box 
  • Hyperlinks, The Insert/Edit Hyperlink Dialog Box 
  • The Format Painter, Demo - Formatting Text in a Worksheet 
  • Topic B: Apply Number Formats, Number Formats, Number Format Tab 
  • Custom Number Formats, Demo - Applying Number Formats 
  • Topic C: Align Cell Contents 
  • Alignment Options, Orientation Options, The Indent Commands 
  • The Wrap Text Command, The Merge & Center Options 
  • Demo - Aligning Cell Contents 
  • Topic D: Apply Styles and Themes 
  • Cell Styles, Galleries, The Style Dialog Box 
  • The Merge Styles Dialog Box, Themes, Theme Components 
  • Guidelines for Using Themes 
  • Demo - Applying Cell Styles and Themes 
  • Topic E: Apply Basic Conditional Formatting 
  • Conditional Formatting, The Conditional Formatting Dialog Boxes 
  • The Highlight Cells Rules, The Top/Bottom Rules, Data Bars 
  • Demo - Applying Basic Conditional Formatting, Color Scales, Icon Sets 
  • Topic F: Create and Use Templates 
  • Templates, Templates and the Backstage View 
  • Demo - Creating a Template

Chapter 05 - Printing Workbooks

  • Topic A: Preview and Print a Workbook 
  • The Print Tab, Print Settings, Page Orientation, Margins 
  • Demo - Configuring and Previewing a Print Job 
  • Topic B: Set Up the Page Layout, Print Preview 
  • The Page Setup Dialog Box, The Print Area
  • The Print Titles Command, Page Breaks 
  • Workbook Views, Page Break Preview View 
  • Demo - Setting Up the Page Layout 
  • Topic C: Configure Headers and Footers 
  • Headers and Footers, Page Layout View, Contextual Tabs 
  • The Header & Footer Tools Contextual Tab 
  • The Header and Footer Dialog Boxes 
  • Demo - Configuring Headers and Footers

Chapter 06 - Managing Workbooks

  • Topic A: Manage Worksheets
  • Methods of Inserting and Deleting Worksheets
  • Tab Formatting Options, Drag to Reposition Worksheets
  • The Move or Copy Dialog Box
  • The Hide and Unhide Worksheet Options
  • Demo - Managing Worksheets
  • Topic B: Manage Workbook and Worksheet Views
  • Custom Views, The Add View Dialog Box, The Split Command
  • The Freeze Panes Options, The New Window Command
  • The Arrange All Command, The Arrange Windows Dialog Box
  • The View Side by Side Command, The Switch Windows Command
  • Demo - Managing Workbook and Worksheet Views
  • Topic C: Manage Workbook Properties
  • Workbook Properties in the Backstage View
  • The Properties Dialog Box, Custom Workbook Properties
  • Demo - Managing Workbook Properties

Chapter 07 - Adding Borders and Colors to Worksheets

  • Topic A: Add Borders and Colors to Worksheets
  • The Borders Drop-Down Menu
  • The Border Tab, Border Options,
  • Fill Options,
  • The Fill Tab
  • Sheet Backgrounds
  • Chapter 07 Review 

Chapter 08 - Basic Excel Customization 

  • Topic A: Customize General Options and the Excel UI 
  • The Excel Options Dialog Box 
  • The Customize Ribbon Tab 
  • The Customize the Ribbon List Hierarchy 
  • The Quick Access Toolbar Tab 
  • The Customize Quick Access Toolbar Menu 
  • Chapter 08 Review 
  • Course Closure