Phone +234.811-111-1296 or visit www.charlesandgoldconsulting.com

Empower yourself to expand your role and opportunities. Achieve real and quantifiable returns by building a high level of interpersonal, planning and problem solving skills.

INTRODUCTION/BEGINNERS EXCEL TRAINING COURSE

Duration: 3 Days

Lagos Venue

106 Apapa Road beside
Zenith Bank Lagos.

Fee: N75, 000. VAT Incl.

4 - 5 participants: 5% discount
More than 6 ppl: 10% discount

Class Session

9:00am – 4:00pm daily.
(In plant training available upon request)
WEEKEND CLASSES May Sat 7 & 14, Sun 8 July Sat 2 & 9, Sun 3 Sept Sat 3 & 10, Sun 4
WEEKDAY CLASSES March Tue 1 - Thur 3 June Wed 1 - Fri 3 Oct. Wed 5 - 7


Share this course

Twitter Feeds

Course Overview:

This course is designed for new or basic Excel users. The course will cover all aspects of creating new spreadsheets, including Excel calculations, printing, formatting and basic list management.

Course Duration

This is 3 - days Excel Intermediate Course. Course starts at 09:00 and runs until 17:00.

Course Locations/Schedule

This course can be run Onsite, or at our Excel training centre or any preferred location in Nigeria. The course is run on a date that suits you! The outline below is for Excel 2007. All older and newer versions, are also available.

Introduction/Beginners Training Course Contents.

1. Excel Basics

  • An overview of the screen, navigation and basic spreadsheet concepts
  • Understand Excel terminology workbooks, worksheets, rows, columns, cells
  • Various selection techniques
  • Understanding the various mouse cursors
  • Working with Ribbon Tabs, Groups and Dialog Boxes
  • Standard and Contextual ribbons
  • Use the task pane
  • Understand and use the File Tab
  • Saving, File types, File compatibility (earlier versions)
  • Useful keyboard commands
  • Quick Access toolbar & Mini toolbar
  • Get Help!

2. Entering Data

  • Various ways to Enter, Edit and Delete information (Text, Numbers, Dates)
  • Use Auto List feature
  • Date and Time are storage in Excel
  • Enter Dates and Times
  • Date/time formatting
  • Methods to Move and Copy data
  • Use the Fill Handle to copy data and create simple lists
  • Create series of information
  • Insert, Delete and Hiding Rows & Columns
  • Insert, Delete and Move Cells
  • Insert, Delete, Move and Copy Sheets
  • Various navigation techniques

3. Creating & Editing Formulae & Functions

  • Define Formulae
  • Create & Edit Formulae
  • BODMAS : Mathematical Order
  • Copy & Move Formulae
  • Use Basic Functions - Sum, Average, Max, Min, Count, Counta
  • Use Autosum tool
  • Introduction to the Function Library
  • Reference a cell in other sheets
  • Understand Relative Referencing
  • Apply Absolute (Fixed) Referencing

4. Formatting and Proofing

  • Formatting of Cells with Number formats, Font formats, Alignment, Borders, Fill colours and Patterns
  • Quick formats and themes
  • Sheet tab formatting and Renaming
  • Copy and Clear Formats
  • Merging cells
  • Spell Check, Find & Replace and AutoCorrect

5. Printing and Page Setup

  • Page Orientation
  • Page Orientation
  • Print a selection
  • Set a print area
  • Clear a print area
  • Shrink to Fit
  • Adjust page breaks within Page Break Preview
  • Repeat columns and rows
  • Print Gridlines
  • Save print settings

6. Multiple File & Large Workbook Tools

  • Split screen tool
  • Freeze panes
  • Arrange workbook windows
  • Zooming tools
  • GoTo tool

Our Training Courses