WELCOME TO PAPERCLIP LEARNING

Microsoft Excel Training for Students, Job Seekers and Professionals

OUR TEACHING PHILOSOPHY

To create training so simple that a 6 year old can understand!

Simple Language

Short Videos

Self-Paced Learning

Mobile Optimized

Students

Positive Reviews

Videos

Years Experience

TRAINING BUNDLES

SHORT COURSES

Text To Column

A very powerful technique to say the least. This function allows you to separate data that has been stored in a single cell, essentially splitting it into multiple parts. For example, you have an Read More

Keyboard Shortcuts

Keyboard shortcuts can greatly increase your efficiency. Instead of searching for the icons you need with the mouse, you can trim off a few seconds using the keyboard shortcut. It doesn’t sound ... Read More

Lookup and Index Functions

This is one of the most powerful techniques you’ll learn Excel. It replaces a lot of manual searching which saves you a lot of time. Lookups work by searching for a value in a table and ... Read More

Dashboard Development for Experts

We’ll learn even more controls you can use to create your dashboard. This includes the use of Radio buttons and tick boxes. This is a great option for others who use your dashboard because they ... Read More

Error Handling

There are cases where formulas will result in an error not because the formula itself is wrong, but simple because the design of the spreadsheet results in errors. For example, you have a 2 lists Read More

Text Editing Functions

This course is perfect data analysts. Inconsistent data or more commonly known as dirty or unstructured data, needs to be cleaned if it’s to go into databases correctly. This involves a certain ... Read More

Pivot Tables for Experts

Pivot tables are a great way to summarize information especially large sets of information. The great thing about them is that they’re dynamic; you can constantly change the layout, you can add ... Read More

Filters for Experts

Filters are one of the most powerful tools in Excel. It allows us to reorganise data alphabetically or numerically, trim down rows based on a single columns values or do it multiple times using ... Read More

Conditional Formatting for Experts

Conditional formatting is great for everyone because it gives us a visual representation of data. Humans are designed and have evolved to recognise colours more than reading numbers so we should ... Read More

Charts and Graphs for Experts

At this level we’ll cover all the other types of charts, and there’s a lot of them!! First we’ll use stacked charts which combine multiple series into a single column giving you more insight into Read More

Data Validation for Experts

Data validation is a great way to ensure that data entered into your spreadsheet is correct and within the limits you set. You don’t want users typing text where numbers should be, writing dates ... Read More

Pivot Tables for Intermediates

Pivot Tables for Intermediates

Pivot Tables have the amazing ability to compress and consolidate huge amounts of data and create a summary of results for you giving you more insight into the data set. Beyond that, you can even Read More

Using the Table Function

Using the Table Function

Standard tables are usually constructed by creating a formula and then copying that formula all the way down to all the rows. Problem with this is that if a single formula were accidentally ... Read More

Filters for Intermediates

Filters for Intermediates

For large data sets with lots of rows and columns, they make sorting, rearranging and organising data a breeze. When filters are applied to a table, little controls appear above on the column ... Read More

SmartArt for Intermediates

SmartArt for Intermediates

It’s a graphical tool that allows you to create beautiful diagrams with text, flow charts, life cycle charts, process maps, hierarchies and more. This course continues on from the beginner ... Read More

Formula Auditing and Error Handling

Formula Auditing and Error Handling

Equations start becoming longer and contain more and more elements. Sometimes, several equations can make up the final solution. The problem comes when there is an error somewhere in the ... Read More

Workbook Protection and Change Tracking

Workbook Protection and Change Tracking

Excel by nature allows anyone and everyone to input data. Unfortunately, not everyone knows how to maintain data integrity. Cells that aren’t meant to be filled out get altered, columns or rows ... Read More

Using the Name Manager

Using the Name Manager

To assist with simplification of values, you can store values or even entire table values into variables you create. From there, you can call upon them from anywhere on your spreadsheet. In ... Read More

Matrix Operations

Matrix Operations

