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? Here are the 6 simple steps to using the subtotal function in Microsoft Excel: Highlight the 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? I remember back in the day when Microsoft Excel 2003 and prior versions didn’t have this feature. Then we upgraded to Microsoft Office 2007 and voila!

Insiders

Sign Up for our Newsletter

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

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. In this article I introduce 6 excel add-ins which meet this criterion - NodeXL, Solver, Rainbow, Spreadsheet Converter, Crystal Ball and Fractal Maps. Next my top 3 paid excel add-ins.

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? By The Professional Assistant on Wednesday, July 07, 2010 Filed Under: MS-Excel , Productivity Y our boss calls you over to their office and asks that you send her a list of something that you’ve created in Microsoft Excel. You check your contact list and see that you have about 50 names in your Excel spreadsheet.

2010 122

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?

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 ? Watch out for a future post on sorting tables within Microsoft Word.

2008 100

Bioteams develops unique Social Media Impact Forecasting Simulator

BioTeams

The full version of the tool as well as being unlimited in this respect also provides full reports and charts plus the ability to tailor the tool, run weekly campaigns and import from and export to Microsoft Excel. Social Networking

A Leaders Guide to creating High Performing Teams (HPTs)

BioTeams

1) A team health-check calculator (written in Microsoft Excel ). I am pleased to release a new white paper " A Leaders Guide to creating High Performing Teams (HPTs) ". This 15-page executive guide, aimed at leaders and managers in all sizes and types of organisation, proposes and explains a pragmatic and comprehensive framework for the necessary interventions required to successfully introduce High Performing Teams (HPTs) into organisations.

2015 40

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

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

Stephanie LH Calahan

Archive Network with Steph Is This You? 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. Network with Stephanie or Connect with Your Smart Phone Become a Fan Follow this blog Categories News & Updates! Productive & Organized Home Contribute to P&O!

2010 167

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. Simulate Simulate allows you to import excel models (and also a number of other tools including ithink) and then add a user interface with a drag and drop tool enabling you to add multiple pages with objects such as text, images, sliders and charts before publishing over the web.

2012 53

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.

2011 53

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. At Dashboard Simulations we have developed a simple Excel-based (Excel) tool which guides you through 3 simple steps to estimate the financial benefits resulting from a specific leadership intervention with an individual Leader.

2014 54

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!

2008 100

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

Stephanie LH Calahan

Microsoft's OneNote is my go-to organizing tool for anything that I do online.I         Tiffany Odutoye Talk Social Networking Llc. The initial thought was that we might need to design a server, network our computers together, etc. 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.

2011 203

"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. On a side note, if you need help creating subtotals, check my post on using subtotal functions in Microsoft Excel.

2008 100

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. In this article I will share with you a simple 7-step plan based on a fully worked example of Customer Data Analysis using Excel. For a copy of the worked example excel spreadsheet containing all the formula please email me.

2012 70

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.

Filing 100

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.

2011 58