How to use Conditional Formatting to create Data Bars
One Day Excel Courses
One day Excel Courses are scheduled and available, please watch the video below
This video shows you how to use and how the Evaluate Formula tool helps you find issues with formulas and what the spreadsheet is doing at each stage.
To learn more about the software book a course with InIT Learning
Change Cell Values without using Formulas
Have you ever needed to change all the values on your spreadsheets, for example; increase all your prices by 10% and then sat there adding extra columns to carry out the task with formulas and then copying all the results and remove the formulas and extra columns. Well there is a much easier way to perform this task using copy and paste special. Watch the video to see how.
Excel spreadsheets is one of the most popular and used software applications in the workplace. If you are looking for a job, applying for promotion or just want to increase your efficiency and effectiveness in the use of spreadsheets, then it is really worth getting some formal training. Often staff are self taught or have to keep asking that one person at work who has become the company Excel guru. Being self taught is fine but sometimes there are more efficient ways to carry out a task on the spreadsheets. Training does not have to cost much for example InIT Learning in Milton Keynes offer in-house courses at your company at prices starting from £80.00 per head and also have scheduled Excel courses at only £129.00 per head. It is surprising just how much more you can learn on the software that is used every day. Remember you are an advanced user at the bit you use every day and a beginner at the bit you don’t use or don’t even know exists.
This video shows you how to simply create a user interactive dynamic chart. There is no coding necessary just an understanding of Data Validation and the VLOOKUP() function.
For courses to learn more please visit www.initlearning.net
Scheduled One day Excel Courses available in Milton Keynes. Courses at yours available in Milton Keynes and surrounding areas/counties. e.g. Rugby, Northampton, Bedford, Oxford
TRUE and FALSE Logical Tests
> Greater than
< Less than
>= Greater than or Equal to
<= Less than or Equal to
<> Does not Equal
The content of cells can be tested and returns the word TRUE or FALSE. TRUE and FALSE are “Boolean Functions”, and therefore TRUE = 1 and FALSE = 0
Sometimes it’s more beneficial to display a 1 or 0. This can be achieved in several ways:
Excel Tip: Duplicating Data in a cell
Here are a couple of very neat shortcuts for duplicating data, formula or function in a cell.
Video by David Ludlow – One Day Computer Courses
Help Focus the eyes with Conditional Formatting
Microsoft have made conditional formatting very easy with many preset formats. These are an ideal way to get started and will bring your spreadsheet to life and get the spreadsheet working for you. You can change the font and cell formatting based on the contents of cells. Many companies I have worked with use the Red, Amber and Green colours (traffic light system of colours). Red normally meaning some action needs to take place immediately, Amber showing that you need to keep an eye on the figures and Green is okay. There are so many ways that conditional formatting is used it would be impossible to list them all. If you sit at work changing colours to help highlight certain parts of your spreadsheet then you might find conditional formatting will save you time.
Remember to highlight the cells that you are going to conditionally format and then click the Conditional Formatting command, from here you can make your choice from all the Microsoft presets or select New Rule to set your own rule and formatting/colours.
Most of the conditional formats are based on the contents of the cell being formatted; however, there is one choice where you can format cells based on other cells using a formula that is True or False.
Training or a course with this in is really useful as this really opens your Excel spreadsheet use and what you can get out of it.