Using Excel as a Database
Setting data validation.
Sorting data in a list.
Using the AutoFilter and Advanced Filter.
Producing summary statistics.
Introduction to PivotTables.
Database Functions
Using the database functions - e.g DSUM, DMIN, DMAX.
Other Useful Functions
Information functions - e.g. ISBLANK, ISERROR.
OFFSET, INDEX, INDIRECT
Array functions.
Protecting Workbooks
Protecting areas of a worksheet.
Password protection for files.
What-If Analysis Tools
Introducing Goal Seek.
Working with Data Tables.
Introduction to Macros
Recording commands in macros to simplify routines.
Editing macros.
Customising Excel
Changing Microsoft Excel's default settings.
Customising menus and toolbars and assigning macros to new buttons.
Course Overview:
This course is designed for proficient users of Microsoft Excel. Delegates will acquire further advanced skills in order to manipulate Microsoft Word to its full potential.
Course Duration:
1 Day
Course Pre-requisites:
Delegates should have attended the Microsoft Excel Intermediate course or have the equivalent skills and knowledge to that level.At the end of this course
you will be able to:
- Using Excel as a Database.
- Database Functions.
- Other Useful Functions.
- Protecting Workbooks.
- What-If Analysis Tools.
- Brief Introduction to Macros.
- Customising Microsoft Excel.
Price Band:
General
