Excel Training

Overview and Intro

At the end of this training course, participants would have a firm understanding of the course and they should be able to manipulate, analyze, and visualize data using excel. With our instructor led training, participants should be able to use the software package as an expert after training.

+ FREE Refreshment: Tea, Coffee, Cakes, Snacks and light Lunch.
+ FREE Access to Video clips
+ FREE Access to Online Material Course Content
Video Preview Download PDF Download PDF Download PDF Price: N30,000

Schedule and Venue

Week-Ends: 4 days – 2 days (Sat/Sun) from 10.00am – 5.00pm
Week-Days: 8 days – 2 weeks (Mon, Tue) from 11.00am – 5.00pm 
Online Tutoring: 2 days – 2 weeks (Mon, Tue, Wed & Thurs) 2 hours Anytime.
Training Type: Classroom Instructor –led Training

Lagos Venue: 3, Faramobi Ajike Street, Off Bush Street, Anthony Village, Lagos
PortHarCourt Venue: 6, Erabor Close, PortHarcourt. Rivers
Abuja Venue: 8 River Trent Street, Off Thames Street, Maitama, Abuja
Refreshment: Tea, Coffee, Cakes, Snacks and light Lunch

Start & End Date:
Week-Day Calendar and Week-End Calendar

Course Outline

Day 1

Chapter 1: Office Workspace Basics
• Basic Window Elements
• Exploring Microsoft Office Backstage
• Working with the Ribbon
• Customizing the Quick Access Toolbar 
• Working with KeyTips
• Using the Status Bar
• Getting Help

Chapter 2: Introduction to Excel
• What is Excel? 
• Getting to Know the Excel Window
• Moving the Cell Selector 
• Opening a Workbook
• Navigating a Workbook
• Selecting Cells
• Creating Workbooks
• Saving a Workbook
• Closing a Workbook

Chapter 3: Entering and Editing Data
• Entering Text, Numbers, and Data
• Editing Data
• Using AutoComplete and AutoFill
• Copying Data
• Moving and Clearing Data
• Using Undo and Redo
• Entering Text, Numbers, and Data
• Finding and Replacing Data

Chapter 4: Introduction to Formulas and Functions
• What are Formulas and Functions?
• Entering Formulas
• Entering Functions
• Using the Insert Function Tool
• Using AutoSum
• Copying and Moving Formulas

Day 2

Chapter 5: Working with Functions
• Using Statistical Functions 
• Using Financial Functions 
• Testing Conditions with IF
• Using Date and Time Functions
• Using Linked Values in Formulas
• Copying Formula Values
• Controlling Automatic Calculations
• Describe SNMP v2 and v3

Chapter 6: Formatting Data
• Introduction to Formatting
• Applying Number Formats
• Applying Font Formats
• Changing Cell Alignment
• Applying Cell Styles
• Copying Formats
• Clearing Formats
• Finding and Replacing Formats

Chapter 7: Formatting Worksheets
• Inserting and Deleting Rows and Columns
• Inserting and Deleting Cells
• Adjusting Column and Row Sizes
• Hiding Worksheet Components
• Inserting and Deleting Worksheets
• Copying and Moving Worksheets
• Customizing Sheet Tabs
• Adding a Worksheet Background

Chapter 8: Managing Workbooks
• Arranging Multiple Workbooks
• Adding Hyperlinks 
• Working with Comments
• Saving Workbooks in Different Formats
• Saving a Workbook as a Web Pages 
• Creating Folders 
• E-Mailing a Workbook  

Video Preview Download PDF Download PDF Download PDF Price: N30,000

Enroll and Register Now:

First/Last Name *

Invalid Input
Email Address *

Invalid Input
Phone Number *

Invalid Input

Course *

Invalid Input
Location *

Invalid Input
Payment *

Invalid Input
GT Bank
YOU ARE HERE: ICT Training Excel Training