Excel 2013 incudes template charts and pivot tables which are provided by the Recommended Charts and Recommended Pivot Table features. The available options are provided intelligently based on the selected data. Click into or select the data to be pivoted. On the Insert tab, select Recommended Pivot Tables. The dialog box then previews pivot tables … Continue reading Recommended Charts and Pivot Tables
Category: Microsoft Office
Using Flash Fill in Excel 2013
Flash Fill is a new feature in Excel 2013, which automates tasks such as reformatting dates and other information as well as separating or combining columns of information. Reformatting Data In the above example column A contains unformatted dates, Flash Fill can be used to format them. In the next column, first cell (i.e. next … Continue reading Using Flash Fill in Excel 2013
Visualising Data with Improved Conditional Formatting
Conditional Formatting in Excel 2013 has been improved to let you quickly visualise and comprehend data. You're going to find more styles, icons and data bars as well as the ability to highlight specified items like minimum and maximum values in just a few clicks. First of all highlight the data you want to apply … Continue reading Visualising Data with Improved Conditional Formatting
Getting Started with Office 365 – User Guide
What is Office365? Office 365 is a subscription-based online office and software plus services suite which offers access to various services and software built around the Microsoft Office platform. It is "an always-up-to-date cloud service", due to its rolling updates and incorporates Exchange Server (for e-mail), SharePoint (for internal social networking, collaboration, and a public … Continue reading Getting Started with Office 365 – User Guide
Planning in Project 2013 – The Important Steps
Creating a Plan Set project start date and default calendar Open the Project Information dialog and choose the required settings. Select Project tab – Project Information. NOTE: DO NOT SET THE STATUS DATE. Do this only when you update the plan from information from timesheets. Enter project custom field information (Project Server Only) To fill … Continue reading Planning in Project 2013 – The Important Steps
Addicted to Devices
Ok, I admit it - I love gadgets and if only I didn't have the restraints of Hubby and finances, I'd be even more of an addict! However as the tech world in general seems to be falling out of love with the Apple devices that were the hottest thing not that long ago and … Continue reading Addicted to Devices
Creating Professional Word Documents
Without having to fight your computer Word 2007 and 2010 rely heavily on styles and the default style "Normal" is very different from the normal style in earlier versions of Word. This does tend to cause frustration. To avoid frustration follow these simple tips. Use the Styles Formatting your document with styles gives many benefits, … Continue reading Creating Professional Word Documents
Excel 2013 vs 2010 – Interface Comparison
Comparing the interface between versions is a quick way of highlighting the changes between Excel 2013 (preview) and Excel 2010. Home Tab Insert Tab Page Layout Tab Formulas Tab Data Tab NOTE: in Excel 2010 the Analysis Pack has been added but in 2013 it has not. Review Tab View Tab Developer Tab Backstage View … Continue reading Excel 2013 vs 2010 – Interface Comparison
Office 2013 Web Apps
As a regular SkyDrive user I have been invited to take part in a preview of the upcoming new release of the Web Apps. Regardless of the reasons behind the offer, I LOVE getting to know new versions, it's one of the aspects of my profession that I most enjoy. So I approached trying out … Continue reading Office 2013 Web Apps
Seriously exciting times to be into IT
With all the new products and software versions on the way, it really is a great time to be a geek or gadget freak. So I thought I'd share with you the things that I am looking forward to over the next few months. MacOS Mountain Lion due July 2013, widely expected to be 25th … Continue reading Seriously exciting times to be into IT
Sara Fennah's Blog 
You must be logged in to post a comment.