Many people have asked me about Excel’s sumproduct function. It is one of Excel’s most versatile and useful functions. Here is an introduction video. Continue reading
Date Archives → 2013
Video 00005 Intro_EXCEL-FORMULAS
Microsoft Excel Formula Introduction
If you have never written a formula in Microsoft Excel then this video is for you. No prior knowledge is necessary. Continue reading
Free Excel template: Bucket List template
A bucket list is a list of the things in life that you really want to do. Not so much the daily tasks like take out the garbage or clean out the fridge. Fun stuff like travel to Europe (done!), take tennis lessons or learn to speak Italian. Continue reading
Formulas the easy way!
Can you remember being called to the front of the class to do a math problem?
Free Excel Template: Guest List Planner
MoneySense magazine has a great article about weddings called “A recipe for wedding magic” written by Mark Anderson. One of the most important decisions is to decide on the guest list. Continue reading
Video 00004 Intro_Excel2010_WINDOW
In this video I introduce Excel 2010′s Window. Excel’s window has the following components: Name Box, Formula Bar, Worksheet, Status Bar, Worksheet Tabs, Views, Zoom Level, Scroll Bars. Continue reading
Video 00003 Intro_Excel2010_RIBBON
In this video I introduce Excel 2010’s Ribbon. The Ribbon is a new way to display Excel’s many commands. The Ribbon is found at the top of the screen and consists of various ‘Tabs’. ‘Tabs’ consist of various ‘Groups’ of commands. Continue reading