This course will take you through Microsoft Excel 2010 from starting the program and using the Ribbon to creating Pivot Tables and summarising your data.
You will be able to create spreadsheets and workbooks that add up. Use more complex functions such as If Statements and present your data in a visually pleasing way.
You can take the course in the order it is set out or jump in and learn the lessons you need when you need them.
This course will have you presenting professional looking worksheets and summarising your data efficiently.
Get to grips with the Ribbon and see how it works.
The Quick Access Toolbar allows you to add your favourite icons to a handy toolbar which is always in view.
Find out how the Alt Key helps with keyboard shortcuts.
In Excel 2010 you can customise the Ribbon to add your own favourite icons where you want them or even create your own Ribbon.
Create your own Ribbon with the icons you use most often. All your favourite tools in one place.
The Backstage menu is where you will find information about the current file, new documents, printing and Excel Options.
Here you will find how to customise Excel and control how it works.
Complete the exercise to check your understanding and make sure that you can do everything you have learned so far.
Down load the pdf and follow the instructions.
Take the quiz to check your understanding. Good Luck!
Learn how to add text and numbers to your spreadsheets.
See how to format Numbers in Excel.
Learn about selecting different parts of your spreadsheet.
See how to format text entries in Excel 2010.
Learn about Number Formats in Excel and why they are important.
Sometimes you may wish to centre your heading accross several cells. See how to merge cells and centre the text across them all.
Complete the exercise to check your understanding of what you have learned. This exercise will enable you to practice formatting your spreadsheet.
Format Painter allows you to copy formatting from one location to another.
Learn how to insert columns and rows into your spreadsheet.
Copy or move information from one place in your spreadsheet to anohter.
There are different views of worksheets in Excel. Find out the differences and when to use them.
Learn about saving your work in different formats.
Send your spreadsheet as an attachment direct from within Excel.
Here is another exercise for you to do. This one is all about printing and emailing your spreadsheet. Download the pdf and follow the instructions.
Take the Quiz to check your understanding and see what you have learned.
Autofill is one of the most useful tools in Excel. Use it to copy content across or down a selection of cells or to create a series of data that increments ; like dates or days of the week.
Create your own custom list so that you can save time when typing in headings.
Learn how to add up a column of numbers.
See how Autofill helps when copying a formula across a row or down an entire column.
Take the Quiz to cosolidate what you have learned.
Build a formula from scratch.
Work out the Average value of a list or pick the minimum number of the maximum number with these handy functions.
Absolute Cell References allow you to fix part of the formula so that you can copy it down a column or across a row. See the video to understand how useful this feature is.
Complete the exercise to check your understanding. A practical example of how to use Absolute Cell References will help you embed the learning.
Take the Quiz to consolidate your leearning.
Sort your data by a particluar column.
You may wish to sort on more then one column of data and with Excel 2010 you can sort on up to 64 levels!!
When filtering data you can pull out just the information that you want to focus on. Really useful when you have a very large amount of data and need to focus on just one part.
Take the Quiz to consolidate your learning.
Formatting your data as a table allows you to add really great formatting plus a filter and some totals.
If you have formatted your data as a table and then finished with it, you might want to put the data back to static data. This short video shows you how.
Calculated columns allow you to create a formula in one cell and the automatic feature will populate the whole column when you press enter. A real time saver.
Learn how to add borders and shading to jazz up your spread sheets.
Use formatting to pick out data that matches a particular criteria. For example, show all cells where the value is greater than a certain amount in Red.
Subtotals are a great way to find out the total of each group of data in your spreadsheet. My favourite function.
Complete this exercise to practice sorting, filtering and conditional formatting.
A pivot table allows you to sort and filter your data plus get subtotals too. Simple to create once your data is arranged correctly.
Add formatting to your Pivot Table.
When you need to add extra data to your Pivot Table you will have to update it. This video tutorial shows you how.
Slicers allow you to filter a Pivot Table easily and you can have as many slicers as you wish.
A Pivot Chart is like a Pivot Table except you create a chart that can be filtered from drop down menus.
Complete this exercise to practice creating Pivot Tables and Pivot Charts.
Take the Quiz to consolidate your learning.
If the coffee sales in Bath are over £500 then have a pay rise otherwise no pay rise.
You can also do calculations within an IF Statement.
This lesson shows you how to build a basic IF Statement.
A nested If statement allows you to test for several conditions.
Create your first test, and if the formula is true it stops, if it gets a false result it continues to perform a second test and so on.
HI I am Shelley Fishel - a qualified Microsoft Certified Trainer and I have been teaching Microsoft Office for more than 18 years now. Through my IT Training Company,myself and a team of dedicated trainers deliver courses to businesses in many sectors.
With several levels of each course on offer and a bespoke offering as well I decided that it was time to put my classroom training on line.
Each course has several hours of video tutorials along with exercises to consolidate the learning.
I am very excited to bring this training to more people with my main aim, to save you time when working in Microsoft Office.