Excel Training UK

From first time Excel users to advanced VBA experts, we offer Excel training courses to suit all abilities. Our popular Excel beginners courses are ideal for learning the basics of Microsoft's flagship spreadsheet application but we also offer advanced & tailored courses as well as a VBA for Excel course.

How to Create a Dice Roller in Microsoft Excel 2007

Use this Microsoft Excel tutorial to create your own dice roller, but why would you need to use Excel to roll your dice?

Excel Dice Tutorial

You’ve decided to have a family night in and play Cluedo. You open up the box, set up the game and go to start. One problem: you’re missing the dice. You frantically check all the other games; Monopoly,  Yahtzee, Risk and even Battleships – which doesn’t even have dice. As usual, there are none to be found – they’ve all disappeared. Probably down the back of the sofa or under some boxes in the wardrobe.

For some, this means that family night is over. For others, it’s time to open up Excel and create their own dice roller!

How to create a dice roller in Microsoft Excel 2007

New Excel SpreadsheetStep 1: Open up a blank spreadsheet in Excel.

Step 2: Select cell A1. From the Cells Menu within the Home Tab, select ‘Row Height’ from the Format drop down and enter 41. This makes all of Row 1 square cells.

Excel Change Row Height

Step 3: Enter the formula =INT(RAND()*6)+1 into cell A1.

Create Dice In Excel 2007

Step 4: Press F9 to roll your die, simply copy the formula into another cell if you want two or more dice. While you do have your dice working now, they don’t look very dicey, so here are some quick tips for formatting the cell. This is a great chance to show your kids (if you have any!) how to do some basic tricks in Excel. Read the rest of “How to Create a Dice Roller in Microsoft Excel 2007″

Excel Tutorial – How to Use the VLOOKUP and HLOOKUP functions

This is a simple tutorial in just one of many easily overlooked Microsoft Excel functions. If you find lots of gaps like these in your Excel knowledge then one of our tailor-made Excel training courses will be just what you need. We have public courses in Beginners Excel Training and Advanced Excel Training, and we can also tailor a private course to suit the individual need of you or your business.

VLOOKUP and HLOOKUP allow you to search a data range for any value entered, and return information or a value based on that data. VLOOKUP allows you to search information formatted by column, HLOOKUP for information formatted by row.

Read the rest of “Excel Tutorial – How to Use the VLOOKUP and HLOOKUP functions”

How to Create Drop Down Lists in Microsoft Excel

Sometimes, you just need to know how to do one thing in Excel and tutorial such as this is just what you need. However, if you find yourself always looking up how to do things and spending longer looking for solutions than actually using them then you should consider a Microsoft Excel Training course. Our courses are tailored for all ability levels; we run public Beginner Excel training and Advanced Excel training but can also tailor a course specifically to your requirements. Call us on 01273 622272 to discuss the level of training suitable for you.

Using a drop down list in Excel can make data input a lot easier – after all, you don’t want to waste time typing in the same thing again and again!

Preparing Your Excel Drop Down List Data

To start with, let’s make a list. Writing it out in alphabetical order can help, as the cell order is the order in which they will appear in the drop down list (the drop down list won’t automatically reorder itself). In this example, we’ll be using a list of flowers.

First, we write out our flower names in cells A1-A7:

excel-drop-down-list-tutorial-preparation

Creating the drop down list

Read the rest of “How to Create Drop Down Lists in Microsoft Excel”

Page 3 of 1312345...10...Last »