Microsoft Excel 2013: Introduction

Producer: Gopas

Duration: 17 hours.
This product is an online product and is a single-user, 1-year licence.

Overview

In this course you will familiarise yourself with the Excel 2013 environment and its documents and you will learn to control them. You will learn in each lesson to create tables step by step. You will find out how to enter values correctly into the cells and how to set the cell formatting, including conditional formatting. You will learn to manipulate each cell and cell range, you will learn to work with worksheets and entire files. You will create a chart and learn to create calculations by basic arithmetic formulas.
The course takes the form of tutorial, exercise and quiz.

Course Content
- Pre-assessment (optional)
- 34 lessons
- Final test

This product allows the student to print a certificate from the course on successful completion.

The recommended settings to run this course are:
- Any of following internet browsers: Internet Explorer 6.0 or higher, Opera, Mozilla Firefox, Chrome; all with the Adobe Flash plug-in version 8.0 or higher
- 1 GHz CPU; 512 MB RAM; OS Windows 2000, XP, Vista or Windows7
- Display resolution of 1280 x 1024
- Soundcard, speakers or headphones are recommended

Topics

This course covers the following topics
• Introduction to the practical use of Excel
• Excel window
• Ribbon
• Presenting an Excel workbook
• Creation and saving of a workbook
• Opening an existing workbook
• Manipulating worksheets
• Navigation within a worksheet
• Cell range selection methods
• Adjusting rows and columns
• Data entry into cells
• Numeric values in cells
• Moving and copying cell values
• Moving and copying using the Clipboard
• Font formatting
• Alignment of data in cells
• Borders and fill
• Basic number formats
• Date, time and percentage number formats
• Cell styles
• Copying formatting
• Excel table
• Conditional formatting
• Basic formulas
• AutoSum
• Number and date fill series
• Text series and custom lists
• Sorting
• Recommended charts
• Instant data analysis
• Pictures in Excel
• Printing
• Customisation of the program settings
• Getting help with Excel

Objectives

Once you have completed this course you will be able to:
Enter values correctly into cells
Set cell formatting
Manipulate cells and cell ranges
Work with worksheets and entire files
Create charts
Create calculations with basic arithmetic formulas

ASK US A QUESTION...
* required field

ASK US