Excel Basics 2019

Exam Questions: 100
Course Level: Basic
Pages: 480 | Content: 462, Supplemental: 18
NASBA Area of Study: Computer Software and Applications
Not Acceptable for: Enrolled Agents
Version: 7645

This course covers all the fundamental techniques you will need to know to create, edit, format, and print Excel worksheets, including any of the latest features that have been included with the latest release of Microsoft's Excel 2019 software. This is a basic course with the primary focus on the worksheet itself, but it will also explore a few basics of charting, creating data lists, and performing data analysis. Whether you are a new or experienced user of Microsoft Excel, you will find the information in this course to be helpful as a reference tool as well as for obtaining your CPE credits. PLEASE NOTE: Not accepted for Enrolled Agents. Computer program software is NOT included with courses. All course material provided. No prerequisites. Course level: Basic.

Choose Your Format to ADD TO CART:

Go to CART

Course Information

Table of Contents
  • Introduction
  • The Excel 2019 User Experience
  • Creating a Spreadsheet from Scratch
  • Making It All Look Pretty
  • Going Through Changes
  • Printing the Masterpiece
  • Maintaining the Worksheet
  • Maintaining Multiple Worksheets
  • Doing What-If Analysis
  • Playing with Pivot Tables
  • Charming Charts and Gorgeous Graphics
  • Getting on the Data List
  • Linking, Automating, and Sharing Spreadsheets
  • Top Ten Beginner Basics
  • The Ten Commandments of Excel 2019
  • Top Ten Ways to Manage Your Data
  • Top Ten Ways to Analyze Your Data
  • To recall where functions and commands can be located
  • To recognize how new worksheets are created
  • To recognize commands for formatting data tables
  • To identify editing functions
  • To recall the best procedures for printing reports and formulas
  • To identify how to freeze panes and split worksheets for better editing
  • To recognize the best procedures for working with multiple worksheets
  • To recall how to best perform different what-if analyses
  • To recognize the procedures for creating pivot tables
  • To identify how to create great-looking charts
  • To recognize how to manage data lists
  • To identify features for enhancing and sharing spreadsheets
  • To identify the most fundamental skills required to successfully use Excel 2019
  • To recognize the most important do's and don'ts when using Excel
  • To identify the most important features for managing large amounts of data
  • To recall the most essential features for analyzing spreadsheet data

PLEASE NOTE: CPE credit measurement is based on NASBA Registry and QAS guidelines of one credit for every 50 minutes. Credit calculation may vary in different states — check with your State Board of Accountancy. Unless otherwise noted in the specific course description, no advanced preparation is required in order to register or complete any PES CPE course. Use of materials or services provided by Professional Education Services, LP ("PES") are governed by the Terms and Conditions stated on PES' website www.mypescpe.com. PES provides these courses with the understanding that it is not providing any accounting, legal, or other professional advice and assumes no liability whatsoever in connection with its use. PES has used diligent efforts to provide quality information and material to its customers, but does not warrant or guarantee the accuracy, timeliness, completeness, or currency of the information contained herein. Ultimately, the responsibility to comply with applicable legal requirements falls solely upon the individual licensee, not PES. PES encourages you to contact your state Board for the latest information and to confirm or clarify any questions or concerns you have regarding your duties or obligations as a licensed professional.