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
MS Excel 2007 Lesson Library Print

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

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

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

If you would prefer to follow one of our course outlines, please choose from the following:
Introduction, Intermediate , Advanced or Master Level.

Lesson
 Skill Level  Category 
What is the active Cell? Introduction  Getting Started 
Entering numbers and text Introduction  Getting Started 
Workbooks and Worksheets Introduction Getting Started
Saving files Introduction  Getting Started 
Creating a new workbook Introduction  Getting Started 
Selecting ranges Introduction  Getting Started 
Inserting rows & columns Introduction  Manipulating Rows and Columns
Deleting rows & columns Introduction  Manipulating Rows and Columns
Modifying rows & columns Introduction Manipulating Rows and Columns
Copy, cut and paste  Introduction  Copying, Moving and Deleting 
Clearing cell contents  Introduction Copying, Moving and Deleting 
Editing cell contents  Introduction  Copying, Moving and Deleting 
Undo and Redo  Introduction  Copying, Moving and Deleting 
Fill Handle  Introduction  Copying, Moving and Deleting 
Find and replace  Introduction Copying, Moving and Deleting 
Switching between Worksheets  Introduction  Manipulating Worksheets 
Naming and Renaming Worksheets  Introduction  Manipulating Worksheets 
Inserting and Deleting Worksheets  Introduction  Manipulating Worksheets 
Copying and Moving Worksheets  Introduction  Manipulating Worksheets 
Font size and type Introduction  Formatting
Font formatting Introduction Formatting
Customising Borders Introduction  Formatting
Aligning data in a cell Introduction Formatting
Merge and Centre button Introduction Formatting
Text orientation Introduction  Formatting
Shrink to Fit Introduction Formatting
Text wrapping Introduction  Formatting
Format painter Introduction  Formatting
Formatting numbers Introduction  Formatting
Understanding formulas Introduction Formulas
Creating formulas Introduction  Formulas
Logical Operators Introduction  Formulas
Formula error messages Introduction Formulas
Absolute and Relative referencing Introduction Formulas
Order of calculation Introduction  Formulas
Displaying Gridlines Introduction Printing a Worksheet
Printing titles on every page Introduction Printing a Worksheet
Printing Excel row and column headings Introduction Printing a Worksheet
Spell checking Introduction Printing a Worksheet
Previewing a worksheet Introduction Printing a Worksheet
Comparing workbooks side by side Introduction  Printing a Worksheet
Zooming the view Introduction  Printing a Worksheet
Printing options Introduction Printing a Worksheet
Scaling your worksheet Introduction Printing a Worksheet
Paste Special Techniques  Intermediate  Manipulating Data 
Creating, opening a template  Intermediate  Templates 
Naming cell ranges in a worksheet  Intermediate  Named Ranges 
Using named ranges  Intermediate  Named Ranges 
Managing named ranges  Intermediate  Named Ranges 
Cell Styles  Intermediate  Advanced Formatting Techniques 
Table Styles  Intermediate  Advanced Formatting Techniques  
Conditional Formatting cells  Intermediate  Advanced Formatting Techniques  
Conditional Formatting rules  Intermediate  Advanced Formatting Techniques  
Custom number formats  Intermediate  Advanced Formatting Techniques  
Hiding and un-hiding rows and columns  Intermediate   Advanced Formatting Techniques  
Hiding and un-hiding worksheets  Intermediate    Advanced Formatting Techniques 
Sorting data  Intermediate   Sorting and Filtering Data 
Custom sorts  Intermediate   Sorting and Filtering Data  
Using Filtering  Intermediate   Sorting and Filtering Data  
Advanced Filtering  Intermediate   Sorting and Filtering Data  
Creating a column chart  Intermediate   Charts 
Creating a line chart  Intermediate   Charts  
Creating a bar chart  Intermediate   Charts  
Creating a pie chart  Intermediate   Charts  
Creating an area chart  Intermediate   Charts  
Creating a scatter chart  Intermediate   Charts  
Creating a stock chart  Intermediate   Charts  
Creating a surface chart  Intermediate   Charts  
Creating a doughnut chart   Intermediate    Charts  
Creating a radar chart  Intermediate    Charts  
Creating a bubble chart  Intermediate    Charts  
Chart title - adding, editing and removing  Intermediate    Charts  
What is a function?  Intermediate  Functions 
Sum function  Intermediate  Functions  
Average function  Intermediate  Functions  
Min and max function  Intermediate  Functions  
Count function  Intermediate  Functions  
IF functions  Intermediate  Functions  
Freezing row and column titles  Intermediate  Functions  
Worksheet margins  Intermediate  Functions  
Worksheet page size  Intermediate  Functions  
Headers and Footers  Intermediate  Functions  
Creating subtotals Advanced  Summarising Data 
Removing subtotals Advanced  Summarising Data 
Consolidating data Advanced  Summarising Data 
Today and Now  Advanced  Date Functions 
Year, Month and Today function  Advanced  Date Functions  
Adding days, months or years to a date  Advanced  Date Functions  
Count A  Advanced  Statistical Functions 
Count Blank  Advanced  Statistical Functions  
Count IF  Advanced  Statistical Functions  
Case functions  Advanced  Text Functions 
Left and right functions  Advanced  Text Functions 
Concatenate  Advanced  Text Functions 
Working with dates  Advanced  Working with dates 
Subtracting time  Advanced  Working with dates 
Adding up time  Advanced  Working with dates 
Working out your age  Advanced  Working with dates 
How many days to a future date  Advanced  Working with dates 
Number of week days between two dates  Advanced  Working with dates 
How many minutes have you been alive  Advanced  Working with dates 
Sum IF  Advanced  Mathematical Functions
VLookups  Advanced  Look Up Functions 
HLookups  Advanced  Look Up Functions 
IF Statements  Advanced  Logical Functions 
And, Or, and Not functions Advanced  Logical Functions 
Nested IF Statements  Advanced  Nested Functions 
Password Protection   Advanced  Protecting Files 
Data Tables - One Input Variable Master  One-Input or Two-Input Tables 
Data Tables - Two Input Variable  Master   One-Input or Two-Input Tables  
Creating a Pivot Table Master  Pivot Tables 
Modifying Data and Refreshing the Pivot Table Master  Pivot Tables 
Showing the detail behind the figures Master Pivot Tables
Grouping data in a Pivot Table  Master Pivot Tables
Creating Pivot Charts Master Pivot Tables 
Creating Scenarios Master What IF Analysis 
Creating a Scenario Report Master What IF Analysis  
Goal Seek Master What IF Analysis 
Solver Master What IF Analysis  
Explaining Macros  Master Macros 
Recording Macros Master Macros 
Macro Security Levels  Master Macros  
Macro Control Button  Master Macros  
Tracing Precedent Cells Master Auditing 
Tracing Dependent Cells  Master Auditing  
Displaying all formulas within a worksheet Master Auditing 
Watch Window  Master Auditing  
PMT Function Master Financial Functions 
Present Value Function  Master Financial Functions  
RATE Function  Master Financial Functions  
Future Value Function  Master Financial Functions 
Text to Columns Master Advanced Editing

 

 

 
Back to previous page