Personal Computer Teacher Looking for Microsoft Office Training, or just need some basic computer training classes? My Reno Computer Tutor can provide the in-personal computer teacher you need. How is personal training effective? First, because you know the skills you would like to learn, that’s what we’ll teach you. Second, because you are familiar with…
XLOOKUP is a newer function that surpasses the awesomeness of VLOOKUP, but it’s only available in the Office 365 (Excel 2019) versions (and newer as they’re developed). There is still great value in VLOOKUP (and HLOOKUP as well), it just takes nesting more functions. Read the XLOOKUP post to learn more about it. Manually eyeball…
Using Excel Names When using formulas or referring to a specific cell in your worksheet, you’ll typically reference ‘range’ or specific cell. For example, B6:B10 is a range reference, where B6 is a cell reference. A problem with this sort of reference is that it’s not very meaningful and easy to forget. If you want…
What are Quick Parts? Quick Parts, simply stated, are re-usable Word elements. The elements include formatted text, enabling the user to quickly create professional documents. Since Office 2007, Word includes dozens of built-in Quick Parts. Including headers, footers, cover pages, tables, bulleted and numbered lists, Tables of Contents, and AutoText. Create Your Own Creating your…
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…
Different Companies = Different Needs Our client companies have many different needs. Is productivity important to your company? What do you need to improve? Industries such as manufacturing, non-profits, and real estate, all use Excel spreadsheets. Many of the companies listed below have been helped with using VLOOKUP and XLOOKUP functions as well as PivotTables. Law…
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…
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…
Benefits of using Word 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. What is a Style? Styles are collections of font and paragraph format attributes that change how copy in…
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…