25,000+ Courses Nationwide
0345 4506120

Microsoft Excel - 2013 Level 1

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.

Select specific date to see price, venue and full details.

Pre-Requisites

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.

Course Content

 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
 Reuse Formulas
 Manipulate Data
 Insert, Manipulate, and Delete Cells, Columns, and Rows
 Search for and Replace Data
 Spell Check a Worksheet
 Modify Fonts
 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 Worksheets
 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
 Customize Advanced and Trust Center Options

Related Courses

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the requested service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.

 

We work with the best