Office Productivity Training – Microsoft Office 2019 Excel – Basic Series
Description
This course will introduce students Microsoft Office Excel Basic 2019, Getting Started with Microsoft Office Excel 2019, Performing Calculations, Modifying a Worksheet, Formatting a Worksheet, Printing Workbooks, Managing Workbooks Etc
- This mega Microsoft Office Excel bundle is perfect if you’re looking to finally get to grips with Excel Basic 2019. Each course goes into depth on how to get the most from each content and will help you become an basic user of Microsoft Excel 2019.
Series Taught By: Robert Kent
Requirements
- There is no required prerequisite for this course however, the candidates are expected to have a working knowledge of the Microsoft Office suite of products.
$49.00Read more
Course Modules
(Duration: about 3h )
- Workbook
- Course Introduction
- 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
- 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
- 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
- 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
- Entering Cell Data
- Topic E: Use Excel Help
- The Help Task Pane
- Using Excel Help
- Chapter 01 Review
- Review Quiz (Number of attempts allowed: Unlimited)
(Duration: — m)
- Workbook
- 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
- 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
- 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
- Reusing Formulas and Functions
- Chapter 02 ReviewReview Quiz (Number of attempts allowed: Unlimited)
(Duration: –m)
- Workbook
- 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
- 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
- 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
- Checking the Spelling in a Worksheet
- Chapter 03 ReviewReview Quiz (Number of attempts allowed: Unlimited)
(Duration: — m)
- Workbook
- 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
- Formatting Text in a Worksheet
- Topic B: Apply Number Formats
- Number Formats
- Number Format Tab
- Custom Number Formats
- Applying Number Formats
- Topic C: Align Cell Contents
- Alignment Options
- Orientation Options
- The Indent Commands
- The Wrap Text Command
- The Merge & Center Options
- 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
- 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
- Color Scales
- Icon Sets
- Applying Basic Conditional Formatting
- Topic F: Create and Use Templates
- Templates
- Templates and the Backstage View
- Creating a Template
- Chapter 04 Review
- Review Quiz (Number of attempts allowed: Unlimited)
(Duration: –m)
- Workbook
- Topic A: Preview and Print a Workbook
- The Print Tab
- Print Settings
- Page Orientation
- Margins
- Print Preview
- Configuring and Previewing a Print Job
- Topic B: Set Up the Page Layout
- The Page Setup Dialog Box
- The Print Area
- The Print Titles Command
- Page Breaks
- Workbook Views
- Page Break Preview View
- 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
- Configuring Headers and Footers
- Chapter 05 Review
- Review Quiz (Number of attempts allowed: Unlimited)
(Duration: — m)
- Workbook
- 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
- Managing Worksheets
- Topic B: Manage Workbook and Worksheet Views
- Custom Views
- The Add View Dialog Box
- The Split Command
- The Freeze Panes Options
- The Arrange All Command
- The Arrange Windows Dialog Box
- The View Side by Side Command
- The Switch Windows Command
- The New Window Command
- Managing Workbook and Worksheet Views
- Topic C: Manage Workbook Properties
- Workbook Properties in the Backstage View
- The Properties Dialog Box
- Custom Workbook Properties
- Managing Workbook Properties
- Chapter 06 Review
- Review Quiz (Number of attempts allowed: Unlimited)
This course includes
- On-demand video
- 6 downloadable Pdf Workbooks
- Unlimited time access (During Membership)
- Access on mobile and Desktop
- Certificate of Completion
Course Features Include:
Expert Lectures
Learn on-demand from top instructors who are industry subject matter experts. Our highly certified expert instructors possess a superior understanding of the subject matter in their fields and have the ability to convey this knowledge in an effective, engaging, and professional manner to a wide audience.Certificates of Completion
Upon completion of a series of courses you can earn a certificate of completion from Career Academy. Certificates of Completion will display your full name, course completed, as well as the date of completion. Students have the ability to print this out or save it digitally to showcase your accomplishment.PowerPoint Visuals:
Many of the in-depth theories and processes discussed in our courses can be learned most efficiently through the detailed PowerPoint slides presented. These visuals are accompanied by an instructor voice-over to provide our students with a clear, efficient, and complete presentation of concepts.Professional Development Activities
Students are provided access to professional development activity files which allow for an individual to test out course theories and apply the knowledge they earned from the course.Review Quizzes
Once a course is completed, test your knowledge by taking our course review quiz! Students have the ability to retake any review quizzes as many times as they wish to ensure they understand the material or to improve upon their scores.Mobile Access
With our universal course player, you can learn from your computer, tablet as well as mobile devices. Keep up with your training on the go!
Trusted by Aspiring IT Professionals, Corporations and
Government agencies for more than a Decade
Get unlimited online access learn anywhere, anytime using your computer or mobile device!