The Microsoft Excel spreadsheet program is part of the Microsoft Office suite of programs and is widely used by business professionals, students, and households. Among other things, a business could use Excel for accounting or maintaining records, a student may be asked to use Excel to analyze a data set or perform a calculation, and individuals can use Excel to maintain his or her personal finances, investment trading activity, or to even calculate a mortgage payment. Since Excel is the predominantly used spreadsheet program, having Excel training is paramount to your success. Nonetheless, learning Excel can take time and can sometimes be frustrating which is why I am creating this website: to teach you how to use Excel.
This website is designed to provide basic Excel and advanced Excel help for formulas, functions and VBA (Visual Basic for applications). You may already be familiar with some of these concepts, but, if you are not, I hope that the information contained in this website will be useful to you. I will be using Excel 2007 in the templates and tutorials, but the principals are generally the same no matter what version you may have.
The website is organized into three sections:
Excel Basics: This section will provide newer Excel users with the necessary information to create and use formulas in Excel, to understand how mathematical and logical operators are used in Excel, and to understanding how to create and use various types of cell references.
Excel Formulas. This section will provide you with the necessary tools to create and use various Excel formulas. This section includes the following formulas: SUM, SUMIF, VLOOKUP, HLOOKUP, INDEX, MATCH, IF, Date Formulas, among others. For each formula, I will try to provide a step-by-step breakdown of the formula into its components, followed by an example with screen shots, and a downloadable excel file with the example included.
Excel Shortcuts, Tips and Tricks: Often people think that using the mouse is the fastest way to navigate Excel; however, in many cases this is not true. On the other hand, mastering Excel’s keyboard shortcuts is a much more efficient way to navigate the program and to complete tasks such as copying and pasting or formatting data. Using the keyboard shortcuts will not only allow you to accomplish the task at hand faster, but you will impress those around you with your speed and skill. Bookmark this page to use as a quick reference sheet!