article thumbnail

"Excel"ing to Create Subtotal Row Totals

Professional Assistant Blog

On a side note, if you need help creating subtotals, check my post on using subtotal functions in Microsoft Excel. Click the little number 2 shown below to collapse all of the details in between all of the companies. I poked around the internet a bit and came to realize that there is a faster way of doing this. Click Special.

2008 100
article thumbnail

Retrieve Your Files With Ease

Professional Assistant Blog

Then, all files are set up in an excel file with columns for File #, property address, closing date, owner (whatever data important) - then sorts are run and printed so files can be referenced and found by whatever criteria you need. I remember going to a walk-in clinic (doctors office) for an ailment at the time.

Filing 100
article thumbnail

Who Called? Use A Phone Call Log!

Professional Assistant Blog

The way I would do it is that I would create a Microsoft Excel spreadsheet for the month. You can purge the files as needed, depending on your companys situation and/or policy. I used to track calls for one of my past employers, when I used to work at a securities firm as an Investment Advisor Assistant.

Phones 100