Using Subtotals Function in Microsoft Excel

Professional Assistant Blog

Home About Me Advertise Using Subtotals Function in Microsoft Excel By The Professional Assistant on Wednesday, January 30, 2008 Filed Under: MS-Excel , Productivity D o you have a Microsoft Excel spreadsheet where you have firm names and figures?

Increasing Microsoft Excel 2007's Formula Bar Size

Professional Assistant Blog

Home About Me Advertise Increasing Microsoft Excel 2007s Formula Bar Size By The Professional Assistant on Wednesday, November 18, 2009 Filed Under: MS-Excel , Productivity D o you find that trying to either write or fix formulas in Microsoft Excel can be a pain?

Retrieve Your Files With Ease

Professional Assistant Blog

Home About Me Advertise Retrieve Your Files With Ease By The Professional Assistant on Wednesday, November 05, 2008 Filed Under: MS-Access , MS-Excel , Organize , Productivity D o you have quite a bit of filing to do? Do you feel that you should have some sort of control over these files on how you find them, for future reference? One of my readers asks: I am trying to organize a file room based not on traditional alphabetical filing, but on a retrieval system.

Filing 100

Need to Change Excel Details from Vertical to Horizontal or Vice.

Professional Assistant Blog

Home About Me Advertise Need to Change Excel Details from Vertical to Horizontal or Vice Versa? You check your contact list and see that you have about 50 names in your Excel spreadsheet. You can also find more Microsoft Excel tips and tricks here.

2010 158

Copying Tables, Pictures or Text in PDF Files to Other Sources

Professional Assistant Blog

Home About Me Advertise Copying Tables, Pictures or Text in PDF Files to Other Sources By The Professional Assistant on Thursday, January 17, 2008 Filed Under: MS-Excel , MS-PowerPoint , MS-Word , Productivity D id your boss just ask you to copy a table, picture or text to another source of software, such as Microsoft Excel or Word ? If you want to copy text from a PDF file into another source, click on the following icon shown below.

2008 100

Sorting Tables in Microsoft Word

Professional Assistant Blog

Home About Me Advertise Sorting Tables in Microsoft Word By The Professional Assistant on Wednesday, January 23, 2008 Filed Under: MS-Word , Productivity H ave you ever wondered or tried to sort a table within Microsoft Word ? Do you already have a table set up in Microsoft Word, but dont want to copy to Microsoft Excel and back again, just to sort it? Retrieve Your Files with Ease Is You Boss Not Giving You Enough Work?

Opening Microsoft Office 2007 Files in Microsoft Office XP

Professional Assistant Blog

Home About Me Advertise Opening Microsoft Office 2007 Files in Microsoft Office XP By The Professional Assistant on Wednesday, January 09, 2008 Filed Under: Client Service , MS-Access , MS-Excel , MS-Outlook , MS-PowerPoint , MS-Word , Productivity I recently had a vendor send us an Excel spreadsheet that he created in Microsoft Word 2007 format. Unfortunately, our firm still only has Microsoft Office XP and was curious as to how this would work.

2007 100

40 Excel hacks for assistants

Practically Perfect PA

If I had to make a list of all of my favourite office technology and software Microsoft Excel would most certainly be missing from the top ten (urm… it probably wouldn’t make the top 100). I do hold a grudge against Excel I must say.

2015 236

Today’s Admin Needs to Become a Mobile Office Pro

Office Dynamics

Microsoft. Apps for file access, e-mail, calendar, password protection, word processing, spreadsheets, presentations, virtual meetings, news, weather and travel are examples of key productivity tools mobile devices should have installed. Backup and store your files via a cloud service.

2016 195

Productivity Multiplier: Google Cloud Connect Now a Reality

Productivity Bits

But if you’re like me, you are far more comfortable using Microsoft Office products. Google Cloud Connect lets you work right out of Microsoft Office software and still get all the benefits of Google Docs and a cloud-based office productivity suite.

Google 241

Boost Productivity by Picking the Best To-do List for You

Productive & Organized

The following are options for to-do list formats and tips for using them most effectively:     * Excel lists. Keeping a list in Microsoft Excel is great for coordinators whose priorities can change from hour to hour.

2010 213

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

Productive & Organized

OneNote: My Filing Cabinet In The Clouds. Microsoft's OneNote is my go-to organizing tool for anything that I do online.I create notebooks and files just like I would with paper, but now it is all organized on my computer. Paper Tiger Filing System Keeps Me Organized!

2011 261

Convert excel spreadsheets into online simulations and dashboards

BioTeams

There are two neat tools you can use to quickly turn excel spreadsheets into online simulations, what-if models and dashboards. Here is a useful little video tutorial which takes you through the entire process in overview for a simple excel model.

2012 69

"Excel"ing to Create Subtotal Row Totals

Professional Assistant Blog

Home About Me Advertise "Excel"ing to Create Subtotal Row Totals By The Professional Assistant on Wednesday, September 03, 2008 Filed Under: MS-Excel , Organize , Productivity Y our manager sends you an e-mail with a spreadsheet attached.

2008 130

Who Called? Use A Phone Call Log!

Professional Assistant Blog

By The Professional Assistant on Thursday, October 09, 2008 Filed Under: MS-Excel , Organize , Productivity D o you find that when you receive phone calls or voice mail messages, you cant remember who called, what time they called, who they were trying to call, etc? The way I would do it is that I would create a Microsoft Excel spreadsheet for the month. Also, remember to archive these files, just in case you need to go back and check who called when for what reason.

2008 100