Excel Courses

 

Excelcourses

Excel Introduction

 

Excel spread sheets are the most popular because it’s so versatile. It’s not only used to crunch numbers but great for creating lists, getting statistical information, generate reports using dashboards, cross check data though the use of functions and formulas.

 

This slideshow requires JavaScript.

 Pre requisite

Print friendly course outline

Duration:1 Day (8:30 am – 3:30 pm)

Objective: To gain an understanding of the potential of Excel. Be able to create basic formulas apply formatting and print successfully.

Essential: Have Mouse Skills, an awareness of keys on keyboard e.g.: Shift, space bar, and Enter key.

Learning Outcomes: By the end of the day you will be able to have an understanding of what Excel is capable of. Create your own spread sheets, apply formatting, perform basic Formulas/Functions and print.

Topics

Module 1 Getting Started: Opening an Existing Spreadsheet Using Templates Understand Compatibility Mode Getting to Know the Environment Saving.

Module 2 Navigating:  Cell Pointers Navigation Techniques Selection Techniques Freezing Panes Splitting Zoom.

Module 3 Editing: Worksheets Entering Data Editing Data Undo & Re Do Deleting Data Deleting Columns & Rows Inserting Columns & rows Change Column Width.

Module 4 Automated Features:  AutoComplete Auto Fill Module 5 Formulas & Functions Basic Formulas Basic Functions:- Sum, Average, Max, Min, Count, Counta Using the Function Wizard Relative Cell Referencing Basic Absolute Cell referencing.

Module 6 Formatting:  Cells Font Formatting Conditional Formatting Formatting $ % Decimals Using Clear Format Using Clear all Using Format Painter Merge Cells, Text Wrap Apply Borders Cut, Copy, Paste Paste Special :- Keep source column width.

Module 7 Printing:  Work in Page Break Preview Insert page breaks Set headers to repeat Understand Page Setup settings Print – Selection.

Customized courses:

We also specialize in customizing courses to suite you, pick the topics that are relevant for your work environment.

Related Topics

Excel Pivot Tables Course

Return to the Workforce Courses

Shortcut Keys

How to separate text to columns

 

Save

Save

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s