Office Productivity Training – Microsoft Office 2013 Excel Basic Series!

$49.00Read more

Description

This course provides students with the knowledge and skills to create spreadsheets and workbooks that can be used to store, manipulate, and share data.

Course Modules:

Module 01: Getting Started with Microsoft Excel 2013

(Duration: 32m )

  1. Workbook
  2. Topic A: Identify the Elements of the Excel Interface
  3. Microsoft Excel 2013
  4. Spreadsheets, Worksheets, and Workbooks
  5. The Excel Interface
  6. Cell References and the Formula Bar
  7. The Go To Feature
  8. ScreenTips and Key Tips
  9. Demo 1-1: Excel Elements
  10. Topic B: Create a Basic Worksheet
  11. The Ribbon
  12. The Backstage View
  13. Data Types
  14. Excel 2013 File Formats
  15. SkyDrive
  16. The Convert Option
  17. The Compatibility Checker
  18. Demo 1-2: Creating a Spreadsheet
  19. Topic C: Use the Help System
  20. The Excel Help Window
  21. Demo 1-3: Using Help System
  22. Lesson 01 Review
  23. Review Quiz (Number of attempts allowed: Unlimited)

Module 02: Performing Calculations

(Duration: 42m)

  1. Workbook
  2. Topic A: Create Formulas in a Worksheet
  3. Formulas
  4. The Formula Bar
  5. Elements of an Excel Formula
  6. Common Mathematical Operators
  7. The Order of Operations
  8. Demo 2-1: Creating Formulas
  9. Topic B: Insert Functions in a Worksheet
  10. Functions
  11. The Function Library
  12. Using the AutoSum Button
  13. The Formula AutoComplete Feature
  14. Demo 2-2: Insert Functions in a Worksheet
  15. Topic C: Reuse Formulas
  16. The Cut, Copy, and Paste Commands
  17. Relative References
  18. Absolute References
  19. Mixed References
  20. Demo 2-3: Reusing Formulas
  21. Lesson 02 Review
  22. Review Quiz (Number of attempts allowed: Unlimited)

Module 03: Modifying a Worksheet

(Duration: 36 m)

  1. Workbook
  2. Topic A: Manipulate Data
  3. The Undo and Redo Commands
  4. Auto Fill
  5. Live Preview
  6. The Clear Button
  7. Demo 3-1: Manipulating Data
  8. Topic B: Insert, Manipulate, and Delete Cells, Columns, and Rows
  9. The Insert and Delete Options
  10. The Hide and Unhide Options
  11. Demo 3-2: Adjust Display of Columns
  12. Topic C: Search for and Replace Data
  13. Cell Names and Range Names
  14. The Find Command
  15. The Replace Command
  16. Demo 3-3: Searching for and Replacing Data
  17. Topic D: Spell Check a Worksheet
  18. The Spelling Dialog Box
  19. Demo 3-4: Spell Checking a Worksheet
  20. Lesson 03 Review
  21. Review Quiz (Number of attempts allowed: Unlimited)

Module 04: Formatting a Worksheet

(Duration: 46 m)

  1. Workbook
  2. Topic A: Modify Fonts
  3. Fonts
  4. The Font Group
  5. The Format Cells Dialog Box
  6. Galleries
  7. Live Preview and Formatting
  8. The Mini Toolbar
  9. Demo 4-1: Modifying Fonts
  10. Topic B: Add Borders and Color to Cells
  11. Border Options
  12. Sheet Backgrounds
  13. Demo 4-2: Adding Borders and Color to Cells
  14. Topic C: Apply Number Formats
  15. Number Formats
  16. Number Formats in Excel
  17. Demo 4-3: Applying Number Formats
  18. Topic D: Align Cell Contents
  19. The Indent Commands
  20. The Wrap Text Command
  21. Orientation Options
  22. Demo 4-4: Aligning Cell Contents
  23. Topic E: Apply Cell Styles
  24. Cell Styles
  25. Demo 4-5: Applying Cell Styles
  26. Lesson 04 Review
  27. Review Quiz (Number of attempts allowed: Unlimited)

Module 05: Printing Workbook Contents

(Duration: 28 m )

  1. Workbook
  2. Topic A: Define the Basic Page Layout for a Workbook
  3. The Page Setup Dialog Box
  4. Workbook Views
  5. Headers and Footers
  6. Header and Footer Settings
  7. Page Margins
  8. Page Orientation
  9. Demo 5-1: Previewing a Workbook Before Print
  10. Demo 5-2: Applying Print Changes
  11. Topic B: Refine the Page Layout and Apply Print Options
  12. Zoom Options
  13. Page Breaks
  14. The Print Area
  15. Printing Titles
  16. Scaling Options
  17. Demo 5-3: Refine Print Layout
  18. Lesson 05 Review
  19. Review Quiz (Number of attempts allowed: Unlimited)

Module 06: Managing Large Workbooks

(Duration: 21 m)

  1. Workbook
  2. Topic A: Format Worksheet Tabs
  3. Tab Formatting Options
  4. Demo 6-1: Formatting Worksheet Tabs
  5. Topic B: Manage Worksheets
  6. Insertion and Deletion Options for Worksheets
  7. Hide and Unhide Options
  8. Worksheet References in Formulas
  9. Demo 6-2: Managing Worksheets
  10. Topic C: Manage the View of Worksheets and Workbooks
  11. The Split Command
  12. The Freeze Panes Options
  13. The Arrange All Command
  14. The View Side by Side Command
  15. Demo 6-3: Managing the View of Worksheets and Workbooks
  16. Lesson 06 Review
  17. Review Quiz (Number of attempts allowed: Unlimited)

Module 07: Customizing the Excel Environment

(Duration: 28 m )

  1. Workbook
  2. Topic A: Customize General and Language Options
  3. The Excel Options Dialog Box
  4. The General Options
  5. The Language Options
  6. Demo 7-1: Customizing General and Language Options
  7. Topic B: Customize Formula Options
  8. The Formulas Options
  9. Demo 7-2: Formula Options
  10. Topic C: Customize Proofing and Save Options
  11. The Proofing Options
  12. The Save Options
  13. Demo 7-3: Customizing Proofing and Save Options
  14. Topic D: Customize the Ribbon and Quick Access Toolbar
  15. The Customize Ribbon Options
  16. The Quick Access Toolbar Options
  17. Demo 7-4: Customizing the Quick Access Toolbar
  18. Topic E: Customize the Functionality of Excel by Enabling Add-Ins
  19. What Are Add-Ins?
  20. The DEVELOPER Tab
  21. The Add-Ins Dialog Box
  22. Demo 7-5: Customizing the Functionality of Excel
  23. Topic F: Customize Advanced and Trust Center Options
  24. The Advanced Options
  25. The Trust Center Options
  26. Demo 7-6: Customizing Advanced and Trust Center Options
  27. Lesson 07 Review
  28. Course Closure
  29. Review Quiz (Number of attempts allowed: Unlimited)

This course includes

  • On-demand video
  • 7 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!