Microsoft Office Posts

  • Using the Learn Community in the Tech Community
    The new Microsoft Learning community in the Tech Community is live along with the new blog. The tech community is quite simple to navigate but I wanted to take this opportunity to share a few tips. Thanks to my fellow MCTs for their help with these too, especially Julian Sharpe, Denise McLaughlin and Rolf McLaughlin. … Continue reading Using the Learn Community in the Tech Community
  • Using OneNote to learn Maths
      Steps: NOTE – this currently only works in the OneNote app for Windows from the Windows store (not full desktop app) Create equation in your page On the Draw tab, use select or lasso select to highlight your equation then click Maths Under your equation choose Evaluate Under the answer click Show Steps then … Continue reading Using OneNote to learn Maths
  • Office 2016 Preview – Compare the Ribbon
    I’ve been running Office 2016 for about a week now in my Windows 10 preview and loving them both.  I’d be perfectly happy having these running on my main machine, but have learnt the hard way the previews are best kept to virtual machines. (In case you are wondering about the technical set up I’m … Continue reading Office 2016 Preview – Compare the Ribbon
  • Devices everywhere
    With the best introduction of Word, Excel and PowerPoint for Android and upgrade of Outlook for Mac recently, I thought I’d revisit my multi device world and give you an update. With Office365 spreading wider I’m finding more and more clients want multi platform training and, well to be honest, I like playing with gadgets. … Continue reading Devices everywhere
  • Word for iPad – Getting Started
    Microsoft Word for iPad does not have all the features of the Windows desktop version, but it does have sufficient tools available for the majority of documents produced.  Install & Set up Word for iPad Microsoft Word should be downloaded from the App Store and will automatically be installed. Once installed open the app to … Continue reading Word for iPad – Getting Started
  • Recommended Charts and Pivot Tables
    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
  • 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
  • Calculating Employee Holiday Allowance in Excel
    This article looks at managing holiday using Excel 2010 and making use of the following Excel features: INDIRECT function NETWORKDAYS function Format as Table Conditional Formatting The finished file is available here (Holidays). However this article explains how to use the finished article and how to create it, so read on (or bookmark me for … Continue reading Calculating Employee Holiday Allowance in Excel
  • Named Cells, Ranges and Values
    Formulas and functions are usually created using references to other cells on the spreadsheet. Where you need to refer to a fixed cell and still be able to duplicate the formula around the spreadsheet then you can use fixed cell references as explained in the Simple Formulas and Functions reference guide. These absolute and mixed … Continue reading Named Cells, Ranges and Values
  • More Functions in Excel
    Named Cells, Ranges and Values Formulas and functions are usually created using references to other cells on the spreadsheet. Where you need to refer to a fixed cell and still be able to duplicate the formula around the spreadsheet then you can use fixed cell references as explained in the Simple Formulas and Functions reference … Continue reading More Functions in Excel
  • Mum’s Bragging Rights
    Today my 8 year old son, decided to put to use skills learnt at school and produce a Diamond Jubilee picture in PowerPoint.  He used images from the internet (mainly the official Jubilee website) and then saved his poster as a picture.  So I’m now a very proud Mum, but slightly embarassed trainer, as he … Continue reading Mum’s Bragging Rights
  • Quick Charts in Excel
    My favourite shortcut in Excel – to draw a chart select the data and press F11 key. Job done.
  • Analysis Functions in Excel 2010
    Enable Analysis Tools The analysis tools in Excel need to be switched on before use. To enable the Data Analysis tools: Select Options from the File tab Choose Add-ins At the bottom of the box, select Excel Add-ins and click Go Ensure both the Analysis ToolPak and Solver Add-in are ticked and click OK Performing … Continue reading Analysis Functions in Excel 2010
  • Selecting Text
    In order to modify the text you need to be able to indicate to the system which text you wish to modify. We do this by selecting the text. There are a few methods by which you can select text. Click & Drag Hover your mouse at the end of the text you wish to … Continue reading Selecting Text
  • Creating Simple Documents
    When creating a word document you need to be able to type in your text and then change the look and feel of the document to make the presentation of the document match your requirements. Selecting Text In order to modify the text you need to be able to indicate to the system which text … Continue reading Creating Simple Documents
  • Advanced Formatting in Excel 2010
    Comments Comments can be added to an Excel document for many purposes such as: Reviewing a document. Giving instructions to people completing a form. Explaining how a calculation works. Create a Comment To create a comment: Highlight the cell the comment is to be added to. On the Review tab, in the Comments group, click … Continue reading Advanced Formatting in Excel 2010
  • Research and Thesaurus
    With either the Research or Thesaurus button from the Review tab, the Research Pane can be opened. This looks up the selected word or phrase in the chosen reference book. To change the word or phrase to be looked up, simply overtype the information in the Search for: box. Once you have entered your desired … Continue reading Research and Thesaurus
  • Spelling and Grammar
    Spelling and Grammar check can be launched from the button on the Review tab or by pressing the F7 key on the keyboard. The tool will then check the document and inform you of potential errors. You can then accept a suggestion, ignore the error or add the word to your dictionary. NOTE: Items added … Continue reading Spelling and Grammar
  • Use Tracked Changes to Manage Document Updates
    Changes that are made to a document can be tracked. This helps when people are collaboratively working on a document, so you can see and review just the changes made, rather than the whole document. To switch on change tracking: On the Review tab in the Tracking group, click the Track Changes button Word will … Continue reading Use Tracked Changes to Manage Document Updates
  • Giving Other People Access to your Email Using Outlook 2010
    Outlook 2010 allows you to setup Delegate Access to your Inbox, Calendar, Tasks, Contacts, and Notes. Delegate Access allows the people you nominate to see, edit or send items on your behalf, including creating and responding to meeting requests. Selecting delegates You can select multiple delegates to have access to your account and individually set … Continue reading Giving Other People Access to your Email Using Outlook 2010
  • Missing Styles
    Sometimes when documents are converted from Word 2003 not all styles are available, due to settings on the document which have been carried over. To resolve this issue the style settings need to be changed. On the Home tab, click the dialog box launcher in the styles group. The Styles pane opens In the Styles … Continue reading Missing Styles
  • Follow Up Flags
    Emails and contacts can be ‘flagged’ for future attention using the follow up flags feature. Items flagged appear in the To Do list bar and To Do List view in Tasks. To flag an item for follow up: Look for the Follow Up button on the Home tab of the ribbon Choose the date you … Continue reading Follow Up Flags
  • Using Quick Parts
    Quick parts in Word 2010 incorporates: Auto text entries Document properties fields Standard word fields Templates for headers, footers, cover pages, tables of contents and more within Word These components can be incorporated into any document to speed up document creation and formatting. Headers and Footer Headers and footers with standard information have long been … Continue reading Using Quick Parts
  • Compare Two Documents
    There are two methods to compare documents available in Word 2010: The Compare function which automatically compares or combines versions Side by Side view which allows you to compare documents The Compare Function To compare two documents: Open the Review tab, select Compare and then Compare … Choose the two documents you wish to compare. … Continue reading Compare Two Documents
  • To Change the Theme of the Document in Word 2010
    The document Theme includes colours, fonts and effects for graphical objects within the drawing. When the Theme of a document is changed the entire document is reformatted to match the new chosen Theme. To apply a Theme: Select Page Layout Tab Click the Theme button Hover over the Theme to preview the impact on your … Continue reading To Change the Theme of the Document in Word 2010
  • Simple Formulas and Functions in Excel
    Creating Simple Formulas Formulas can be used to perform simple calculations such as addition and subtraction, or more complicated applications such as complex financial functions and statistics. All formulas begin with an equal (=) sign. The equal sign tells Excel that the cell data should be interpreted as a formula. Otherwise, Excel interprets the data … Continue reading Simple Formulas and Functions in Excel
  • Changing the Office 2010 Colour Scheme
    The default colour scheme for Office 2010 is silver, however on some monitors this does not always give a lot of definition between the panes in Outlook or between the Word document and the background. You can change this scheme to increase the contrast: In Word, Excel, Outlook or PowerPoint, click on the File tab … Continue reading Changing the Office 2010 Colour Scheme
  • ExcelTip dates are stored as numbers
    #ExcelTip dates are stored as numbers, so if u calculate with them, just got to format the answer so its a number not a date
  • ProjectTip: E = Excel
    #ProjectTip: E = Excel – plans in Excel, try manual scheduling in MSP 2010 to do more w/o the need to change how you work
  • Office 2011 (Mac) Courses
    And here are the Office 2011 courses we are now offering. These outlines are suggested courses, but they can be customised to suit your needs and time requirements. These courses have been designed especially for Office 2011 for Mac courses and to give equivalent knowledge to our PC based courses of similar levels. We can … Continue reading Office 2011 (Mac) Courses
  • Calculate with Dates
    One of the most asked questions during our Excel 2010 Training Courses has to be the subject of calculating with dates. Excel stores dates (and times) as a number representing the number of days since 1900-Jan-0, plus a fractional portion of a 24 hour day (e.g. 31/10/2011 10:00 is stored as 40847.42).This is called a serial date, or serial … Continue reading Calculate with Dates

Get new content delivered directly to your inbox.