Category 'Excel'

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 […]

1
Mar

Grouping Dates in PivotTables

Excel, Microsoft Office, PivotTables | Comments Off on Grouping Dates in PivotTables

 I have a client that is tracking sales. We have over 100 individual records, and the data source is going to grow through out the year. With multiple sales each day, we’ll want to be able to sum total sales at each week. PivotTables are the obvious answer. We need to group by calendar week, […]