Excel 2013 Level 1
CLASS DATE(s):
Request a Class

COURSE LENGTH: 1 Day

COURSE COST: $295

COURSE TIMES: 9:00am - 4:30pm

Printable version of this course
print

COURSE OVERVIEW

The breadth of business, educational, & organizational info in existence today is absolutely staggering. Organizations rely on this info to make sound decisions regarding all manner of affairs. But with the amount of available data growing on a daily basis, the ability to make sense of all of that data is becoming more challenging.

By applying the robust functionality that's built into Excel to your raw data, you will be able to gain a level of insight into that data that would have been nearly impossible just a couple of decades ago. Excel can help you organize, calculate, analyze, revise, update, & present your data in new ways. Of course, knowing exactly how to ask Excel the questions that you need answered, which questions you can even ask, and how to interpret the answers Excel gives is necessary before you can even begin to embark on the journey ahead. This course aims to provide you with the foundational Excel knowledge and skills necessary to begin that journey.

AUDIENCE AND PREREQUISITES

This course is intended for students who wish to gain the foundational understanding of Microsoft Office Excel 2013 that is necessary to create and work with electronic spreadsheets.

To ensure success, students will need to be familiar with using personal computers and should have experience using a keyboard and mouse.

Specific tasks the students should be able to perform include: opening and closing applications, navigating basic file structures, and managing files and folders.

FOLLOW UP COURSES  

*Course cost listed does not include the cost of courseware or lunch. Course is subject to minimum enrollment. Please contact us at learn@vtec.org or 207-775-0244 for additional pricing information, or if you have any questions.

COURSE TOPICS:


Topic 1: Getting Started with Microsoft Excel 2013
Navigate the Excel User Interface
Use Excel Commands
Create and Save a Basic Workbook
Enter Cell Data
Use Excel Help

Topic 2: Performing Calculations
Create Formulas in a Worksheet
Insert Functions in a Worksheet
Reuse Formulas

Topic 3: Modifying a Worksheet
Insert, Delete, and Adjust Cells, Columns, and Rows
Search for and Replace Data
Use Proofing and Research Tools

Topic 4: Formatting a Worksheet
Modify Fonts
Add Borders and Color to Worksheets
Apply Number Formats
Align Cell Contents
Apply Styles and Themes
Apply Basic Conditional Formatting
Create and Use Templates

Topic 5: Printing Workbooks
Preview and Print a Workbook
Define the Page Layout

Lesson 6: Managing Workbooks
Manage Worksheets
Manage Workbook and Worksheet Views
Manage Workbook Properties