MS Excel – Intermediate
Overview
Course Outline
Duration
Delivery Medium
As you are now able to edit, format, and print basic spreadsheets, you now need to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In this course, you will use Microsoft Excel to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.
- Find/Replace
- Using Block Names
- Working With Dates
- Advanced Functions
- Creating a Database
- Sorting Records
- AutoFilter & Custom Filters
- Working with Tables
- Creating an Array Formula
- Linking Files
- Creating a Workspace
- Protecting Blocks/Worksheets
- Freezing Panes
- Splitting the Screen
- Hiding Columns/Blocks
- Multiple Worksheets & Tabs
- Working with Chart Sheets
- Hyperlinks
- Sharing Workbooks
- Tracking Changes
- Adding Cell Comments
- Conditional Formatting
- Formatting Shortcuts
- Custom Formats
1 Day
Face-to-Face Facilitator Lead
Business Administration
It seems we can't find what you're looking for.
Leadership Development
Contact Centre
Sales Performance