Microsoft Excel 2007 Training Course Intermediate Cambridge
In this course, you will use Microsoft Office Excel to streamline and enhance your spreadsheets with templates, charts and graphics. You will use advanced formulas to display data in various formats, giving your documents a more professional look.
Microsoft Excel 2007 Training Course (Intermediate) Outline - Cambridge
Enhancing Workbooks
- Customize the Excel Environment
- Customize an Excel Worksheet
- Enhance Worksheets Using Themes
- Work with Comments
- Access External Resources Using Hyperlinks
- Use Web-Based Research Tools
Creating Workbooks Using Templates
- Create a Workbook from a Template
- Create a Custom Template
Organizing Data Using Tables
- Create Tables
- Modify Tables
- Format Tables
Presenting Data Using Charts
- Create a Chart
- Modify Charts
- Format Charts
- Create a Chart Template
- Share Excel Charts
Analyzing Data Using PivotTables and PivotCharts
- Create a PivotTable
- Perform Calculations Using PivotTables
- Analyze Data Using PivotCharts
Enhancing Visual Appeal Using Graphic Objects
- Insert Graphics
- Modify Graphic Objects
- Emphasize an Area of a Worksheet
- Illustrate Workflow Using SmartArt Graphics
- Format Graphic Objects
- Change the Order of Layered Graphic Objects
- Group Graphic Objects
- Organize Graphic Objects
Calculating Data with Advanced Formulas
- Refer to a Range of Cells
- Calculate Data Across Worksheets
- Perform Date and Time Calculations
- Format Text Using Formulas
- Perform Numeric Calculations
- Calculate Data with Lookup & Reference Functions
- Perform Logical Analysis
- Print Formulas
Sorting and Filtering Data
- Sort Data in a Spreadsheet
- Filter Data in a Spreadsheet
- Calculate Large Volumes of Data
- Add Subtotals to a Worksheet
Course Duration: 1 Day
Other courses you may be interested in:
Advanced Microsoft Excel 2007 Training Course
Or if you need to get back to basics
Beginners Microsoft Excel 2007 Training Course
Cambridge1010 Cambourne Business Park Cambourne is situated within a new business park close to the City of Cambridge. The Centre is within easy reach of the M11 and A1, as well as the public transport network, offering convenient access for your Intermediate Microsoft Excel 2007 Training Course Alternatively if you live in and around Cambridge and wish to have your training on-site the we can provide all the equipment, included laptops & projector, required. All we ask is that you provide a little space for the trainer to set up. |
To see more details as to our Training Venues click one of the links below: Cambridge | Birmingham | Milton Keynes | Norwich | Peterborough Luton | Ipswich | Brentwood | Northampton | Leicester |