Excel Training

I have had several requests lately for Excel training, which is great since it’s my favorite software of all time! So, I thought I’d save some of you some emails and re-cap what I can offer.

Personal Training

  • We’ll meet at a library or coffee shop for a personalized learning experience
  • Two-hour lessons: $40. Half-day (4-hour) workshops: $75.

Group Training

  • 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.

Credentials

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.

 

 

Excel Tip: Zoom to Fit

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!
ExcelZoomToSelection
Prefer a visual? Click for a one-minute how-to.

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!

Excel Tip: Counting Weekdays & Today’s Date

Problem

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!
=TODAY()

The NETWORKDAYS Function

How to find the number of weekdays between two dates:
=NETWORKDAYS(A1,A2)

Example

The formulas will look like this:

Col 1 Col 2 Col 3
Row A =TODAY() 12/21/2012 =NETWORKDAYS(A1,A2)

Your view of the Excel Worksheet will look like this:

Col 1 Col 2 Col 3
Row A 7/18/2011 12/21/2012 185

Other Considerations

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.

Excel: lines breaks within cells

@corrinrenee What’s the magic shortcut for getting multiple lines in a cell in Excel on a Mac?

@loriluza CTRL + ALT/OPTION + SHIFT + ENTER. RT @corrinrenee What’s the magic shortcut for getting multiple lines in a cell in Excel on a Mac?

@corrinrenee DING DING DING! We have a winner. Thank you! RT @LoriLuza: CTRL + ALT/OPTION + SHIFT + ENTER.

@loriluza@corrinrenee You are quite welcome! Excel is my favorite software…of all time!