top of page

READY TO ROLL EXCEL PACKAGES

EXCEL FOR BEGINNERS

  • Introduction to Excel

  • Explanation of Excel working area

  • Navigate in Excel

  • Ribbons & Tabs explained

  • Customizing Ribbons & Tabs

  • Dialogue boxes & panes

  • Active cells

  • How to use keyboard shortcuts

  • Data entry, Editing, Number formatting

  • Using basic formulas

  • Data formatting

  • Working with cell and ranges

  • Managing worksheets

EXCEL INTERMEDIATE

  • Excel data entry tips

  • Adding excel tables

  • Sorting & Filtering table data

  • Autofill, Custom lists & Flash Fill

  • Number formatting

  • More Excel formula

  • Excel formula elements explained

  • Operators in formulas

  • Entering formula

  • Absolute /Relative cell references

  • Copy and pasting formula

  • Introduction pivot tables & slicers

  • Create, formatting, grouping data

  • Pivot charts

READY TO ROLL ADVANCED EXCEL PACKAGES

EXCEL ADVANCED - BRONZE

  • Advanced formula – Stats formula

  • Avg, avgif, count, counta, countif, countblank, large, small, min, max, sum, sumif, sumproduct function

  • Lookup References Formula – VLookup, HLookup,

  • Index match, rows, column function

  • VLookup Vs Index Match

  • Text formulas – right, left, upper, lower, find, replace, substitute function

  • Date and time formulas – networkday, day, hour, date, workday functions

  • Introduction to Excel Charting

  • Quick Analysis Tool (QAT)

  • Freeze panes

EXCEL ADVANCED - SILVER

  • Data sorting and filtering – multi level sorting, data filtering & Advanced filtering

  • Conditional Formatting

  • Advanced Excel Charting – combination charts, secondary axis charts

  • Chart Editing

  • Formatting chart elements

  • Handling gaps in charts

  • Data consolidation

  • What-if-analysis

EXCEL ADVANCED - GOLD

  • Dynamic Charts introduction

  • Multi category charts

  • Gantt chart

  • Actual Vs Target

  • Formula auditing & Debugging

  • Embedding data

  • Advance select

  • Track changes in collaborative documents

  • Text to columns

  • 3D Referencing

  • Forecast sheet

EXCEL ADVANCED – PLATINUM

  • Dynamic Charts – with drop down options

TAILOR MADE OPTIONS

Enabling you the flexibility to pick and choose topics of value to your company/team. We wrap them up in a bundle and deliver your personalized course!

READY TO ROLL MICROSOFT PACKAGES

WORD PROCESSING

  • Introduction to Word

  • Basic computer operations

  • Toolbars and ribbons explained

  • Data entry - keyboard skill development

  • Data formatting - spacing, alignment, page layout

  • Data editing - cut & paste, find & replace, drag & drop

  • Files & folders

  • Saving & printing

POWERPOINT

  • Create presentation

  • Edit presentation - layouts & designs

  • Add images/graphics/charts

  • Delivery - Slideshow presentation settings

  • Audience notes

ACCESS - DATABASE

  • Introduction - Access tables 

  • Access forms

  • Select queries

PUBLISHER

  • Introduction to Publisher

  • Create your own flyers, calendars, greeting cards, certificates, invitations

  • The possibilities are endless & fun!

OUTLOOK

  • Changing email view

  • Adding contacts 

  • Removing attachment from message

  • Flagging options

  • Editing subject line

  • Viewing calendar

  • Create group calendar

  • Creating rules

  • Distribution lists

TAILOR MADE OPTIONS

Enabling you the flexibility to pick and choose topics of value to your company/team. We wrap them up in a bundle and deliver your personalized course!

NOT SEEING WHAT YOU NEED?

We are constantly updating our packages. If you don't see what you need please contact us. We would love to hear from you, simply call or email ....details below. Customization is our thing!

bottom of page