Excel

Page 1 of 41234

Microsoft Office Notes: May ’16

May 1, 2016 Categorized in: Excel

Keeping minutes; find/replace; formatting

The magic of Excel 3-D references

September 2, 2015 Categorized in: Excel

Q. Is there an easier way to create a formula across work sheets than clicking on each cell you want to add to the formula?
Q. I can’t get FlashFill to work in Excel 2013. What am I doing wrong?

Make the most of MS Office on your iPad

January 28, 2015 Categorized in: ExcelOrganizingWord

The Office app remains a relatively new option for iPad users, but one that can really help you boost productivity when you can’t use your laptop or desktop computer.

Excel Quandaries

December 3, 2014 Categorized in: Excel

Microsoft Office Certified Trainer answers two questions about pound signs and circular cell references.

Creating better Excel spreadsheets

August 15, 2014 Categorized in: Excel

Improve your Microsoft Excel skills and build better spreadsheets with these tips from OfficeTeam.

Working with Pivot Tables

March 25, 2014 Categorized in: Excel

Q. How can I avoid changing the data source each time my source data grows?

It’s all about Excel

November 7, 2013 Categorized in: Excel

How is the new Excel Sumlfs different from SumIf, and how do you dissect a formula to troubleshoot?

Create a color legend in Excel

August 16, 2013 Categorized in: Excel

Q. I’d like to provide a “legend” so people know what the different Conditional Formatting colors mean in Excel. How can I do this?
Q. My tables never look right when I paste them into Power­­Point. How should I paste Excel data into PowerPoint?
Q. How can I return characters to the left of a dash in an Excel cell using the LEFT function?
Q. I have a spreadsheet where three address lines are separated by a line break. How do I use text-to-columns to separate the lines into columns?

New features in Office 2013

December 26, 2012 Categorized in: ExcelInternetPowerPointWord

Microsoft Office 2013 has arrived with some new features that could make your job easier.
Page 1 of 41234