Microsoft Office Excel Foundation
This course aims to provide a foundation for Excel knowledge and skills, which you can build upon to eventually become an expert in data manipulation.
Contact us for pricing
PrerequisitesTo ensure success, participants will need to be familiar with using personal computers and should have experience using a keyboard and mouse. Students should also be comfortable working in the Windows environment and be able to use Windows to manage information on their computers.
Course ObjectivesUpon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyze the data that is critical to the success of your organization.
Get started with Microsoft Office Excel.
Modify a worksheet.
Format a worksheet.
Getting Started with Microsoft Office ExcelNavigate the Excel User Interface
Use Excel Commands
Create and Save a Basic Workbook
Enter Cell Data
Use Excel Help
Performing CalculationsCreate Worksheet Formulas
Reuse Formulas and Functions
Modifying a WorksheetInsert, Delete, and Adjust Cells, Columns, and Rows
Search for and Replace Data
Use Proofing and Research Tools
Formatting a WorksheetApply Text Formats
Apply Number Formats
Align Cell Contents
Apply Styles and Themes
Apply Basic Conditional Formatting
Create and Use Templates
Printing WorkbooksPreview and Print a Workbook
Set Up the Page Layout
Configure Headers and Footers
Managing WorkbooksManage Worksheets
Manage Workbook and Worksheet Views
Manage Workbook Properties
ExcelExcel 2016Microsoft ExcelMicrosoft Excel 2016MS ExcelExcel 2019Excel 365