Excel 2013 Introduction

Excel 2013 Introduction

COURSE DESCRIPTION

Microsoft Excel is one of the major workhorses in the Microsoft Office suite of applications and arguably the most widely used of them too. A solid understanding of how to use this program is vital to nearly everyone in most industries today.

This course is designed specifically to teach you the fundamentals of Excel and give you the skills you need to begin to create and manipulate worksheets. Specifically you will understand how to create, save, enter data and print spreadsheets in addition to learning how to create formulas and use functions to calculate in Excel. You will learn how to format spreadsheets, manipulate columns and rows, add headers and footers and use page setup options to prepare them for printing. You will also learn how to handle large worksheets or multiple workbooks and use collaboration tools to work in conjunction with other users.

Learn and Master Introductory Features in Excel 2013

1. Getting start with open files and navigating Excel

2. Understand basic skills like create new files, entering data, using AutoFill and saving

3. Create formulas, use functions, work with date math and understanding cell relativity

4. Edit workbooks, use Clipboard commands and work with find and replace

5. Format a workbook and modify its structure

6. Deal with the difficulties of work with large or multiple workbooks

7. Use collaboration tools to work with other users on the same files

8. Use the page setup commands to prepare to print a worksheet
   
   
   

Contents and Overview

During the four and half hours of content included in the 41 lectures, this course covers all the key features you need to know to get started with building and using Excel 2013 workbooks.

Upon completion you will be comfortable creating new workbooks and editing existing workbooks, creating formulas and doing basic calculations, setting up a workbook for printing and collaborating with other users on Excel files. You will have all the skills you need to prepare to take the Intermediate and Advanced levels of Excel training.

This course aligns with the CAP Body of Knowledge and should be approved for 4.5 recertification points under the Technology and Information Distribution content area. Email [email protected] with proof of completion of the course to obtain your certificate.

Unleash the power of Excel worksheets

Url: View Details

What you will learn

• Open files and navigate in Excel
• Create and save new files, enter data, use AutoFill and Flash Fill
• Create simple formulas and formulas containing functions

Rating: 4.45

Level: Beginner Level

Duration: 5 hours

Instructor: Intellezy Trainers