5 really great formulas to save time in Excel

5 really great formulas to save time in Excel

This Week I thought I would do 5 really great formulas that will save you time. So here we go Excel formulas you should definitely know:- 1. SUM The formula looks like this: =SUM(5, 5) or =SUM(A1, B1) or =SUM(A1:B5) The SUM formula does exactly what it says on the tin, allowing you to add 2 or more numbers together or even cell references if you use those lots. The different examples above take you through the options, you can have normal numbers in there separated by commas and it will add them together for you, you can have cell references and as long as there are numbers in those cells it will add them together for you as well, or you can have a range of cells with a colon : in between the 2 cells, and it will add the numbers in all the cells in the range, for example =SUM(A1:B5) 2. COUNT The formula looks like this: =COUNT(A1:A10) This formula is great it counts the number of cells in a range that have numbers in them yes you heard correct only those cell with numbers though. If you want to count other cells check out number 3. 3. COUNTA The formula looks like this: =COUNTA(A1:A10) Now this formula counts the number of non-empty cells in a range. So It will count cells that have numbers and/or any other characters in them the “COUNTA” formula works with all types of data. 4. LEN The formula looks like this: =LEN(A1) Ok with the two above we have counted ranges of cell to see how many is there using...
Quickly move from one table to another in Word 2013

Quickly move from one table to another in Word 2013

Going to a specific page in Word is a common task and easy to do using the Find and Replace dialog box. You can also use this same way to jump from one table directly to the next table in your document. You don’t have to be in a table to jump to the next table, just put the cursor in any paragraph or table and press F5 or use the Ctrl + G keystroke combination to open the Find and Replace dialog box. Clicking Next will show the next table in your document, the Find and Replace dialog box stays open. You can always jump to the previous table by just clicking Previous. The last function you can do is jump to a specific table by entering a table number in the edit box and clicking Go To. You’ll notice I have typed in 5 this will go to the 5th table in your document, if there is a 5 tables. If you enter a ‘+’ or a ‘-‘ before the number, the cursor will move relative to the current location. This is a feature and comes to its own when the document is lengthy with many tables.  ...
Microsoft Office is now free to use on Android

Microsoft Office is now free to use on Android

Microsoft Office including Word, Excel and PowerPoint is available for free on Android and iOS devices. It means that you don’t require a subscription to Office 365 for using Microsoft Office. In the other hand Microsoft has entered an agreement with DropBox Company to integrate its cloud storage service into Office on mobiles, tablets and home computers. Office accounts make for about a third of Microsoft’s annual revenue, according to the New York Times, so letting people access it for free is a big risk. Although Microsoft will continue to charge for access to Office on laptops and desktops and also some special features on mobile apps are only accessible to premium users. iOS version of Office is available from today and the Android version is available as a beta version and will get a full release in...
Disable the Mini Toolbar Word 2010 and 2013

Disable the Mini Toolbar Word 2010 and 2013

A couple of enhancements in Word 2010 and 2013 are the Mini Toolbar and Live Preview features. While these enhancements are welcome by some, other users may find them annoying. So this week is how to Disable extra features. The Toolbar pops up when you select text in a document. It allows you to change fonts, underline, bold, and italicize the selection and more. And Live Preview allows you to hover the mouse over different style types and instantly show you how the document will look with the changes. So to Disable the Mini Toolbar and Live Preview in Word 2010 and 2013 Click the File tab to access Backstage View and then click Options. Click General and under User Interface Options uncheck either Show Mini Toolbar on selection, Enable Live Preview or both then click OK. You don’t need to restart Word, the features will be disabled right away. Now when you highlight text, no more Mini Toolbar or Live...
Page 1 of 3123