Microsoft Office
HLOOKUP in Excel
The HLOOKUP function is the not as cool younger sibling of VLOOKUP. Learning how to do a HLOOKUP in Excel is the same as a VLOOKUP, the data is instead looked up horizontally rather than vertically. There is a LOOKUP() but this is only hanging around as it’s compatible with old versions of Excel. The…
Free Microsoft Access Tutorial for Beginners (3.5 Hours Video)
Microsoft Access remains one of the simplest database tools to learn. Better still, Access integrates well with other Office tools like Microsoft Excel. In this Microsoft Access tutorial, we take you through how to get set up in Access and start your database training journey. If you are brand new to databases, then this Microsoft…
Top Ten Excel Functions you HAVE to know.
You only really need to know a handful of the 500 or so Excel functions that exist to accomplish most things in a spreadsheet. The tricky thing is knowing which of those functions are the ones you need to know. In this Excel masterclass, Excel expert Deb Ashby tells us what her top functions are….
Excel Crash Course – Data Cleaning in Excel in 1 Hour
In this Excel crash course on data cleaning in Excel tutorial, MS Office expert Deb Ashby shows you: – Why it’s so important to work with a clean dataset– Some amazing tips and tricks to help you clean data in Excel including TRIM, PROPER and CLEAN– Resizing and formatting data to make it visually attractive–…
Excel Crash Course – Learn Pivot Tables in 1 Hour
In this Excel crash course, pivot table tutorial, excel aficionado Deb Ashby shows you: How to prepare and clean your Excel data for your pivot table How to use recommended PivotTables and create a pivot table from scratch How to format, edit and display different results in a pivot table How to create a chart…
An Introduction to Excel Functions Using Excel 2016
If you are an office administrator, financial analyst, or salesmen, you probably use Microsoft Office Excel. For these, along with many other professions, working with spreadsheet are not only an essential tool, but also a daily routine. If you are an office administrator, financial analyst, or salesmen, you probably use Microsoft Office Excel. For these,…
Using Dates and Times with Microsoft Excel 2016
Microsoft Office Excel’s date and time functions are one of the most common data types that people work with. Unfortunately, they are also the most frustrating. This is especially true if you are still new to Excel. This is because the creators of Excel decided to use a serial number for date representation, instead of…
How to Use the LOOKUP Function with CHOOSE in Excel 2016
As the name implies, the Microsoft Office Excel LOOKUP function is used to look up a specific value located in an index or list and returned the identified value to a particular cell. This can be useful in a variety of problem-solving applications, that require a representation of a specific value or response. Lookup/Reference Purpose…
How to Use the Vertical Lookup Function in Excel 2016
In the previous section we examined Lookup Functions and their use within a horizontal list of values (HLOOKUP). Today we are going to examine a vertical list of values to lookup (VLOOKUP). Their functions are similar in nature, the only difference being a vertical versus a horizontal lookup direction. However, we are also going to…
Understanding Access 2013 Relationships between Tables – Part 1
The most important goal of any database design is to ensure that there is absolutely no data redundancy. The best way to achieve this is by creating relationships between different tables, which have some common fields. Access 2013 offers you an easy way of doing this. All you have to do is select tables, drag…
How to Use Flash Fill With Microsoft Excel 2013
Microsoft Excel 2013 has reinvented the old formula system of previous versions. It used to be that in order to change the information in one column, one had to write a code or formula to teach Excel what was wanted. With flash fill, Excel is able to extrapolate from one cell to the entire block…
How to Create Invoices Using Microsoft Excel 2013
Creating effective, powerful invoices has long been a primary function of Excel. In Excel 2013, it is even easier to move information across tables and even workbooks, saving time and effort. Instead of having to find the customer information from another worksheet and type it in, you can tell Excel to automatically dig this up…
