Courses / Microsoft Excel Intermediate
Microsoft Excel Intermediate
- Provider
- Corazon Training
- Summary
- 1 day intermediate course on Microsoft Excel.
About the Course
- Target
- All users of Excel, even those who have used the product for some time.
- Entry requirements
- Delegates should already be familiar with Windows environment. If they are not the course 'Introduction to Microsoft Windows' will provide the necessary knowledge and experience.
- Outcome
- After completing this course delegates will be able undertake more complex tasks within Microsoft Excel.
- Content
- Working with large worksheets
- Navigating Worksheets and Workbooks
- Viewing options
- Page Break Preview
- Hiding and displaying data
- Printing large worksheets
- Freeze and Split Panes
Working with multiple worksheets and workbooks- Inserting Sheets
- Renaming Sheets
- Copying Sheets
- 3D Formulas to Link Sheets
- Consolidating Data
Linking Workbooks
Recap Formulas- Relative and Absolute referencing
- Averages, Minimum and Maximum
- Paste Functions
- Conditional Formulas (IF, AND and OR)
Formatting the Worksheet- Adding Borders and Shading
- AutoFormats
- Copying Formats
- Text Formatting
Working with Dates- Using Special Number Formats
- Indented Lists
- Merge and Centering
Using Styles- Table Auto formats
- Creating and Applying a New Style
List Management- Working with Lists
- Filtering and Sorting
- Advanced Filtering
Productivity Features- Protecting the Worksheet
- Hiding Data
- AutoCorrect
- The Spelling Checker
Working with Charts- Creating Charts
- Changing Chart Elements
- Printing Charts
- Using Graphical Elements
Documenting and Auditing- Comments and Text Boxes
- Auditing features
- Work book and Worksheet Protection
- Navigating Worksheets and Workbooks
- Cost
- Training rates are available on request
- Enrolment
- Website
- www.corazonit.com
Availability
- Starts
- All training is delivered on clients site and can be either one to one or in groups.
- Duration
- Up to 1 day
- Timetable
- By mutual agreement
- Provider
- Corazon Training
Venues/Contact
Main (View map)
146 Woodbridge Road
IPSWICH
Suffolk
IP4 2NS
UNITED KINGDOM
Telephone 01473 219593 m: 07702911223
Fax 01473 219593
Email info@corazonit.com
Website http://www.corazonIT.com
Venue Notes At Client's site:
Contact Elene Marsden
Courses
Syndicate