Matrix operations makes solving complex simultaneous equations significantly simpler. As an engineer myself, we used matrix operations to solve complex bridge and truss structures. Excel has ... Read More

Images for Intermediates

Images for Intermediates

When you get lots of images, shapes or objects, handling all of them at once or in groups can be very frustrating if you’re not familiar with the available image handling tools in Excel. This ... Read More

Sparklines

Sparklines

Charts and graphs are great and are one of the elements that make using Excel so amazing. However, there are some cases where I don’t need all the functionality that a chart can offer. Sometimes, Read More

Dashboard Development for Intermediates

Dashboard Development for Intermediates

Instead of redoing the calculation each time, you can build a dashboard which allows you to simply insert your new data and Excel will automatically calculate the new values. It involves a new of Read More

Shapes for Intermediates

Shapes for Intermediates

Shapes are powerful tools in Excel simply because they don’t occupy cells. Instead, they overlap cells giving you another dimension of data presentation which is pleasing to the eye if done ... Read More

IF, AND, OR Functions and Logic Theory

IF, AND, OR Functions and Logic Theory

IF functions allow us to program Excel in such a way that it responds by itself based on the result in a cell. By setting criteria which can either be true or false, we can create a specific ... Read More

Workbook Presentation

Workbook Presentation

Effective presentation of data is an art form but to get started doesn’t take much. In this course I’ll teach you how to elevate your data presentation and layout so that it is easier to read, ... Read More

Charts and Graphs for Intermediates

Charts and Graphs for Intermediates

Charts allow us to visual data especially large samples of data and is an effective way of identifying patterns, trends, peaks, valleys and clusters in your data that may otherwise go unnoticed ... Read More

Conditional Formatting for Intermediates

Conditional Formatting for Intermediates

Our brains are hard-wired to recognize colours and symbols far better than numbers, we’ve evolved that way. Therefore we should use that to our advantage to make reading our data even easier. ... Read More

Shortcut Ribbon

Shortcut Ribbon

When spreadsheets get larger, you’ll need to see as much of the workbook as possible to maximize your productivity especially when working on small laptops. One method is to minimize the main ... Read More

Pivot Table Slicers and Timelines

Pivot Table Slicers and Timelines

Beyond building a basic Pivot Table, there are additional features you can apply called slicers and timelines. Essentially, these are control that allow you to filter your data based on data, ... Read More

Review Functions

Review Functions

Mistakes happen to all of us. We could do a manual search and look for these mistakes but for large documents this will simply take forever. Instead we can use the spelling function which will ... Read More

Grouping and Ungrouping Objects and Shapes

Grouping and Ungrouping Objects and Shapes

The grouping function is a great way to minimize your spreadsheet without losing or having to delete important data. It allows you to temporarily hide rows or columns of data and provides a ... Read More

Data Validation for Intermediates

Data Validation for Intermediates

When documents need to be sent out, shared or filled out, data validation is a must. Unlike programs such as Microsoft Access, you do not set the allowable data types in each cell before you use ... Read More

Formulas – Nested Functions

Formulas – Nested Functions

Depending on the arrangement of data you may choose to have each individual part of the final calculation stored on your workbook or you could combine several formulas into a single cell. Each ... Read More

Printing and PDF

Printing and PDF

One of the most important things to consider when printing is the person who will be reading it. Does it make sense? Is the font big enough to read? Is relevant information all contained on the ... Read More

Inserting a Basic Line Chart

Inserting a Basic Line Chart

Humans are visual creatures. Therefore, we should use Excel in a visual manner at every opportunity. In a table of data, especially large ones, it is difficult to see trends or patterns in data. ... Read More

Data Sorting and Filtering

Data Sorting and Filtering

Tables in Excel can become quite large over time. Eventually, manual searching and reorganisation is inefficient. Luckily Excel has built-in sorting and filtering functions that allow you to ... Read More

SmartArt for Beginners

SmartArt for Beginners

