Category 'Excel'

8
May

Excel List Management

Excel, Microsoft Office | Comments Off on 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 […]

26
Apr

Formulas vs Functions

Excel, Microsoft Office | Comments Off on Formulas vs Functions

How They Differ The words Formula and Function are often used interchangeably, but they don’t mean the same thing. At the very core level, they are similar. However, it may help you understand them better if we break them down and view them as different from one another. Formulas Think of Formulas as mathematical calculations […]

26
Mar

Excel: Data Tab

Excel, Microsoft Office | Comments Off on 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, […]

21
Mar

Pages From the Book

Excel, Microsoft Office, Uncategorized | Comments Off on Pages From the Book

When I teach groups, I generally create custom handouts for those in attendance. I’m in the process of developing two handouts for a new client right now. As a result, the training they get will be relevant to their organization. These images are in the Excel Essentials book that I put together for UNR Extended […]

3
Jan

Excel Spreadsheets

Excel, Microsoft Office, PivotTables | Comments Off on 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 […]

19
Nov

Enforce Excel Formatting in Mail Merge

Excel, Word | Comments Off on 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 (Select Recipients) […]

28
Oct

Excel – Order of Operations

Excel | Comments Off on 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 […]

14
Oct

Mouse Pointers Matter

Excel, Microsoft Office | Comments Off on Mouse Pointers Matter

Very different things happen depending on which mouse pointer is displaying in Excel, so it’s helpful to be aware of what the most frequently seen pointers are. Review the table below and contact My Reno Computer Tutor for your personalized explanation.   Select: Click and drag in any direction to select (highlight) a range of cells […]

30
Sep

Office 2013 Start Up Options

Excel, Microsoft Office, Word | Comments Off on Office 2013 Start Up Options

Word, PowerPoint and Excel 2013 all open with the Start Screen rather than a blank new file. You can change this setting if you would prefer to have the particular program open directly into a blank new file. To disable the ‘start’ screen: Click the File Tab and select Options On the General Screen of […]

1
Jul

Relative vs Absolute Cell References

Excel, Microsoft Office | Comments Off on Relative vs Absolute Cell References

Cell references When creating formulas, we use cell references rather than actual values to show Excel which cells to use in the calculation. By referencing which cell to use in a formula. when the value of the cell changes, the result of the formula updates automatically. By default a cell reference is relative, which allows […]