Jed Guinto

Jed Guinto is the Co-Founder of Paperclip Learning. Currently pursuing his Ph.D. in Aerospace Engineering, he is also an avid educator with experience teaching primary students, high school students and undergraduate Aerospace, Civil and Mechanical Engineers. Over 44,000 students from over 170 countries have signed up for his courses.

Courses

Matrix Operations for Engineers and Mathematicians

Matrices are critical tools for Engineers and Mathematicians. They allow us to solve simultaneous equations with many variables in just a few steps. Its also the core of Finite Element modeling and many advance branches of mathematics. 

Instructor:  Jed Guinto
June 4, 2015
English
FREE

Details

Increase your Productivity using Microsoft Excel Shortcut Ribbon

Productivity in Excel is all about getting to the icons and functions you need as quickly as possible. Spending time scrolling through the menus can be a huge waste of time. The Shortcut Ribbon allows you to customize and select your most used icons so that they’re only a click away.

Instructor:  Jed Guinto
May 17, 2016
English
FREE

Details

How to Print Quickly and Effectively in Microsoft Excel

Printing is usually the last step when handling your Excel information. This is the last hurdle! Nothing worse than having it print in the wrong scale, in the wrong colour and on the wrong size paper. I’ll teach you how to make the minor adjustments so you can print perfectly every time!

Instructor:  Jed Guinto
June 7, 2016
English
FREE

Details

Getting Started with Excel for Complete Beginners

Excel is a spreadsheet based software. It is primarily used to handle and process information. There are very few businesses in the modern age that doesn’t make use of Excel at some point. It’s a common language when it comes to data and extremely useful in handling data and eventually sharing it.  

Instructor:  Jed Guinto
June 7, 2016
English
FREE

Details

Introduction to Pivot Tables

The Pivot Table is a POWERFUL and EFFICIENT tool in Excel. It can be used in a number of ways: part of a dashboard, a basic database, a data sorter and so many more. It can group and categorize large sets of data, allowing you see the patterns hidden within. 

Instructor:  Jed Guinto
June 7, 2016
English
FREE

Details

Increase your Productivity using these Microsoft Excel Keyboard Shortcuts

What if you could half or quarter the amount of time you spend handling your information? Well keyboard shortcuts is the way to go! Sign up and I’ll show you exactly what to press!

Instructor:  Jed Guinto
June 8, 2016
English
FREE

Details

Introduction to Microsoft Excel Formulas

The heart and soul of Microsoft Excel, (besides back-end programming developed by genius savants in the basements of Microsoft), is formulas. Formula’s help us to delve deeper into our information in such a simple way that pen and paper can’t do. Excel allows us to manage huge amounts of data and perform calculations on a huge scale! Excel would not be where it is today with formulas!

Instructor:  Jed Guinto
June 8, 2016
English
FREE

Details

Intermediate Microsoft Excel Formulas

So you want to learn even more Excel formulas? Well then this course is perfect for you. In just a few short videos you can add more techniques to repertoire! So sign up now! 

Instructor:  Jed Guinto
June 9, 2016
English
FREE

Details

AutoSum and Count Functions

With the invention of the computer, counting with our fingers has gone out of style. In fact, anyone who counts with their fingers is now considered uncool! In Excel, we have a simple yet powerful formula that counts the number of entries for a given range of data. 

Instructor:  Jed Guinto
August 30, 2016
English
FREE

Details

Microsoft Excel Demonstration for Complete Beginners

So no doubt you’ve heard of Excel which is probably what lead you to this website! Excel is an amazing data processing tool. Its applications are so diverse that you can use it to analyze very complex data to doing your personal finances to finding out which house to figuring out what to eat for dinner!

Instructor:  Jed Guinto
September 13, 2016
English
FREE

Details

Building Your First Microsoft Excel Table

Now to get you on the right track with Excel, one of the first things you will need to master is the proper construction of a table. Tables is one of the main formats in which data is presented and analyzed in Excel. 

Instructor:  Jed Guinto
September 13, 2016
English
FREE

Details

Complete Excel Formulas Course

Welcome to the Complete Formulas Course. Formulas are the life blood of Excel along with tables. The beauty of Excel formulas is that you can apply them on large scale and the effort required to do one calculation is almost the same as extended the formulas thousands of times over! I’d like to see you do that with a piece of paper and a pen! 

Instructor:  Jed Guinto
September 13, 2016
English
FREE

Details

A Complete Guide to Conditional Formatting in Microsoft Excel

