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. B eing able to retrieve the data is more important than an organized alphabetized file drawer.

Filing 100
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
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

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
article thumbnail

Best Business Technology for Small Businesses & Their Owners (28 ideas from them to you!)

Stephanie LH Calahan

          Dr. Shannon Reece Reece International LLC. Microsoft Excel Spreadsheets & Having Processes In Place. Having processes in place is huge and my favorite thing to keep everything together has been MS Excel. Find here: steph.bz/iB5cj3. My Laptop Gives Me Wings! Find here: steph.bz/lkOHaY.