- Ways to Train:
- Live Classroom Class is delivered at a Centriq location with a live instructor actually in the classroom.
- Live Virtual Class Class is delivered live online via Centriq's Virtual Remote technology. Student may attend class from home or office or other location with internet access.
- HD Class Class is delivered via award winning HD-ILT at Centriq's facility. Students view the live instructor utilizing a 60'' HD monitor.
- Ways to Buy:
- Retail Class can be purchased directly via check, credit card, or PO.
- CV Centriq Vouchers Class is available for students using Centriq Vouchers.
- CP Centriq Choice Pass Eligible Class is available to students utilizing Centriq Choice Pass program.
|Start Date||End Date||Duration||Days||Start Time||End Time||Time Zone||Location||Ways to Train||Ways to Buy||Price|
|Request a Date|
Excel is an electronic spreadsheet program that is part of the Microsoft Office suite. You use Excel to organize, calculate, and analyze data.
In Excel, you work with worksheets, which consist of rows and columns that intersect to form cells. Cells contain various kinds of data that you can format, sort, and analyze. An Excel file is called a workbook, which contains several blank worksheets.
*Note - This course is delivered on the 2019 version of the product & prepares students for the Microsoft Office Specialist and Expert exams for Excel 2019. Using an older version of Office today? There is 10% difference between 2013, 2016 and 2019.
Students will get the most out of this course if their goal is to become proficient in using Microsoft Excel to create basic worksheets and charts for data tracking and reporting. Students should have little or no experience using Microsoft Excel or any other spreadsheet program.
*Note – If you are unsure what course level you should take, you might consider taking a short self-assessment available
In order to be successful in this course, a learner should be comfortable using a personal computer and Microsoft Windows 10 or 11 including:
- Keyboard: Delete, Backspace, ESC, CTRL, Function keys, Number keypad
- Mouse: Left-click, Right-click, Double-click, Drag and Drop, Select/Highlight
- Windows: Toolbars, Maximize, Minimize, Move, Resize, Close
- File Management: Navigate to folders and files
- Browser: Open a web browser, type a URL via the address bar, navigate between multiple tabs and windows
In addition, potential students should be able to multitask, as the structure of this class will require you to listen, watch, read, type, and write—often all at the same time.
Please note: if you do not meet the basic computer skills (listed above), you must successfully complete our Computer and Excel Basics free learning path prior to enrolling in our instructor-led class. Please fill out this form for access to the free learning path.
It is imperative that all students in a single course possess a similar baseline skill level of computer basics; if it is determined during the start of class that you do not meet the prerequisites, you may be asked to leave class, complete the eLearning path, and reschedule class to a later date. This ensures a fair and equal learning environment for all students.
After completing this course, students will know how to:
- Open and interact with Excel and how to save and close workbooks
- Enter various kinds of data, formulas, and functions
- Format text and numbers, align
- Use various data-entry shortcuts
- Create charts
- Split and manage worksheet windows
- Use workbook properties, check workbooks for accessibility and compatibility issues, use templates
View the Microsoft Office Excel: Level 1 Training Course Outline
Lesson 1: Getting Started with Excel 2019
Topic A: Navigate the Excel User Interface
Topic B: Use Excel Commands
Topic C: Create and Save a Basic Workbook
Topic D: Enter Cell Data
Topic E: Use Excel Help
Lesson 2: Performing Calculations
Topic A: Create Worksheet Formulas
Topic B: Insert Functions
Topic C: Reuse Formulas and Functions
Lesson 3: Modifying a Worksheet
Topic A: Insert, Delete, and Adjust Cells, Columns, and Rows
Topic B: Search for and Replace Data
Topic C: Use Proofing and Research Tools
Lesson 4: Formatting a Worksheet
Topic A: Apply Text Formats
Topic B: Apply Number Formats
Topic C: Align Cell Contents
Topic D: Apply Styles and Themes
Topic E: Apply Basic Conditional Formatting
Topic F: Create and Use Templates
Lesson 5: Printing Workbooks
Topic A: Preview and Print a Workbook
Topic B: Set Up the Page Layout
Topic C: Configure Headers and Footers
Lesson 6: Managing Workbooks
Topic A: Manage Worksheets
Topic B: Manage Workbook and Worksheet Views
Topic C: Manage Workbook Properties