In this course, you will gain a foundational understanding of the basic functionality in Excel 2013. You will begin by navigating the Excel 2013 environment. From there, you will perform the basic tasks associated with creating and saving Excel worksheets and exploring the Help system. You will use formulas and functions to perform calculations in your worksheets, and you will modify worksheets by manipulating cells and data, by searching for and replacing data, and by checking for spelling errors. You will format worksheets and prepare them for printing. You will also begin working with larger workbooks that contain multiple worksheets. Finally, you will customize how Excel behaves to more closely meet your needs.
This course is intended for people who want to gain the foundational understanding of Microsoft Office Excel 2013 that is necessary to create and develop worksheets.
This course prepares you for the Microsoft Office Excel 2013 Exam 77-420
and the Microsoft Office Excel 2013 Expert Exam 77-421.
Delegates will need to be familiar with using personal computers and should have experience using a keyboard and mouse. Before starting this course, delegates should be comfortable in the Windows 8 environment, and be able to use Windows 8 to manage information on their computers. Specific tasks the delegates should be able to perform include: launching and closing applications, navigating basic file structures, and managing files and folders.
Identify the Elements of the Excel Interface
Create a Basic Worksheet
Use the Help System
Create Formulas in a Worksheet
Insert Functions in a Worksheet
Insert, Manipulate, and Delete Cells, Columns, and Rows
Search for and Replace Data
Spell Check a Worksheet
Add Borders and Color to Cells
Apply Number Formats
Align Cell Contents
Apply Cell Styles
Define the Basic Page Layout for a Workbook
Refine the Page Layout and Apply Print Options
Format Worksheet Tabs
Manage the View of Worksheets and Workbooks
Customize General and Language Options
Customize Formula Options
Customize Proofing and Save Options
Customize the Ribbon and Quick Access Toolbar
Customize the Functionality of Excel by Enabling Add-Ins