Loading

Excel Portable Genius

Exam Questions: 40
Course Level: Basic
Pages: 248 | Content: 232, Supplemental: 16
NASBA Area of Study: Computer Software and Applications
Not Acceptable for: Enrolled Agents
Version: 7990B

This course is perfect for the novice or experienced Excel user. It addresses the nine key questions Excel users are most likely to face in a fast-paced portable format, plus tips and advice on some of the program's lesser-known features. It will teach you how to sort, filter, organize, build formulas, chart data, and communicate your results by printing or sharing. You'll find it to be a great resource as you tackle this popular but sometimes difficult-to-learn spreadsheet program. PLEASE NOTE: Computer program software is NOT included with courses. Not accepted for Enrolled Agents. All course material provided. No prerequisites. Course level: Basic.

Choose Your Format to ADD TO CART:

Go to CART

Course Information

Table of Contents
  • How Do I Start Using Excel?
  • How Do I Make Changes to My Sheet?
  • How Do I Add Up the Numbers with Formulas?
  • When Do I Need to Include a Function?
  • How Do I Use Formatting to Enhance My Worksheet?
  • How Do I Use Graphics in Excel?
  • How Do I Manage Lists of Information?
  • How Do I Present My Data in Charts?
  • How Do I Print and Share My Content?
Objectives
  • To recall the keyboard shortcuts for opening new workbooks and closing Excel files
  • To identify the requirements for acceptable range names
  • To recall various formula operators and Excel's order of operations
  • To recall the uses for various Excel functions
  • To recognize the characteristics of the Accounting number format
  • To recall the types of images that can be inserted into Excel workbooks
  • To identify the types of files that can be imported into Excel
  • To recall the characteristics of the various charts used in Excel
  • To recall the capabilities of Microsoft's OneDrive

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.