On Course for Success

Excel

Evening Classes

Milton Keynes

InIT Learning are pleased to announce the introduction of evening classes in Milton Keynes for nine weeks covering all three levels of Excel. Delegates receive nine comprehensive manuals and three certificates of attendance. All equipment is provided. A great friendly environment with no more than six delegates on each course. First course starts in October 2018 so get your place or places for your staff booked now.

Excel – Find out more>>

Scheduled Excel Courses

Excel Courses are scheduled in Milton Keynes

Excel Courses Milton Keynes

Best value Excel Courses in Milton Keynes
Harben House Hotel
Newport Pagnell

Excel Courses >>>

Excel Tips

Excel Tips

How to use the Evaluate Formula Tool

Evaluate Formulas

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 Values without using Formulas

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.

Interactive Excel Chart

Dynamic Chart

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

My Top Five Excel Shortcuts

Excel Shortcuts

My top Five Excel ShortcutsThese are my top five shortcuts I use while working on Excel. Depending on the work I am doing at the time my top five does change but this is how they stand at the moment.

Ctrl + D Duplicate cell above

Ctrl + ; Enter today’s date

Ctrl + 1 Open ‘Format Cells’ dialog box

Shift + F11 Add new worksheet

F12        Save As

 

Conditional Formatting in Excel

Help Focus the eyes with Conditional Formatting

Excel Conditional FormattingMicrosoft 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.

 

Ctrl Enter Tricks

Keep Active Cell on the same cell

This combination of keyboard keys is really useful. If you enter data, a function or formula and you wish the active cell to remain on the cell you are entering in,  hold the Ctrl key down and press Enter.

Enter a replica of text, numbers, formulas or functions across a selected range

Select the required range of cells and then enter the data in the active cell (the white one in the range) hold the Ctrl key down and press Enter.

Simple but effective use of the Ctrl and Enter keys