Advanced IT Solutions for Connoisseurs (5 videos)

Compare Excel Lists with the VLOOKUP Function | Video

 This is video 5/5 in our series “Advanced IT Skills Refreshers for Connoisseurs” Compare Excel lists with the VLOOKUP function. This is an advanced feature made easy. Avoid manual work – let the computer do the legwork!

Read the full article →

65 Look up data in an Excel database with VLookup

 This is video 4/5 in our series “Advanced IT Skills Refreshers for Connoisseurs” Look up information in an Excel List, with the VLOOKUP Function. Useful for calculating salaries, making invoices, searching employee details, and much more! This video tutorial may be viewed by Premium Members only. If you wish to watch it, please click here […]

Read the full article →

59 Help your Word readers navigate with an automatic Table of Contents

 This is video 3/5 in our series “Advanced IT Skills Refreshers for Connoisseurs” We show you how to create a TABLE OF CONTENTS with a few mouse clicks. This video tutorial may be viewed by Premium Members only. If you wish to watch it, please click here to find out more about becoming a Premium […]

Read the full article →

56 When ideas are better than cut & paste in PowerPoint

 This is video 2/5 in our series “Advanced IT Skills Refreshers for Connoisseurs” Spend more time thinking great things and less time cutting & pasting! In this video we show you a smart way to enter and move text in POWERPOINT. This video tutorial may be viewed by Premium Members only. If you wish to watch […]

Read the full article →

Excel Charts | Compare two sets of data with a Secondary Axis

This is video 1/5 in our series “Advanced IT Skills Refreshers for Connoisseurs” We show you how to compare different types of data in the same EXCEL chart, by adding a SECONDARY AXIS

Read the full article →