Excel

Microsoft Excel is one of the most powerful and useful programs available. Having a basic understanding of Excel is really a necessity. You don't need to know all of the functions of Excel of by heart... but you should understand what it can do and then how to find out how to do it.

With that in mind, watch the videos bellow and note what functions are explained. No need to remember all the steps, just what Excel can do.

Add numbers in Excel 2013

Watch these videos to see how Excel 2013 makes it easy to add numbers using formulas, buttons, and functions (such as the SUM and SUMIF functions).

Watch online (many more videos on this official Microsoft site!)  or here Excel Videos

Task:

Create a workbook for a fictional company that shows the sales figures for the 2014-15 financial year. You can choose any type of business you like and the workbook should be very well presented. 

Include sales figures for each month of the year and for a minimum of 5 different products.

Formatting Skills:

• Centered headings

• Wrap text in a cell

• Fill cells with different colours

• Use of borders

• Insert at least 1 image

• Format text & number in several ways (bold, coulor, italic, currency, percentage etc)

• Include a header and footer

• Name the worksheet

Calculation Skills

• Use 2-3 different formula

• Create charts to show information (3-5 charts)

• Edit chart labels

• Present useful data.

Extra Challenges!

• Conditional formatting

• Insert comments and change the shape of comment box

• "Pop-up" image when curser hovers

• Hide gridlines and round chart borders

• Use a Macro