Detailed information
| Duration: | 1 Day |
|---|---|
| Price: | £150 |
| Type: | Training |
| Method: | Short courses |
| Accreditation: | NA |
| Prepares for: | This course shows users with some experience of spreadsheets or Microsoft Excel, how to create, modify and navigate around spreadsheets. |
| Geared towards: | Users with some previous spreadsheet experience ideally who have attended our Introduction (Level 1) course. |
| Requirements: | A basic understanding of Microsoft Windows and some spreadsheet experience. |
| Internship: | NA |
| Students per class: | 10 |
Do you need further information?
Contact the person in charge , free and at no obligation, for information on how to enroll, enrollment limit/availability and more.
Course program
1 More about Calculations
• Absolute References
• Using Functions
• Examples of Functions
2 More Features
• Using Comments
• Splitting and Freezing
• Using Zoom
• The Paste Special Command
3 More about Printing
• Adding Headers & Footers
• Setting the Print Area
• Using Print Titles
• Controlling Page Breaks
4 More about Charts
• The Chart Menu
• Revising a Chart
• Further Formatting
• Drag and Plot
5 Working with Multiple Worksheets
• Selecting Multiple Worksheets
• Navigating Multiple Worksheets
• Calculations between Worksheets
6 Data Commands
• Working with Lists
• Sorting Lists
• Filtering a List
• Absolute References
• Using Functions
• Examples of Functions
2 More Features
• Using Comments
• Splitting and Freezing
• Using Zoom
• The Paste Special Command
3 More about Printing
• Adding Headers & Footers
• Setting the Print Area
• Using Print Titles
• Controlling Page Breaks
4 More about Charts
• The Chart Menu
• Revising a Chart
• Further Formatting
• Drag and Plot
5 Working with Multiple Worksheets
• Selecting Multiple Worksheets
• Navigating Multiple Worksheets
• Calculations between Worksheets
6 Data Commands
• Working with Lists
• Sorting Lists
• Filtering a List
Do you need clarification regarding the course program?
Contact the person in charge , free and at no obligation, for information on how to enroll, enrollment limit/availability and more.
Course location
- The Quadrus Centre, Woodstock Way, Boldon, Tyne and Wear, NE35 9PF - NE359PFCity and Borough of Newcastle upon Tyne (England)
- The Quadrus Centre, Woodstock Way, Boldon, Tyne and Wear, NE35 9PF - NE359PFCity and Borough of Sunderland (England)
Base2
Welcome to Base2,
providing learning with real impact.
Our aim is simple. Develop and deliver training that is right for you and your organisation.
We help maximise your investment in staff learning and ensure the results make a measurable difference to your team.
To address your learning needs, we provide three suites of courses and training programs.
IT and Technology
Personal computer application training to give your staff easy access to the power of current PC software
People Development
Build the skills you and your team need to run and grow a highly successful business
Business Communications
Develop sales, customer service and communications skills to make your organisation stand out from the crowd
We’re passionate about learning but recognise that we won’t be the right fit for everyone. Let’s see if it’s worth us speaking any further.
providing learning with real impact.
Our aim is simple. Develop and deliver training that is right for you and your organisation.
We help maximise your investment in staff learning and ensure the results make a measurable difference to your team.
To address your learning needs, we provide three suites of courses and training programs.
IT and Technology
Personal computer application training to give your staff easy access to the power of current PC software
People Development
Build the skills you and your team need to run and grow a highly successful business
Business Communications
Develop sales, customer service and communications skills to make your organisation stand out from the crowd
We’re passionate about learning but recognise that we won’t be the right fit for everyone. Let’s see if it’s worth us speaking any further.





