Have your IT gal set up your conference room, and I’ll come train your staff.
While rates vary based on size and needs, ten staff members for a half day generally runs about $300.
I have several years experience training adults in the classroom setting and in one-on-one private tutorials. I’m also the go-to gal among all my friends for many of their software questions and editing tasks.
Email me today for a free email consultation to see if I’m a good fit to your learning needs.
Are your eyes tired from all the lines of numbers? Are you scrolling too much? Excel can zoom to fit your window.
Highlight the section you are reviewing.
Get the pulldown for the zoom, and choose Selection.
Ta Da! A perfect fit!
What if the area is so big that you can’t scroll with the mouse without losing control? Then, use the keyboard to select.
Click in the last cell in the bottom right corner that you want in your selection. I even go one column and one row past my last cell to give little right-hand and bottom margins to the work.
Cmd-Shift Up Arrow and Cmd-Shift Left Arrow. (Ctrl-Shift, if using a PC.)
Repeat, if necessary. Depending on your data layout, one Up or Left may not be enough to get to Row 1 or Column A. If you have a lot of blank rows/columns in your layout, you could just hold the Cmd-Shift Up/Left Arrow until Row 1/Column A is highlighted.
Everything from your last cell to Cell A1 is now selected.
Without clicking in the worksheet (which would de-select your selection), click the pulldown for the zoom, and choose Selection.
Bookmark this tip, you’re going to wonder where you read it when you get ready for income taxes!
You are setting a deadline or goal and need to know the number of weekdays between any two dates. If you have a 12-month calendar handy, you could count the weeks and multiply by five. But, when you try this on the computer, the calendar scrolls smoothly, making it hard to know if you counted that week or not. Or, maybe this is a long term project and you’d like to set the goal off in the distant future. If so, counting weeks by hand and multiplying by five would be tedious.
The TODAY Function
Excel has a function for figuring today’s date. And, because it will change each time you open the document, you can guarantee that it will always reflect “today”, whatever today is!
The NETWORKDAYS Function
How to find the number of weekdays between two dates:
The formulas will look like this:
Your view of the Excel Worksheet will look like this:
Of course, this does not factor in holidays or vacation time, so if you are using this to set a goal for work, be sure to pad the deadline accordingly. This is just one tool to help you along the way. It might give you the motivation you need to pick up the pace or the satisfaction of knowing that you are on track toward the goal, but it can not be the only tool for goal-setting.