Updated: 26/09/16 : 13:12:11
Printable Version   Bookmark and Share Share This

business

Microsoft Excel Advanced

Microsoft Excel Advanced

Date:   29 Sep 2016
Time:   09:30 - 17:30
Location: Compupac IT Solutions, St. Vincent’s Business Centre, Finisklin, Sligo.
Price:   See below 

This useful one day course will cover the following modules:

 

Essentials and Shortcuts
- An overview/recap of some essential Intermediate topics
- Run through of shortcuts

Named Ranges
- Creating a named range
- Redefining a named range
- Users for named ranges

Text Manipulation
- Upper / Lower / Proper Functions
- Text to columns
- Concatenation
- Trim
- Right / Left / Mid Function

Database Features
- Sorting Records
- Using AutoFilter
- Removing duplicates
- Subtotalling lists
- Database Functions – DSUM / DAVERAGE / DMAX / DMIN / DCOUNT

Working with Pivot Tables
- Pivot Table Concepts
- Setting Up the Pivot Table Layout
- Refreshing Pivot Table Data
- Using Pivot Table AutoFormat
- Filtering PivotTable Data
- Creating Calculated Fields
- Grouping Dates and Values

 

 More on Functions
- Using the COUNT Functions
- Using LOOKUP Functions (Vlookup & Hlookup)
- Using the IF Function
- Using IS Functions
- Using the SUMIF Function
- Creating Formulae with Nested Functions
- PMT Function

What IF Analysis
- Using Goal Seek
- Scenario Manager

Auditing
- Using the Auditing Toolbar
- Tracing Precedents & Dependents

Macros
- Recording & Running Macros
- Assigning a Macro to the quick access toolbar

Content, Worksheet & Workbook protection
- Data validation
- Protecting Worksheets
- Protecting Workbook Access
- Assigning Password Protection
- Removing a Password
- Preventing Changes to a Workbook

 

Price

Member   €100

Non-Member €130