Description
It’s frustrating when our IT software skills hold us back. Simple tasks take longer and documents don’t deliver the best usability, functionality or presentation and we risk inaccuracies in our data and information. It’s a triple whammy on our productivity.
This package overcomes this by providing a large range of constantly updated mini lessons that can be viewed whenever the learner needs help.
Each lesson contains a video with an average run time of 4 mins and the lesson file can be referred back to or even re-taken.
Content
Excel
- Charts
- Collaborating
- Conditional Formatting
- Date Functions
- Diagrams and Drawing
- Formatting Core
- Links
- Managing Rows and Columns
- Lookups
- Macros
- Maths
- Names and Auditing
- Opening and Saving Files
- Pivot Tables
- Pre-set Formatting
- Printing
- Protecting and Validating Data
- Rounding Functions
- Shortcuts
- Sorting and Filtering Lists
- Subtotals
- Viewing options
- What if
- Working with IF
- Working with text and cleaning data
- Array Functions
- VBA
PowerPivot
- Configuring Data
- Creating Outputs
- Getting Started
- Importing
Word
- Document Control
- drawing and Pictures
- Formatting
- Forms
- Header and footer
- Hyperlinks
- Mail Merge
- Sections and Breaks
- Tables
Project
- Creating a project
- Enhancing your project
- Finalising your project
- Updating projects
- Printing and Reporting
- Working with resources
Here is more information about how it works.