Excel Professional
This course includes:
- Format Painter
- Conditional Formatting
- Applying cell validation
- AutoFill
- Count functions
- Lookup functions
- Text functions
- Date functions
- If Statements
- Nested If Statements
- Using the function editor
- Advanced filters
- Pivot Tables and Charts
- Sub Totalling
- Scenarios
- Goal Seek
- Importing data from a website
- Importing data from text files or databases
- Exporting into Access and Word
- Linking an Excel worksheet and a MS Access table
- Introduction to Macros
- How they work and their advantages
- Recording and Running macros
- Recording Relative Macros
- Assigning Macros to toolbars and menu bars
Contact datasort and we will email you a more detailed course outline and answer any queries you may have. All enquiries are welcome without obligation.
|
