Microsoft Excel – Databases, filter/sort, named ranges
This Excel course looks at the program options, automatic calculation, error checking rules, customising the ribbon and quick access toolbar. You also learn about the format of databases: delimiters, headers, records, fields, flat file vs relational data, filtering and sorting data and different data formats like Comma Separated Values (CSV), TXT, Tab separated values and how to open data in different programs.
Naming Ranges and using Named Ranges in formulas enables you to turn complicated formulas into something user friendly that other Excel users will understand. Data validation and drop down lists and mastering find and replace.
Included Topics
MICROSOFT EXCEL OPTIONS
- AUTOMATIC CALCULATION, AUTOCOMPLETE, ERROR CHECKING RULES
- CUSTOMISING RIBBONS & QUICK ACCESS TOOLBAR
DATABASES
- HOW ARE RECORDS STORED
- DELIMITERS
- THE EXCEL STRUCTURE
- HEADER ROW
- ENTERING THE INFORMATION
- FLAT FILE DATABASE
- RELATIONAL DATABASE
USING FORMS
FINDING INFORMATION
LABELS AND NAMES
- THINGS TO KNOW
- THE NAMING MANAGER
- NAMING CONSTANTS
DATA FILES
OPEN DATA FILES IN EXCEL
SORTING AND FILTERING
- SORTING
- FILTERING
- DATABASE STORAGE FORMATS
ADVANCED FILTER
DATA VALIDATION, DROP DOWN LISTS AND NAMED RANGES
COMBINE THE CONTENTS OF CELLS
- FIND AND REPLACE
KEYBOARD SHORTCUTS
- SELECTING WORKSHEET AREAS
- EDITING DATA
Back to Microsoft Excel Training Courses outline Enrol now
