Flash Fill
Work smarter not harder using Flash fill to automate processes
Searching Posts
When you’re looking for computer training related to your needs, use the search opiton on the title bar (top to the right) to search for posts you’ll find helpful. (It’s the magnifying glass, which some people say looks like a lollypop). Click that and search for the topic which interests you. Try searches like these:…
Now on YouTube
We’ve started a YouTube channel! The idea is to post quick (5 minutes) videos for how to accomplish quick tasks. Right now it’s organized into four playlists. Expect periodic modifications and reorganization, as the whole YouTube thing is new and we’re just figuring it out. Playlists: The Windows playlist will feature topics relevant to windows…
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…
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…
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…