Office For Mac

How to train for a marathon Excel style with a Stacked Chart

Happy New Year! Perhaps you made a resolution to run a marathon. I know I did. And I’m going to use Excel to create my training plan. Many of the advanced features in Excel are best explained by example, so I’ll use marathon training to show you some great tricks, like how to use different [...]

Bookmark and Share
8 Comments
— @

Combining Chart Types, Adding a Second Axis in Excel for Mac

(This post was originally written and published by Katherine Fifer, an intern on the Excel 2007 team. We’ve updated it for Excel for Mac 2011.) Many of us need to create charts that compare different types of data. To quickly and clearly display data of different types, it’s helpful to plot varying data sets with [...]

Bookmark and Share
2 Comments
— @

Party planning in Excel

You are an Excel fanatic. You want to use it all the time. At least I do! You know you could be using it in your daily life, but you haven’t come across the perfect opportunity yet, right? Let me show you. I was planning my niece’s birthday the other day. My husband and I [...]

Bookmark and Share
1 Comment
— @

Join us Tuesday for a 15-Minute Webinar on Office for Mac 2011

The Office Content Publishing team hosts free 15 minute Webinars every Tuesday. This week the session showcases how Mac and PC work better together with Office for Mac 2011 and SkyDrive. The session starts at 9:15 am Pacific Time with a Q&A to follow. Click the link below or go to http://aka.ms/offweb for more information on [...]

Bookmark and Share
2 Comments
— @

Excel time-saver keyboard shortcuts

Here are a few time saving keyboard shortcuts to get your week off to a productive start. I’ve also included the equivalents in Excel for Windows in case you have to jump back and forth between platforms like I do. – All Excel for Mac 2011 keyboard shortcuts – Common Office for Mac 2011 keyboard [...]

Bookmark and Share
4 Comments
— @

Find it fast! Pull data from a string

Do you have a list of data that’s in a format you can’t use? Do you need to “pull out” specific pieces of a longer string? Don’t despair! You can use simple Excel functions to break apart strings and quickly find only the data you need. Meet RIGHT, LEFT, and MID! My sister Sandy recently [...]

Bookmark and Share
4 Comments
— @

Planes, Trains, and PivotTables

Thanks to my vacation planning with Word, I made it safely to London. Now, my two concerns are enjoying the sights & my vacation but also staying on budget. Excel PivotTables are a great tool to help me do just that in a snap. During my trip, I record my daily expenses in a list. [...]

Bookmark and Share
— @

No time for finances? Excel template saves the day!

Household budgeting just got easier! Are you a stay-at-home mom or dad, which is a 24/7 job? Well Office for Mac can help keep your life organized with the home budget template created in Excel for Mac 2011. You can set a spending target each month and then use the template to calculate the differences [...]

Bookmark and Share
3 Comments
— @

Need to “Solver” Something – More Math for Excel

Have you ever wondered? • How should I allocate my retirement portfolio among high-tech stocks, value stocks, bonds, cash, and gold? • How can my company determine the monthly product mix at a certain location that maximizes profitability? Now, after the release of Office for Mac Service Pack 1, you can answer these profit-maximizing or [...]

Bookmark and Share
5 Comments
— @

Share files across Office for Mac and Office

Cell formatting, sparklines, and data bars look great in Excel for Mac 2011, and you can easily share files with people who have Office 2010 without losing your formatting. Doug and Jessica show you right here, almost live, from Mom 2.0 in New Orleans. And here is how Jessica uses Excel for Mac 2011 to [...]

Bookmark and Share
2 Comments
— @
Older Posts »