Bespoke Training for Business
Helping your business Excel in I.T.
Give your staff the confidence to perform to the standard your business deserves.
Refresh Employee Knowledge
Develop New Skills
Learn New Features
- Refresh Employee Knowledge
- Develop New Skills
- Learn New Features
Microsoft Training designed to get the most out of your employees
Quality training courses giving your team improved skills in the workplace. Our friendly and informal classes ensure that delegates leave with increased knowledge, skills, and competence. Resulting in your business working effectively and efficiently – saving you time and money, and making your employees more productive. Our training courses can be face to face or online (using Teams or Zoom). We will work with you to ensure you are covering relevant topics at an appropriate level for your staff.
Increase Productivity
Upskill
your Team
Refresh
Knowledge
Ask us a Question
“Sessions delivered by Vue IT are always in demand, our staff feedback survey has shown that they enjoy the session and meet their learning objectives. Staff are more confident in using Excel, MS Teams, Word and PowerPoint.”
Pooja at Maidstone and Tunbridge Wells NHS Trust
Some of the learning modules we offer:
- Creating spreadsheets
- Entering and Editing
- Number formats
- Navigation
- Resizing Columns
- Highlighting & Formatting
- Creating formula
- Formatting and printing
- Create formula
- Totals
- Printing and layout
- Headers and Footers
- Totalling and entering data
- Sum/Min/Max and Average
- Basic Tables
- Absolute cells references
Available face to face and online. Contact us today to get started.
- Working with Multiple Sheets and files
- Formula Revision / Absolute Cells References
- Inserting, Deleting, Moving and Copying Sheets
- Renaming Sheets
- Grouping Sheets
- Creating Linking and 3-D Formulas
- Linking Workbooks
- Creating Charts
- Creating column, line and bar charts
- Creating charts on different sheets
- Formatting Charts
- Printing Charts
- Working with Tables and lists
- Sorting and filtering
- Conditional Formatting
Available face to face and online. Contact us today to get started.
- PowerQuery
- Remove Duplicates
- Text Functions
- Flash Fill
- Data Validation
- Dynamic functions (Excel 365 only)
- If Functions
- Using Vlookup formula
- The new Xlookup (Excel 365 only)
- Creating and Manipulating Pivot Tables
- Sum ifs/count ifs/average ifs
- Macros
Available face to face and online. Contact us today to get started.
- Creating a document
- Entering and editing text
- Saving, closing and opening a document
- Selecting text
- Text and paragraph formats
- Spelling and grammar check
- Bullets and numbering
- Borders and shading
- Cut, copy and paste
- Changing page orientation
- Setting margins
- Printing and previewing the document
Available face to face and online. Contact us today to get started.
- Keyboard and productivity shortcuts
- File Formats and Compatibility
- Paragraph alignments and indents
- Multi-level Bullets and Numbering
- Working with Tables
- Applying and modifying styles
- Working with Headings
- Navigation Pane
- Table of contents
- Section breaks in long documents
- Apply different page formats
- Templates
- Using Fields
- Mail Merge
Available face to face and online. Contact us today to get started.
Learning outcomes will include:
- Working with Slides and Layouts
- Viewing and Navigating with Sections
- Formatting Slides
- Creating and updating charts
- Insert Word Tables
- Creating Smart Art and Organisational Charts
- Using the slides master to add logos
- Headers and Footers
- Inserting pictures and graphics
- Using Video and Sounds
- Finalising the presentation with animation and transition
- Notes, Printing and file formats
Available face to face and online. Contact us today to get started.
Learning outcomes will include:
- Creating Templates
- Slide Masters and master layouts
- Working with graphics and pictures
- Including Movies and Sounds
- Re-use slides from other presentations
- Hyperlinks and Action Buttons
- Exporting the presentation to different formats
- Customising Powerpoint
- Shortcuts
- Productivity Hints and Tips
- Custom Animation
- Creating a video of your slide show
Available face to face and online. Contact us today to get started.
Learning outcomes will include:
- Creating and Addressing Mail
- Spell Checking and formatting
- Sending & receiving mail
- Replying/forwarding
- Out of Office Assistant
- Creating Folders and subfolders
- Viewing the calendar screen
- Creating appointments and setting reminders
- Duplicating appointments & recurring appointments
- Amending/deleting appointments
- Rescheduling/adjusting duration
- Creating an event or a meeting
- Adding a contact
Available face to face and online. Contact us today to get started.
- Tips for managing mail
- Setting Rules for incoming mail
- Conditional formatting of messages
- Working with categories, and flags
- Using different views
- Using Quick Steps
- Sharing Calendars
- Tasks and To Do
- Email Templates
- Creating a distribution list
Available face to face and online. Contact us today to get started.
- What is Sharepoint/One Drive
- Accessing files
- Best practice for using Word/Excel/Powerpoint within Sharepoint
- Autosave and Versions
- Creating and Managing a Team
- Conversations and Files
- Meetings
- Customising teams
- Using Channels
- Using Chat
- Adding Apps to Teams
Available face to face and online. Contact us today to get started.
Microsoft Excel Refresher
Is it a while since you did an Excel course? This course will recap on some of the classics (eg formula and absolute cells!) plus introduce some of the newer Excel features that you will be wonder how you lived without.
Here is the course outline.
Working with Tables
- Creating tables that are dynamic
- Naming, total rows and banded rows
- Flash fill and Ghosting
Power Query
- Filtering and sorting using Powerpoint query
- Extracting data from a list
- Combining Queries
- Total several sheets
New Dynamic Functions
- Xlookup function
- Filter Function
- Unique Function
- Sort & Sortby Function
Speak to us about arranging a course for you and your staff.
Free taster lesson
How Shortcuts can make you more productive
Simply sign up to our mailing list to get your free recording
Why VUE IT Training
You’re in safe hands with one-on-one support from expert trainers who have many years of experience supporting delegates both onsite and online for years – just look at some testimonials we’ve had back for proof!
