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?

Microsoft Excel: The Bumblebee's six most useful Excel add-ins

BioTeams

There are a plethora of excel add-Ins out there, many of which aim to improve or extend a feature which excel already performs. I am not much interested in these but what I am interested in is add-ins which enable you to do something really useful which you cannot currently do in excel.

Trending Sources

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?

UPS 2

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.

2008 11

Today’s Admin Needs to Become a Mobile Office Pro

Office Dynamics

Microsoft. Microsoft OneDrive. OneDrive is tightly integrated with newer versions of Microsoft Office. If you want to stay all Microsoft and easily edit Microsoft documents from the cloud, OneDrive might be the one for you. Microsoft Office Mobile Apps.

2016 106

Save Time In Excel By Formatting Multiple Sheets

Simple Productivity Blog

This is a little-known and huge time saver in Microsoft Excel. Using this tip, you can save time in Excel by formatting multiple sheets at the same time. The post Save Time In Excel By Formatting Multiple Sheets appeared first on Simple Productivity Blog.

A free Leadership Development Benefits Estimator Tool

BioTeams

Here is a simple Excel-based tool which will get you started and which you can easily enhance if you need more. That is good news and it is a comprehensive and excellent 80-page report which is well worth studying.

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

Productive & Organized

A Self-Hosted Wordpress Blog. Microsoft's OneNote is my go-to organizing tool for anything that I do online.I Microsoft Excel Spreadsheets & Having Processes In Place. " Stephanie you are such a geek."

2011 106

The River Diagram: Strategic community change management

BioTeams

Next you aggregate the scores of all of the groups to create the River Diagram - this can easily be done in Microsoft excel. I am always on the lookout for good simple visualisation techniques to support change management. Chris Collison has introduced me to The River Diagram - a great strategic tool for moving a community of groups forward via common initiatives and best practice sharing. The River Diagram idea is quite straightforward.

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.

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.

Instant Customer Data Analysis using Excel: worked example

BioTeams

One of the most useful aspects of Microsoft Excel is its ability to quickly slice and dice customer data from live systems to identify important trends and behaviors which can inform strategy. For a copy of the worked example excel spreadsheet containing all the formula please email me.

Bioteams and the beliefs of high performing teams

BioTeams

We conducted two surveys: the first (using Microsoft Excel ) included twenty questions, which allowed us to cover the 10 areas with two questions per area. Team Beliefs are the fuel which can really energise or kill team effectiveness. Unfortunately this is often the most neglected aspect of a high-performing team initiative. In this article I remind people of the key beliefs of high-performing teams. Background and Introduction.

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.

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

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. Home About Me Advertise Who Called? Use A Phone Call Log!

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