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!