What is Microsoft Excel training?
Microsoft Excel is a popular computer program that allows you to create and edit spreadsheets. These are used to store information in columns and rows that can then be organised and/or processed
What time shall I arrive at the venue?
Please arrive at the venue for 08:45am
Am I using Microsoft Excel 2003?
Click HELP menu, click ABOUT, find your version.
Am I using Microsoft Excel 2007?
Click Microsoft OFFICE button, click relevant OPTIONS button. Within OPTIONS click RESOURCES to find your version.
Am I using Microsoft Excel 2010?
Click the FILE tab. In BACKSTAGE view, click HELP. Within PRODUCT ACTIVATED, find your version.
What level is best for me within Microsoft Excel?
Level 1 - You can open files, save them, make changes but not a lot more. Level 2 - Fairly confident to perform formulae calculations but able to do most stuff, but not detailed programming. Level 3 - Able to perform all tasks within Excel.
The Knowledge Academy Microsoft Excel 2007 Intermediate 1 day course covers the following topics:
Who Should Attend the course?
Users with a basic understanding of Microsoft Excel 2007 who want to consolidate and expand on their knowledge of the basic features in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction course.
Course Outline
Advanced File Tasks
• Using My Computer within Excel • Saving Your Files • Using Templates
Working with Functions and Formulas
• Using Formulas in Excel • Exploring Excel Functions • Using Functions in Excel • Working with Names and Ranges • Working with Array Formulas • Text Functions: CONCATENATE, LEFT/RIGHT, UPPER/LOWER/PROPER
Managing Tables
• Working with Tables • Working with Records and Fields • Working with Tables and Filters • Using Excel as a Database
Enhancing your Workbook
• Customizing your Workbook • Working with Text Boxes • WordArt • ClipArt • Using Objects
Finalising your Workbook
• Protecting your Workbook • Finishing your Workbook • Using Excel in Word • Using Excel and Access • Using Excel with other Programs and Files
Using Charts
• Working with Charts: Basics • More about Working with Charts
- Highly Experienced Instructor
- Detailed User-Friendly Manual
- Pre/Post Course Email Support
- Refreshments
- Attendance Certificate
There hasn't been any testimonials submitted to this course
