Instructor Led Virtual Courses – Computer Skills and Personal Development
Virtual Instructor Led Training provides a practical and time-efficient approach to upskilling staff. In today’s busy world it is not always feasible to attend a full day of face-to-face training away from the workplace. VILT allows individuals to complete training without leaving their desks in easy to digest modules or tailored sessions delivered by experienced instructors. We deliver training in Excel as well as all Microsoft packages in short 1.5 hour modules.
Most of our Personal Development training courses are also available as condensed virtual workshops.
VILT Course Modules (Closed Course Bookings)
EXCEL COURSES 1.5 hr
VILT – Excel Formatting, Page Setup and Printing 1.5 hr
Learn how to speedily and professionally format a spreadsheet, troubleshoot formatting and manage page setup including headers and footers, repeated print titles and page breaks.
VILT – Excel Formulas for Everyday Calculations 1.5 hr
Learn how to easily produce formulas to perform common calculations including when to use $. Learn how to use built in functions to total, average, find the highest or lowest value in a range, count and much more.
VILT – Excel Working with Databases and Pivot Table Reports 1.5 hr
Learn how to use sort, filter, freeze panes and automatically subtotal lists, analyse large data sets using a pivot table report.
VILT – Excel Logical Functions and Vlookup 1.5 hr
Learn how to use common logic functions such as IF, Count If, Sum If and when and how to use the VLookup function.
VILT – Excel Charts and Data Visualisation 1.5 hr
Learn how to display data graphically using a variety of compelling charts, use conditional formats and sparklines and incorporate into a Word document or a PowerPoint slide.
VILT – Excel Automation with Macros 1.5 hr
Learn how to record a macro to automate a series of repetitive tasks and produce macro buttons which can be assigned to a toolbar, ribbon or shortcut key .
VILT – Excel Linking 1.5 hr
Learn how to link spreadsheets, consolidate data and perform calculations across different sheets and workbooks.
VILT – Excel Bespoke 1.5 hr
Build your own bespoke 1.5 hr workshop, talk to us about choosing topics which work well together.
MICROSOFT 365 COURSES 1.5 hr
VILT – Introduction to MICROSOFT 365 1.5 hrs
Learn your way around MICROSOFT 365 and understand the core services and apps. Learn how to save and access your work in the cloud and work collaboratively. Share files with others and get acquainted with Teams, OneNote and OneDrive.
VILT – OneDrive 1.5 hrs
Learn how to use OneDrive to share files, upload and sync files to the cloud and work on your files from any location.
VILT – OneNote 1.5 hrs
Learn how to use OneNote to create digital notebooks for capturing, organising and sharing information. Create and search your notes in an instant from any device.
VILT – Teams 1.5 hrs
Learn how to use Teams the hub for Office 365 to create chat-based workspaces for information and file sharing and for collaboration on team projects and events.
WORD COURSES 1.5 hr
VILT – Word Setup and Formatting 1.5 hr
Learn how to setup Word so that automatic settings don’t interrupt how you work. Includes setting your default font, margins, autocorrect, bullets and numbers and troubleshooting formatting, indents and tabs when things go wrong.
VILT – Working with Long Documents 1.5 hr
Learn how to work with long documents and apply consistency throughout using styles, table of contents, page and section breaks, headers and footers and more.
VILT – Word Mail Merge 1.5 hr
Learn how to use Word’s Mail Merge function to send out a personalised mailshot using a standard letter, address labels or emails.
VILT – Mastering Tables and Objects 1.5 hr
Learn how to easily create and manage Tables in Word to improve readability and document effectiveness. Use images, drawing objects and SmartArt with ease.
OUTLOOK COURSES 1.5 hr
VILT – Outlook Email Essentials 1.5 hr
Learn how to be more organised with emails by using advanced search features, search folders, flags and categories to tame your Inbox and more.
MICROSOFT PROJECT COURSES 1.5 hr
This course requires 2-3 lessons to complete the Essentials Course. Delegates may opt to leave out resources if not required.
VILT – Part 1 Essentials: Microsoft Project Setup and Gantt Charts 1.5 hr
Learn how to setup Microsoft Project defaults and views correctly and create your first project. Understand how to enter tasks and create dependencies, format and print the Gantt chart view.
VILT – Part 2 Essentials: Microsoft Project Resources 1.5 hr
Learn how to create and assign resources in Microsoft Project and allocate costs, understand how to resolve conflicts and use resource leveling.
VILT – Part 3 Essentials: Microsoft Project Critical Path and Tracking 1.5 hr
Learn how to view the critical path of the project and use different views to present the project. Break the project down into phases using summary task headings or a separate linked subproject. Track the project using a baseline and create a project template to use for future projects.
POWERPOINT COURSES 1.5 hr
VILT – PowerPoint Best Practice 1.5 hr
Aimed at self taught users this 2 hour session will get you up to speed quickly and fill in the skills gap. Learn how to use masters and slide layouts to ensure slides conform to consistent branding guidelines. Use a variety of different slide layouts to produce bullets, images, smart art and charts.
VILT – PowerPoint Effects 1.5 hr
Learn how to apply transition and animation effects to slides.
BESPOKE VILT 1.5 hr
VILT – Tailored Session 1.5 hr
Pick and mix your own subjects to create a customised training session focusing on only what you need. Applies to end user training topics only. Please note this does not include consulting or technical courses such as Visual Basic, SQL or expert level courses. Contact us if you would like to explore further.
Our short courses in the virtual classroom are capped at just 8 attendees ensuring a high level of engagement. No time wasting or filler topics, you’ll learn our most requested content in condensed modules quickly, giving you more time to focus on your day to day tasks.
Save Time and Money
Closed courses can be tailored to your training needs and bring together remotely located personnel without the need for costly travel.
Need More Reasons?
Unlike self paced learning, our live online classes go beyond a lecture style environment and include many options to facilitate an interactive community of involved and engaged learners. All sessions can be recorded and sent to you after your training.