Absolute References: Excel

Using Absolute References The Fill Handle is Awesome Using the Fill Handle to copy formulas down (or across) a list of data is an incredible time saving feature. However, problems arise when you want to reference a specific cell over and over again. The first formula works great. 10% x $10 results in a $1…

Excel List Management

What is a List? A list is a collection of related data. Examples might include your contact list, an inventory, or your price list. Lists are organized in Rows and Columns, with the first row containing labels. The labels identify the value, or data, directly below the columns. Features of a well designed List include…

Excel: Data Tab

The Excel Data Tab has tools to help you work with the data in your worksheets. There are tools to import data from external sources. Also, tools to sort and filter. As well as tools to separate data into more columns. Sorting and Filtering Sorting and Filtering are relatively simple tools at their face. However,…

Excel Spreadsheets

Local Support with Excel Spreadsheets: The Power of Excel A spreadsheet is little more than columns and rows, comprised of lists and lists. The real power in Excel spreadsheets is when you use Formulas and/or Functions. Formulas and Functions aren’t the same Contact us using the form below or give us a call if you…

Excel Spreadsheets

Local Support with Excel Spreadsheets: The Power of Excel Did you know a spreadsheet is little more than columns and rows, comprised of lists and lists? The real power in Excel spreadsheets is when you use Formulas and/or Functions. Formulas and Functions aren’t the quite the same Formulas and Functions both enable Excel to come…

Enforce Excel Formatting in Mail Merge

Advanced Mail Merge Settings Creating multiple documents with unique recipients, sales totals, or dates is accomplished with Mail Merge. Mail merge takes two files (the main document and the data source) and merges them into one. Basic addition: 1 + 2 = 3   1 Main Document (Start Mail Merge)   + 2 Data Source…

Excel – Order of Operations

Order of Operations When the programmers developed Excel to do math for us, they programmed Excel to always perform the math using very strict order of operations. Excel will always calculate anything in Parenthesis ( ) first. Always. Then it will calculate any Exponents (^). Then, from left to right, Excel will calculate Multiplication (*) and…

Microsoft Excel Training

Microsoft Excel Training Classes When you take My Reno Computer Tutor and Excel training lessons: Our agenda is: The power in using Excel spreadsheets comes with understanding how to use Excel Formulas and Functions.  Contact us today to get going. Excel Classes and Tutoring Excel classes, a key part of the Microsoft 365 are developed…

Mail Merge To Outlook

What is Mail Merge? Mail Merge is the built-in tool available in Word which allows you to create unique, personalized, documents (such as an e-mail, mailing labels, name tags, or letters). Mail Merge to Outlook will include specific information unique to the recipient. Details such as their name, address, contact details, and anything else you…