Wise Owl Training - Excel blogs (page 3 of 4)

Showing blogs 41-60 (out of 62)

Rounding numbers in Excel

Posted by Michael Allsop on 23 October 2012

Up, down, ceiling, floor or multiples… and you thought rounding numbers was simple!

Tags:   Excel | Excel functions

Highlighting negative columns in Excel charts

Posted by Michael Allsop on 01 October 2012

Ever wondered if you can make negative columns automatically turn red in an Excel chart? Well now you can in Excel 2010!

Tags:   Excel | Charts

Some ideas for new features for Microsoft Excel 20xx

Posted by Andy Brown on 24 September 2012

Excel is a great product, but there is always room for improvement. Here Andy Brown considers 12 possible new features for Excel 2020.

Tags:   Miscellaneous | The future    |    Excel | General

What is PowerPivot for Excel 2010 - an Overview

Posted by Andy Brown on 04 May 2012

PowerPivot for Excel allows you to crunch very large amounts of data quickly, using pivot tables and slicers and other familiar Excel concepts. It also includes the DAX language, allowing you to create complex calculations.

Tags:   Excel | PowerPivot

Protecting Worksheets and Workbooks in Excel

Posted by Andrew Gould on 28 February 2012

If you've ever been annoyed by somebody else changing parts of your Excel workbooks it's a good idea to learn about protection to prevent them from doing it again!

Using Data Validation in Microsoft Excel

Posted by Andrew Gould on 28 February 2012

If you're constantly frustrated by other people entering the wrong values in your spreadsheets why not learn how to use data validation to prevent them? This blog series explains how you can control what other people can do to your spreadsheet.

Using Scenarios in Microsoft Excel

Posted by Andrew Gould on 27 February 2012

Scenarios are incredibly useful when performing "what-if analysis". They allow you to quickly swap a range of input values to test different possibilities without having to retype any values. Read on to find out how they work!

Tags:   Excel | What-if analysis

Goal Seeking in Microsoft Excel

Posted by Andrew Gould on 24 February 2012

Goal seeking in Excel allows you to approach calculations from the "result end" and get Excel to tell you what inputs you need in order to hit a specific target. Read on to find out how it works!

Tags:   Excel | What-if analysis

Using Styles in Microsoft Excel

Posted by Andrew Gould on 24 February 2012

Constantly formatting cells in the same way can be one of the most tedious and time-consuming tasks in Excel. This blog teaches you how to use styles so that you can quickly apply consistent formatting across a range of cells.

Tags:   Excel | Formatting

10 Excel Quick Tips

Posted by Andrew Gould on 02 December 2011

Some tasks in Excel always seem to take longer than they should - if only you knew a bunch of quick shortcuts to speed up the simple things. Read on to see how much time you could save!

Tags:   Excel | Formulae    |    Excel | Excel functions    |    Excel | Charts

How to Create Custom Charts in Microsoft Excel

Posted by Andrew Gould on 10 November 2011

One of the most time-consuming things when creating charts in Excel is having to format them. This blog shows you how to save and reuse custom charts to ensure that you'll never have to format a chart again!

Tags:   Excel | Charts

Setting the Default Chart Type in Microsoft Excel

Posted by Andrew Gould on 10 November 2011

When you create a chart, by default Excel always tries to give you a boring old column chart. If you primarily create pie charts it can be really annoying having to change the chart type every time you create one. This blog shows you how to set Excel to always create the type of chart that you want.

Tags:   Excel | Charts

How To Create Custom Date Formats in Microsoft Excel

Posted by Andrew Gould on 31 October 2011

When you enter dates into cells in Microsoft Excel you're initially limited to a short list of fairly boring formats. Using custom date formats means that you can display your dates in almost any way you like!

Tags:   Excel | Formatting

Using Icon Sets for conditional formatting in Microsoft Excel

Posted by Michael Allsop on 19 October 2011

This article looks at one of the new features in Conditional Formatting in Excel which we can use to make our boring lists more interesting!

Tags:   Excel | Formatting

Conditional formatting with Data Bars in Microsoft Excel

Posted by Michael Allsop on 19 October 2011

Following on from the article discussing simple conditional formatting in Excel, this blog shows you how to add Data Bars to your lists for that extra bit of pazazz!

Tags:   Excel | Formatting

How to apply Conditional Formatting in Microsoft Excel

Posted by Michael Allsop on 19 October 2011

This short article looks at the basic settings for creating conditional formatting rules in Excel.

Tags:   Excel | Formatting

How to Remove Duplicates from a List in Microsoft Excel

Posted by Andrew Gould on 12 October 2011

If you've ever had the tedious job of manually scrolling through a long list of data to remove the duplicate entries in Excel then this blog is for you! Discover how to hide or delete duplicated data in Excel 2003, 2007 and 2010.

Using Fractions in Microsoft Excel

Posted by Andrew Gould on 03 October 2011

If you've ever tried to enter fractions in Microsoft Excel you'll probably have become frustrated when Excel insists on converting them into dates! Read this blog to see how to prevent this from happening.

Tags:   Excel | Formatting

Choosing Colours In Microsoft Office Applications

Posted by Andrew Gould on 19 September 2011

Have you ever been asked to reproduce your company's brand colours in your latest PowerPoint presentation, or wanted to use your corporate font colours in your latest Word report? This blog will show you how to pick your colours accurately in any of the standard Microsoft Office applications.

Tags:   Excel | Formatting    |    Word | Formatting

Using the VLOOKUP Function in Excel to Calculate Exam Grades

Posted by Andrew Gould on 22 August 2011

The VLOOKUP function in Excel is perfect for categorising a continuous range of numbers. This topical example shows you how to calculate an exam grade based on a numerical score.

Tags:   Excel | Excel functions
This page has 0 threads Add post