Webinar Microsoft Excel for Project Management

Office Dynamics

Microsoft Excel for Project Management. Learn how Microsoft® Excel® can be your secret to project management. When you think about it, Excel is great at the two things you absolutely need to create a project management tool: date math and maintaining lists. Open Excel and search for the word Project in online templates and you will find dozens of templates that can help you tame your project planning and tracking tasks. View this online.

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.


Sign Up for our Newsletter

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

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!

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


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.

Virtual Assistant Business - What the heck is this?

Professional Assistant Blog

Microsoft Word Meetings Productivity Job Seeking Microsoft Access Microsoft Outlook Research Prioritize Microsoft PowerPoint Microsoft Excel Travel Customer ServiceImage by cogdogblog. U nfortunately, I got let go from my job due to restructuring and am looking for work now. This was the bad news.

2011 116

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?

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. More great content can be found on the site at Simple Productivity Blog., or you can find me on Twitter ( @SmplProdBlog ) and Facebook ( Facebook.com/SimpleProductivity ). Productivity

2015 168

Free High Performing Teams Instant Healthcheck Tool


An important free tool which I provide with my new book ' A Systematic Guide to High Performing Teams ' is a Team Process Health Check Spreadsheet written in Microsoft Excel. The spreadsheet allows you to rapidly assess each of 16 important team process elements on a scale of 0-3 ranging from 'totally absent' to 'present and effective'. Team Leadership Development

5 Awesome Tools To Help You Newbie Geeks With Your Open Source Project

Dumb Little Man

If you prefer an interactive place for your milestones or features (which you probably entered in spreadsheet apps like Microsoft Excel and ZK Spreadsheet), tutorial or guide, or even a public forum, list them all out here. Every new year welcomes new resolutions. We probably all want the same thing — to achieve more and feel proud of what we have achieved. For example, Mark Zuckerberg’s is to visit and meet someone in every U.S.

2017 166

Excel Pivot Tables WEBINAR

Office Dynamics

One of the most powerful features in Excel! Excel Pivot Tables: Getting Your Data to Talk. When Microsoft ® Excel ® users hear the term "pivot tables", they usually run for the hills, believing that skill set is out of reach. While this presentation will be shown from Excel 2007, all information will be applicable to Excel 2010 as well. Join us April 11 for the newest webinar in our Office Technology Series, Excel Pivot Tables: Getting Your Data to Talk.

2012 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. Mostly because of all the time spent on Excel doing expenses for Executive’s that had that habit of chucking months and month’s of receipts at me with no idea where they came from or what they were for.

2015 182

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

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’s paid version is OneDrive for Business, which contains more features for collaboration. A free Google app which includes a suite of productivity tools similar to Microsoft Office. Microsoft Office Mobile Apps.

2016 147

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. Here are my favorite reasons for making the switchless switch to Google Cloud Connect: Keep Your Favorite Microsoft Office Tools. The Google Cloud Connect toolbar in Microsoft Word after installation.

Google 185

The Most Important Trait To Boost Your Productivity


Back in 2011, I took the time to learn new techniques in Microsoft Excel through a course. tasks completed in seconds rather than minutes) in using Excel, a workhorse tool in the corporate world. A specific drug may yield excellent benefits with a 1 gram dose while a higher dose could have terrible side effects. Making sense of that data is much easier if you use a tool like Microsoft Excel. A few years ago, I took the Super Excel course in Toronto.

2015 82

A Leaders Guide to creating High Performing Teams (HPTs)


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

Bioteams develops unique Social Media Impact Forecasting Simulator


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.

Thyroid Disorders

Administrative Arts

Using Sort in Microsoft Excel. Thyroid disorders are conditions that affect the thyroid gland, a butterfly-shaped gland in the front of the neck. The thyroid has important roles to regulate numerous metabolic processes throughout the body. Different types of thyroid disorders affect either its structure or function. The thyroid gland is located below the Adam’s apple wrapped around the trachea (windpipe).

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. Productive & Organized Home Contribute to P&O! Archive Network with Steph Is This You? Work With Stephanie « Your Priorities - Take the Quiz and See How You Do | Main | If You Want to be Productive, Dont Focus on the Rock!

2010 164

Convert excel spreadsheets into online simulations and dashboards


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

To Connect With Customers, Invest in Yourself First

Small Business CEO

However, one program that all small business owners should be familiar with is Microsoft Excel. Excel can be a real time saver for you and will allow you to focus your attention on the things that really drive entrepreneurs. Once you’ve mastered Excel, it’s worth considering the new project to embark on. Freelancers and consultants are becoming much more the norm by the year for a variety of reasons.

2013 65

The River Diagram: Strategic community change management


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


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

"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

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

Productive & Organized

Microsoft's OneNote is my go-to organizing tool for anything that I do online.I 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. " Stephanie you are such a geek." " That is what I heard from her as we were talking on the phone.    OK!    I'll own that. 

2011 201

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

Instant Customer Data Analysis using Excel: worked example


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

Bioteams and the beliefs of high performing teams


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