WELCOME TO PAPERCLIP LEARNING

Microsoft Excel Training for Professionals

100% Stacked Area Graph to Measure Portions Over Time
100% Stacked Area Graph to Measure Portions Over Time I just started using this chart because I needed to measure how performance in my data changed against each month. This is much better than doing a standard area chart because you can actually compare each colour directly as it's all in percentages. Check out the differences below. STANDARD STACKED AREA ...
Read More
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 in Excel and this will build your confidence so that you can use the more advance formulas later on. In this course I’ll teach the 5 ...
Read More
Basic Financial Planner
Everyone should know how to manage their finances. The great thing is, you don't need an overly complicated system to track your spending. Even a system that approximates your spending and earning behaviour is enough. Because essentially, all you want to see is if your savings are going up or going down. This spreadsheet will allow you to input a value ...
Read More
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 if viewed in table form. Excel has a number of charts to choose from and when further customized gives you an infinite number of way of presenting the ...
Read More
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. Conditional formatting allows us to highlight values based on the value inside the cell. For a given range of data, you can highlight all the number 7’s that ...
Read More
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 thinking in terms of data layout and data flow. So in this course I’ll show you how to set up a dashboard where each part of ...
Read More
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 reorganise based off certain parameters such as date or letter and even filter if a particular field matches a criteria you set. In order to elevate yourself to the next level of ...
Read More
Excel for Beginners
Microsoft Excel is a very powerful tool. It's been used the world over for decades and for good reason. It is the oldest, most well-known and most affordable data processing software available. It works primarily using data organised into tables. From there you can perform calculations on the table thereby extending it further with new information you create and this ...
Read More
Excel for Entrepreneurs
Microsoft Excel is a very powerful tool. It's been used the world over for decades and for good reason. It is the oldest, most well-known and most affordable data processing software available. It works primarily using data organised into tables. From there you can perform calculations on the table thereby extending it further with new information you create and this ...
Read More
Excel for Entrepreneurs (COMING SOON!!)
Excel for Entrepreneurs (COMING SOON!!) 32.1% of small businesses fail due to poor management of financial activities (http://www.ronaldcoleman.ca) Businesses fail for a lot of reasons but ultimately because of one reason: the business is no longer financially viable. (https://www.ewhsba.com) Money-in, money-out and cash-flow. As an entrepreneur you'll hear these terms a lot especially if you're up for a round of ...
Read More
Excel for Experts
We'll begin with data validation. This technique helps control the data that goes into a cell and limits what users can place inside. This is great for creating forms that others will use as well as creating dashboards with controls on them. Next we'll cover charts and graphs and expand more on customization, styling and more importantly all the available ...
Read More
Excel for Intermediates
In the intermediate level course we'll be expanding into new territory. We begin by enhancing your knowledge of formulas by learning about nested functions. These are formulas within formulas which will allow you to perform more complex calculations in less space thus simplifying your spreadsheets. We'll then be covering data validation which limits the data type in cells, object grouping ...
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 multiple columns, we can use colours to sort, set limits by values and even manually set unique values and handle blanks. That’s just the start. Years ...
Read More
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 connections between cells are established, any updates to the raw information used for your formulas will automatically update your final result. This will ...
Read More
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 has its own advantages and disadvantages. Having each calculation stored results in larger spreadsheets potentially spread across different sheets making tracking difficult. Conversely, combining all formulas into ...
Read More
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 assumes you know nothing about the program. It also assumes you have minimal experience with computers and so I will take it really slow ...
Read More
Holiday Planner
Planning your holiday takes a lot of work and there's nothing more annoying than than flying and forgetting which gate to go to, or which flight number your flight is. I've experienced this myself and I've always had to create my own summarized version of all my flight details. However, I always had to do this manually and so I ...
Read More
How do I Show the Developer Main Tab?
How do I Show the Developer Main Tab? When you're first beginning to write macro coding or using objects such as radio buttons, drop downs and so on, it's helpful to have the developer tab (otherwise, you can't do any of it). Here's how to access it. Please comment below if you found this helpful or if you have any ...
Read More
I Can't Find The Pivot Table Tools
I Can't Find The Pivot Table Tools I've done this before. I'm trying to work with Pivot Tables or the Table function and I can't find the design options. Remember, to edit the features in a Pivot Table, be sure to activate by selecting any of the data points inside as shown below. If you don't select data, the tabs ...
Read More
Image, Shape and SmartArt Collection
Microsoft Excel is a very powerful tool. It's been used the world over for decades and for good reason. It is the oldest, most well-known and most affordable data processing software available. It works primarily using data organised into tables. From there you can perform calculations on the table thereby extending it further with new information you create and this ...
Read More
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 purely a data processor. What they forget is that images are data!! Images can enhance the effect of your data as well as establish the ...
Read More
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. Data analysis in particular is all about seeing events such as spikes, valleys and correlations in the data. By using charts we can visualize this very ...
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 like much at first, but if you add it up over you Excel life, it’s a lot of time. The shortcuts I’ve compiled here by no means covers ...
Read More
Meal Randomizer
When it comes to meal time, my girlfriend and I can never pick a meal. Either we're too tired from work or we just don't feel like eating anything. You've probably experienced this yourself. But then all of a sudden, someone (and by someone I mean my girlfriend) goes "Pizza!!!!" All of a sudden I feel like eating pizza. I ...
Read More
Microsoft Office eBook - Shortcuts and Productivity Secrets
We've compiled a list of tips and shortcuts across the Microsoft Office package. We've covered some of our favourite keyboard shortcuts and techniques and we've laid it out as visually as possible. We don't like you fumbling around trying to figure out where buttons are. We hope you enjoy this eBook! Let us know what you think in the comment ...
Read More
My Top 3 Keyboard Shortcuts
My Top 3 Keyboard Shortcuts Keyboard shortcuts make a significant difference in User Excel Performance. It allows you to work much faster and gain access to specific functions immediately. Below are my top 3 keyboard shortcuts. QUICK ACCESS TOOLBAR: Alt+1,2,3,4,5,......etc,etc This allows you to quickly access the quick access Toolbar. The great part about this is that you can customise ...
Read More
Oh Excel, why did you crash?
Oh Excel, why did you crash? This has probably happened to you. You're working on a file, you're making headway then all of a sudden Excel goes "I don't feel like working anymore. I'm going to close the program and lose all your work." Sometimes the auto recovery can help but it's not a sure thing. So instead relying on ...
Read More
Pivot Table Trick - Finding the difference to a specific entry
Here's a cool Pivot Table trick I found out a little while ago. When data is organised into a table, it's sometimes hard to put values into perspective. Questions such as, how high is one value from another? One thing you can do is select a value as a reference value. All other values are subtracted by this value to ...
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 new fields, you can update the date source, you can create formulas on the fly and so much more. In this course we’ll learn the more advanced parts ...
Read More
Resume Sample 1
Resume Sample 1 MORE DOWNLOADS ...
Read More
Resume Sample 2
Resume Sample 2 MORE DOWNLOADS ...
Read More
Resume Sample 3
Resume Sample 3 MORE DOWNLOADS ...
Read More
Resume Sample 4
Resume Sample 4 MORE DOWNLOADS ...
Read More
Resume Sample 5
Resume Sample 5 MORE DOWNLOADS ...
Read More
Resume Sample 6
Resume Sample 6 MORE DOWNLOADS ...
Read More
Resume Sample 7
Resume Sample 7 MORE DOWNLOADS ...
Read More
Resume Sample 8
Resume Sample 8 MORE DOWNLOADS ...
Read More
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 correctly. There are many customization you can apply to a single shape including rotation angle, bevels for 3D effects, shadows and reflections, textures and fills, alignments and more. In ...
Read More
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 SmartArt course. In this course we’ll be focusing a lot on shape and text formatting. We’ll cover the pre-set formatting options as well as further customization such as reflections, glows, ...
Read More
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 absolutely critical for readability. There is nothing more frustrating than meticulously analysed data that cannot be read. So in this course, you’ll learn how to change the cell and text colour as ...
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 amount of data cleansing. The techniques you’ll learn here are great because they allow you to automate in sense the clean up procedure compared to doing it manually ...
Read More
That's a pretty LARGE function you got there!
That's a pretty LARGE function you got there! The LARGE function allows you to extract the highest value in a range of numbers, as well as the second highest, the third highest, fourth highest.......and so on, and so forth, infinitim (I think that's a word!). As you can see from the image above, we have a range of numbers. I ...
Read More
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 addition, because these values are stored, changing them in the name manager will automatically update all results. In this course I’ll teach you how to store variables, store ...
Read More