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.
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.
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!
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.
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.
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!
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!
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.
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!
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!
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!
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.
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.
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!
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.
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.
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!
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.
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!
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.