Microsoft Excel Intermediate (Level 2) 2003 2007 2010
Sponsored links
INTERMEDIATE MICROSOFT EXCEL – from Base2
– 1 day
After the course, delegates will be able to navigate an excel spreadsheet, create/manipulate simple formulae and create charts
A basic understanding of MS Windows is recommended.
Attendance of our Introduction to Microsoft Excel is recommended.
| Delivery: |
|
| Regions: |
|
| Category: |
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