I call this function my rainbow tool! Conditional Formatting is a tool that is all too often overlooked. It allows us to colour code different values in a table so that instead of looking at the differences and the patterns numerically, we can look at them through colour instead which is a lot easier to process by the brain!

Instructor:  Jed Guinto
September 13, 2016
English
FREE

Details

Text Editing Functions in Excel

This course is perfect if you have a business partner who is not very good at spelling (Yes I’m talking to you Pawan!). Pawan, my business partner, doesn’t know how to spell and it has landed him in jail several times now. Therefore, to make sure he doesn’t go in a record seventh time, I taught him how to edit text in Excel. 

Instructor:  Jed Guinto
September 13, 2016
English
FREE

Details

Text-To-Column Function in Microsoft Excel

For anyone that deals with large tables, Text-To-Columns is a must. It allows us split different types of data contained in one cell into multiple cells which allows for easier data handling and analysis. 

Instructor:  Jed Guinto
September 13, 2016
English
FREE

Details

AutoSum and Count Functions Revisited!

The AutoSum and Count functions are a cornerstone feature of Microsoft Excel. They’re amazing in that they are the stepping stone for beginners who want to learn about formulas as they automatically create the formulas for you. 

Instructor:  Jed Guinto
September 15, 2016
English
FREE

Details

Opening Excel for the First Time (For Complete Beginners)

Excel is a powerful data processing tool. It has very diverse applications and anyone living in the information age should have at a base knowledge of this program as it is one of the most common tools found in the workplace. 

Instructor:  Jed Guinto
September 15, 2016
English
FREE

Details

Using Sheets in Microsoft Excel

The use of sheets in Excel is like pages in a book. Unfortunately, not enough people know how to utilize it properly and to its full potential. With just a few videos I’ll teach you how to get the most out of sheets. 

Instructor:  Jed Guinto
September 15, 2016
English
FREE

Details

Vlookups and Hlookups

This is possibly my best work to date. I loved this course. Though shorter than my others it contains a lot of content. Lookups are a form of indexing. To explain it briefly, imaging a textbook that you used in high school. In the back there’s almost always an index. But instead of you looking for the word, Excel does it for you!

Instructor:  Jed Guinto
September 19, 2016
English
FREE

Details

Charts and Graphs in Excel

Once you’ve learned how to place your data into table form, its time to represent it graphically. As an engineer myself, graphs and charts are the lifeblood of our work. It allows us to see patterns and trends and no Excel user would be complete with knowing how to use these. 

Instructor:  Jed Guinto
September 19, 2016
English
FREE

Details

Logic Theory and If Functions in Microsoft Excel

One you’ve developed your skills and your data becomes more diverse, you need to start letting Excel do the hard yards for you. In particular through the use of logic functions. Put simply, logic functions will automatically execute the next move for you based on the current result. 

Instructor:  Jed Guinto
September 19, 2016
English
FREE

Details

Image Control

This is an amazing subject! I didn’t really know much about these functions until recently actually but they’ve proven to be very useful as I’m not very artistic at all. The tools you’ll learn here are super easy and are basically one-click functions.

Instructor:  Jed Guinto
September 19, 2016
English
FREE

Details

Workbook Presentation and Printing

Now that you’re familiar creating tables it’s time to learn how to present them properly. As I like to say, it’s nice to be technically proficiency, but if you can’t communicate your data without you being there, then it’s no good. You need to have both!

Instructor:  Jed Guinto
September 19, 2016
English
FREE

Details

Productivity Secrets – Freeze, Pane, Quick Access, Keyboard Shortcuts

Once you’ve grown familiar with how Excel works and using it quite consistently, its time to improve your productivity. Things as simple as a the freeze pane and the quick access toolbar can really revolutionize your work. 

Instructor:  Jed Guinto
September 19, 2016
English
FREE

Details

Accounting Course for Students – Building a Basic Balance Sheet

This is one of many Accounting-based courses we will be designing. We’re starting with building of a basic balance sheet. For any accounting student, business owner or just someone looking to manage there finances, I highly recommend learning how to do this as it could mean the difference between making a profit and going broke!

Instructor:  Jed Guinto
September 19, 2016
English
FREE

Details

Control Huge Data using Filters in Microsoft Excel

Filters are used when you start dealing with large sets of data. It allows us to remove layer by layer of data until we find what we’re looking for. 

Instructor:  Jed Guinto
September 19, 2016
English
FREE

Details

Introduction to Data Visualization

In this course I’ll introduce the concept of Data Visualization and how you can use it to communicate your information much quicker. 

Instructor:  Jed Guinto
May 3, 2017
English
FREE

Details