close

About BiteSize and what we can do for you

...all about working smarter, not harder

Register Now!Computer Training and Personal Development - What BiteSize can do for you, ensuring your workforce are fully skilled appropriately to do their job is a powerful asset for any organisation.

BiteSize can help you achieve this quickly and cost effectively. We can help you maximise your IT competence on common every day used desktop applications by using our winning learning formula. This will help you retain your competitive advantage by raising productivity faster than you ever thought possible.

A fast, efficient way of learning using a variety of methods tailored to suit your employees' needs Keeping your skills up to date is crucial. That's what BiteSize will do for you.
Top Panel
About BiteSize...
Top Panel
Microsoft Excel 2003 Lessons Print

excel_icon.jpg"Minutes of learning saving you time forever"

Click on any of the bitesize lessons below and start improving your skills without delay.   The lessons are listed by "skill" level.

Click on your chosen lesson below. To start the lesson, click on the "Introduce Me"    tab and follow the tabs through in sequence.
lessontab_revised.jpg                      

To view a "Glossary of Terms" please Click Here
If you would prefer to follow our suggested course outline, please choose from the following:
Introduction Course, Intermediate Course, Advanced Course

Creating a new workbook  Introduction Getting started 
Understanding Cell References Introduction  Getting started
Saving your workbook Introduction Getting started
Calculating order - BODMAS Introduction Getting started
Identify different parts of Excel Introduction Getting started
Selecting Ranges  Introduction  Getting started 
Moving Around Introduction Getting started
Entering text and numbers Introduction  Getting started 
Inserting Rows  Introduction  Formatting 
Inserting Columns Introduction  Formatting 
Deleting Columns Introduction  Formatting 
Deleting Rows  Introduction  Formatting 
Formatting Cells  Introduction  Formatting 
Changing the row height  Introduction  Formatting 
Changing column widths  Introduction Formatting 
Sorting  Introduction Formatting 
Worksheets - Inserting Introduction  Formatting 
Worksheets - Deleting Introduction  Formatting 
Worksheets - Formatting Across  Introduction  Formatting 
Worksheets - Formatting Numbers  Introduction  Formatting  
Order of Calculation Introduction  Basic Functions 
Quick Add Introduction Basic Functions 
Basic Formulas  Introduction  Basic Functions
Viewing Formulas  Introduction  Basic Functions 
Auto Sum Introduction Basic Functions 
Comments Introduction  Working with data 
GO TO  Introduction  Working with data 
Auto fill Introduction Working with data
Transposing Cells Introduction  Working with data 
Printing a Worksheet  Introduction  Working with data 
Using Page Break Preview Introduction  Working with data 
Clearing and Deleting Cell contents Introduction Working with data 
Forms Intermediate  Timesavers 
Custom Fills Intermediate  Timesavers
Charts - Combination charts Intermediate Charts
Charts - Creating a Bar Chart Intermediate  Charts
Charts - Creating a Column Chart Intermediate  Charts 
Charts - Creating a Pie Chart Intermediate  Charts 
Charts - Displaying values and scaling Intermediate  Charts 
Charts - Gridlines & Legends Intermediate  Charts 
Charts - Line Charts Intermediate  Charts 
Charts - Scatter Charts Intermediate  Charts 
Charts - Trend lines Intermediate Charts
Auditing data Intermediate Data manipulation
Validating data Intermediate Data manipulation
Hiding Rows and Columns Intermediate  Data manipulation 
Hiding Worksheets Intermediate Data manipulation
Protecting Cells Intermediate Data manipulation
Protecting Worksheets Intermediate Data manipulation
Protecting a Workbook  Intermediate  Data Manipulation 
Conditional formatting Intermediate Data manipulation
Pivot tables Intermediate Data manipulation
Auto Filtering Intermediate Data manipulation
Absolute references Intermediate Data manipulation
Function - Count A Intermediate Functions
Function - IF Intermediate Functions
Function - Nested IF Intermediate  Functions 
Function - Statistical - SUMIF Intermediate Functions
Function - Statistical - Count IF Intermediate Functions
Function - Text - Concatenation  Intermediate  Functions 
Functions - Wizard Intermediate Functions
Sub totals Intermediate Functions
Links - Updating Intermediate Linking
Linking Data to other applications  Intermediate  Linking 
Embedding Data Intermediate  Timesavers 
Workspaces Intermediate Timesavers
Advanced Auto filtering Intermediate Timesavers
Splitting a worksheet Intermediate Timesavers
Creating Styles Intermediate Timesavers
Consolidating data Intermediate Timesavers
Creating Templates Intermediate Timesavers
Naming ranges Intermediate Timesavers
Worksheets - Performing Calculations Across Intermediate  Working with multiple worksheets 
Worksheets - working across Intermediate Working with multiple worksheets
Worksheets - naming and renaming Intermediate Working with multiple worksheets
Function - Adding up time Advanced Functions
Function - Future Value Advanced  Functions 
Function - PMT  Advanced  Functions 
Function - Left Function  Advanced Text Functions 
Function - Case Advanced  Text Functions 
Function - Count Advanced  Statistical Functions 
Function - If with AND  Advanced Logical Functions
Function - NOT Advanced  Logical Functions
Function - True and False Advanced  Logical Functions 
Recording Macros Advanced Macros
Horizontal Lookups Advanced  Lookups 
Vertical Lookups Advanced  Lookups
Custom Sort Order Advanced  Advanced Features 
Text to Columns Advanced  Advanced Features 
Watch Window Advanced  Advanced Features 
Performing calculations with dates Advanced Working with Dates 
Subtracting Time Advanced  Working with Dates 
Subtracting one year from another  Advanced  Working with Dates 
Work Out Your Age  Advanced  Working with Dates
Work out how many days to a future date  Advanced  Working with Dates 
Number of week days between 2 dates  Advanced  Working with Dates 
Add days, weeks, months or years to a date Advanced  Working with Dates 
How Many Days Have You Been Alive Advanced  Working with Dates  
Goal Seek Advanced  Analytical Options 
Scenarios  Advanced  Analytical Options 
Solver Advanced  Analytical Options
Data Tables (one input) Advanced  Analytical Options
Data Tables (two input) Advanced Analytical Options 

 

 
Back to previous page