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!
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 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
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
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
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
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 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 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 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
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 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 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
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
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
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
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
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
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 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
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
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
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 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 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
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 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
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
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
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
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
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
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
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
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
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
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 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
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
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
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
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
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
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
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
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
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.
So genuine, so real. A teacher to really connect with!
Sara Joy Warne
Extremely good! Even a kid could understand it easily!
The instructions are really clear and simple…Anyone can follow this. It’s awesome!!
It’s helpful, clear, and fun. Thank you!
This course is extremely easy to follow and understand. It’s presented in an informative way that eases you right into the next course.
Its amazing how he explains the slightest detail of the simplest thing.
Wonderful, excellent, very easy to understand and in simple language. Thanks!
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.
MEET THE TEAM
(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.
(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.