Excel – Order of Operations

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

21
Oct

Keyboard Shortcuts

Mac, Microsoft Office, Windows | Comments Off on Keyboard Shortcuts

Windows and Mac have keyboard shortcuts, negating the3 need to take your hands from the keyboard to use the mouse to preform many actions. Below is a list very common keyboard shortcuts. Windows computers use the [CTRL] key, Mac computers use the [CMD] key. Keyboard combination Does This [ESC] The escape key, cancels whatever it […]

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

7
Oct

Save vs Save As

Mac, Microsoft Office, Windows | Comments Off on Save vs Save As

What is the difference between Save and Save As? Have you experienced the frustration of editing a document, knowing you’ve saved it, and then the next time you open the file, it no longer contains the edits you’ve made? Chances are this is because when you saved it, you used the “Save As” command and […]

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

7
Jul

Using Styles

Microsoft Office, Word | Comments Off on Using Styles

Benefits of using styles include: Quickly apply consistent formatting to areas of a document. Allows you to make changes easily to everything that already has a certain style applied. Simplify the creation of Tables of Contents. Styles are collections of font and paragraph format attributes that change how copy in your Word document appears. There […]

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

10
Apr

Devil in the details

join.me, Word | Comments Off on Devil in the details

Remote Tutoring The client I’m working with is in Texas and has an impressive grasp of how to use Word without any help. He’s been working on this book for 18 years, you can well imagine he should know what he’s doing with Word, and he does. The process of editing the book created in […]

7
Apr

How to Use Join.Me

join.me | Comments Off on How to Use Join.Me

Join.me allows you to share your computer screen with My Reno Computer Tutor from anywhere you may be. you can be off at a conference in another state. If you’re having a problem, give us a call (Contact information below) and we can arrange a time to take a look at your screen. It’s really […]

1
Apr

TOC / TOA

Microsoft Office, Word | Comments Off on TOC / TOA

Table of Contents (TOC) and Tables of Authority (TOA) Last week I mentioned that I had taught a “lab” class for county employees. (Remember the Dr. Seuss dream?!). The big take away that was served in that class was to three people who work in the DA office. They type up legal pleadings all the […]