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