Customer Service: 800-778-7436     

To access your product click the Log In link at the top right of the screen. Once inside your account, you will be able to access your Packages, Self-Study Product, and Webinar Registrations.

Sign In to Your Surgent Account

Forgot Username or Password | Register for an Account

Microsoft® Excel® 365 and Excel® 2019: Getting Started with Excel (EX19)

  • Format Self-Study Download
  • Credits 4.00
  • Level Basic
  • Field of Study Computer Software & Applications (4)

Overview

Microsoft® Excel® 365 and Excel® 2019: Getting Started with Excel is a three-lesson basic level course that introduces you to the Excel software and then guides you through basic Excel features using step-by-step hands-on activities. Although this is a basic level course, experienced Excel users switching from earlier versions of Excel can benefit from this course’s review of commonly used features plus the introduction of new features, such as the new look for the Excel 365 Start screen or updated features in Excel 2019. Note that this course emphasizes using the traditional keyboard and mouse actions to perform tasks in Excel. Some relevant tips for working with Excel with a Windows touch-screen device are also provided.



Major Topics:

  • Lesson 1: identify ways to start Excel, recognize Excel Start screen elements including the Blank Workbook template, recognize Excel window elements, select Backstage view to open an existing workbook, identify worksheet navigation methods, select worksheet cells, rows, and columns, identify and select Excel user preferences, identify ways to get help in Excel, select methods to save and close a workbook, select methods to create a new workbook, select methods to close one or more workbooks, and select methods to close Excel
  • Lesson 2: identify ways to insert, reposition, select, delete, and rename worksheets, recognize ways to enter, edit, and format cell contents, select ways to create formulas, identify functions, identify ways to apply Accounting and Percent Style formatting, and select Flash Fill for data entry
  • Lesson 3: identify ways to show and hide worksheet elements, select methods to undo and redo an action, recognize ways to switch between Normal view, Page Layout view and Page Break Preview, and select page setup options, preview and print options

Learning Objectives:

  • Explain how the Excel software is used;
  • Start Excel;
  • Identify the components of the Excel window;
  • Describe a workbook and a worksheet;
  • Navigate and select in a worksheet;
  • Modify user options or preferences;
  • Create and save a workbook;
  • Enter, edit, and format text and numbers;
  • Create basic formulas and use functions;
  • Work in different worksheet views;
  • Preview and print a worksheet;
  • Work in Backstage view; and
  • Use the Quick Access Toolbar, the ribbon, Excel Help, the Tell Me feature, the Smart Lookup feature, shortcut menus, and keyboard shortcuts to perform tasks.

Who should take this course:

New Excel users or experienced Excel users switching from earlier versions

Be able to use: the mouse for items on your computer's screen; the keyboard and its numeric keypad to key text or numbers; and basic Windows OS features, such as the Start button, menus, desktop icons, Windows taskbar, and dialog boxes

None

No

No

No

QAS Approval Surgent IRS Approval Surgent CFP Approval Surgent CTEC Approval Surgent
CPE Webinars
CPE Webinars

Thank You!

Thank You! Your subscription has been submitted.