SmartArt is a fantastic way to present information in a graphical way. It allows you to create lists, process maps, life-cycle diagrams, hierarchies, relationship models, matrices and pyramids. ... Read More

Shapes – Text Boxes, Arrows, Squares and More

Shapes – Text Boxes, Arrows, Squares and More

Besides simply using tables all the time, Excel provides a wide range of object shapes you can use to guide the users eyes so that they can focus on specific areas. This gives a whole new dynamic Read More

Images for Beginners

Images for Beginners

A picture speaks a thousand words! Images in Excel are usually underutilized or done very poorly. This is because most people don’t think of Excel as an image processor but think of it instead as Read More

Increase your Organisation using Sheets

Increase your Organisation using Sheets

Sheets are the equivalent of pages in a book. Therefore, sheets should also tell a story of your data. Too many times I see users simply place random assortments of data in multiple sheets ... Read More

Inserting Equations, Symbols, WordArt and Hyperlinks

Inserting Equations, Symbols, WordArt and Hyperlinks

In addition to text and cell formatting, there are additional effects and functionality that you can add which include Equations, WordArt, Symbols and Hyperlinks. For equations, writing them as ... Read More

Formulas – Arithmetic Operations

Formulas – Arithmetic Operations

The power of Excel comes from its ability to carry out complex equations and lay it out in a neat format. It can also do many calculations at once and duplicate ones you’ve already made. Once the Read More

AutoSum and Count Functions

AutoSum and Count Functions

These functions based on the data you select will automatically create the formula and sum up the values so you don’t have to. From here you’ll begin to understand how formulas and functions work Read More

Number Formatting

Number Formatting

When presenting information, you do not want to give any more or any less than the reader needs. Don’t show a number with 10 decimal places when 1 will do. Don’t provide time stamps and year in ... Read More

Text and Cell Formatting

Text and Cell Formatting

Formatting begins as a learnable skill and evolves into an art form. To maximize your effectiveness in communicate data-based information, the formatting and appearance of your spreadsheet is ... Read More

Getting Started with Excel for New Users

Getting Started with Excel for New Users

You’ve probably been told many times how amazing Microsoft Excel is. Only problem for beginners is how or where to get started. This course has been designed to teach the absolute basics and ... Read More

TESTIMONIALS

This program really assisted me with managing my 900 strong client base. Your clear, succinct and explain really well. Looking forward to the next course.

Jon Lee

So genuine, so real. A teacher to really connect with!

Sara Joy Warne

Extremely good! Even a kid could understand it easily!

Natarajan Nadesh

The instructions are really clear and simple…Anyone can follow this. It’s awesome!!

Varsha Inshanally

It’s helpful, clear, and fun. Thank you!

Teodora Ojog

This course is extremely easy to follow and understand. It’s presented in an informative way that eases you right into the next course.

Alice Masemola

Its amazing how he explains the slightest detail of the simplest thing.

Bhagya Kulal

Wonderful, excellent, very easy to understand and in simple language. Thanks!

Vaibhav Mah

Your course is exactly what I needed to be able to jump right in! Congratulations on a clear, concise and engaging course. I can’t wait for your additional lectures.

S.R. Dozier

MEET THE TEAM

Jed Guinto

(CO-FOUNDER) HEAD OF DEVELOPMENT AND TRAINING

Jed Guinto has an Advanced Diploma in Aerospace Engineering, a Bachelor’s Degree in Aerospace Engineering and a Graduate Certificate in Engineering Management. His teaching experience spans across primary school students, high school students, undergraduates and business professionals.

Pawan Lalwani

(CO-FOUNDER) HEAD OF MARKETING AND SALES

Pawan Lalwani has a Masters Degree in Accounting and a Masters Degree in E-Commerce from Deakin University. He specialises in Finance Management and eBusiness strategies. He has extensive experience in management and has managed over 100 client funds valued upwards of $2 million per year.

Artwork by our very dear friend Rebecca Randich!

GOT A QUESTION?

5 + 9 =