Find Courses Find Providers Providers - Promote Your Courses About Us

Excel 2007 Intermediate

Training Courses

Would you like to see more Microsoft Excel courses?

Training course summary

Sponsored links

Who is this training course suitable for? Our Microsoft Excel 2007 Intermediate course is suitable for those with a basic working knowledge of Excel. Prerequisites A working knowledge of Excel or our Excel Introduction course. Benefits This course is designed for those users who wish to step up their current knowledge of Excel to take advantage of the more complex features. To be able to create, edit and format large or multiple spreadsheets. Delegates will also be able to perform calculations and functions within a workbook, manipulate data lists and create custom charts which will enable the user to maintain and present data in a professional environment. Course Syllabus: Working with Large Worksheets Viewing options - Adjusting zoom - Using Freeze Panes - Using Split Window Hiding and displaying data - Hiding rows and columns - Creating an outline Printing large worksheets - Page Break preview - Working with page breaks - Printing multiple sheets Working with Multiple Worksheets and Workbooks Using multiple worksheets - Navigating between sheets - Moving and copying sheets Linking worksheets - Creating 3-D formulas - Consolidating data Linking workbooks - Creating a formula to link workbooks - Using the Paste Link option - Maintaining links Working with dates Entering date functions - TODAY function - NOW function Date and time formats Using dates in formulas Conditional formulas and formatting The IF function Conditional formatting - Based on a cell value - Based on a formula - Identifying cells with conditional formatting - Copying conditional formats List Management Working with lists - Structure of a list Sorting and filtering lists - Simple sorting - Sorting by multiple columns - Using AutoFilter Advanced filtering - Using custom filter - Using Advanced Filter Adding subtotals to a list Documenting and Auditing Comments - Viewing, adding, editing and deleting comments Auditing features - Tracing formula errors Protection - Protecting a worksheet - Protecting cell ranges Using Templates Built-in templates - Accessing and using Excel’s templates Creating and managing templates - Creating, using and modifying a custom template file
Regions:
  • All Areas
Delivery:
  • In House
  • Public
  • Computer Based
Category:
Difficulty:
  • Intermediate

Further Details

1 day instructor-led, courses never cancelled Training formats available: * on a public schedule at one of our London training venues * on-site at your company office UK wide * near-site at a location close to you * bespoke one-to-one basis * tailored training courses to your requirements "What do I get on the day?" * Microsoft certified trainers with industry relevant experience * Modern air conditioned training suite, flat screen PC's, 1 per delegate * Lunch provided in a comfortable and relaxed setting * Comprehensive course material and files to take away * What do I get on the day? - More information What is Microsoft Excel? 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. Spreadsheets are designed to work well with numbers but often include text.

Guide price

75

 

Sponsored links

Interested in this course?

 

 
Information provided is for information purposes only and no guarantees are made with regards to accuracy. It is advised that all details are checked prior to making a booking. Terms of use
Website design by Brit-net