Understanding Functions Inserting Functions Nesting Functions Using Math & Trig Functions Using Statistical Functions Using Date and Time Functions Module 5: Formatting Your MS Excel Spreadsheetįormatting Cells with Styles and Color Applying Borders Changing Cell Alignment Formatting Text Converting Text to Columns Formatting Values Applying Themes Changing Sheet Tab Colors Changing Sheet Background Module 6: Find, Print, SpellCheck and More Using AutoCalculate Creating a Basic Formula Using Cell References in a Formula Techniques for Entering Cell References Troubleshooting a Formula Editing Cell Content Moving and Copying Cell Content Inserting, Deleting, Merging, and Splitting Cells Inserting and Modifying Rows and Columns Module 4: Microsoft Excel Functions

Viewing a Worksheet Splitting a Window Hiding Rows, Columns, and Worksheets Viewing Multiple Worksheets and Saving a Workspace or Custom View Navigating and Selecting in Worksheets and Workbooks Using Find, Go To, and Go To Special to Navigate to Specific Information in a Worksheet and Workbook Working with Multiple Workbooks Organizing Worksheets in a Workbook Managing Workbook Files Module 3: Excel Beginner Calculations, Formulas & Spreadsheet Layout Module 1: MS Excel FilesĬlosing, and Saving Files Entering Data Using Data Entry Time-Saving Features Getting Help While You Work Module 2: Finding Your Way Around Microsoft Excel View PDF of Excel Level 1 – Microsoft Excel Training for Beginners. You will use the Find and Replace feature, use themes to format workbooks and practice preparing, previewing, and printing worksheets. Learn to edit and manipulate cell content, modify worksheet structure, view and format worksheets, and use Microsoft Excel’s predefined functions. In this course, you will learn to create and manage worksheets and workbook files enter data and create basic formulas to perform calculations. Jump to Level 1 for Beginners, Level 2 for Intermediate Excel training, and Level 3 for the Advanced MS Excel course.Įach level of our MS Excel course is available at the following campuses:Įxcel Level 1 – MS Excel Training for Beginners

One-on-one support from our Learning Coaches who are there to help you over whatever hurdles you may encounter.Plenty of images and screen shots along with room for your own notes

Comprehensive textbooks that include all course material.Online access through the ILS (Integrated Learning System) to all materials including text, audio files, videos, and interactive Excel training.Each course includes everything you need for success. Microsoft Excel Certificate – Beginner, Advanced, And Expert Levels Continuing Education Excel Classes – The Best Excel Training CoursesĪcademy of Learning offers three Microsoft Excel training levels for every one from pure beginners, to those needing an Excel refresher, to those who need to upgrade their skills to an expert level.

Advanced microsoft excel training