IT Banner
ExcelExcel Unit
This page is used for the Excel Unit. There will be videos to watch and assignments to do in this course. Please replicate what is being reproduced. Follow the schedule below to finish the Excel Unit. If videos are not loading, then reload/refresh the video and start video where you left off.

What is an Excel document or commonly known as a Spreadsheet?

Columns, rows and cells for accounting, budgeting, financial analysis, scientific applications, and other work with figures.

Excel - Please go to the Calendar on this website to know when all spreadsheet activities are due.
The gentleman man who speaks in the video is from the UK. Thus, the Microsoft Excel version he is using has the default settings set at UK settings. He uses the Pound (Pound) currencey instead of the Dollar ($) currency that our software is set at. Leave all currency set at dollars. Also, he is using the 2010 version of Excel. We are using 2007 version. There are only a few differences. Just follow along and you will figure it out. The "Merge & Center" icon is in the same place that he demonstrates; however, you will not have the words like him. IT IS IN THE SAME SPOT! The "Print Preview" function he does is a little different too. We do not have a "File" tab. Just go to the "Office Button" and go to "Print" then "Print Preview". You will see the Page Setup like below:PageSetup . Click on this and follow his instructions.
Excel 2010 Tutorial For Beginners #1 Overview (Microsoft Excel) save excel spreadsheet as Excel_1_Assignment
Excel 2010 Tutorial For Beginners #2 Enter & Edit Text and Numbers (Microsoft Excel) save excel spreadsheet as Excel_2_Assignment
Excel 2010 Tutorial For Beginners #3 Calculation Basics & Formulas (Microsoft Excel) use Excel_2_Assignment to complete this lesson

You will need to open up 2 documents from my Resouces page for Tutorial 3. Also, make sure you save this in your Excel Folder.

Calculation_Table.xls & Calculation_Table_2.xls

Excel 2010 Tutorial For Beginners #4 AutoSum Function (Microsoft Excel) use Excel_2_Assignment to complete this lesson
Excel 2010 Tutorial For Beginners #5 Functions AVERAGE MAX MIN COUNT (Microsoft Excel) use Excel_2_Assignment to complete this lesson
Excel 2010 Tutorial For Beginners #6 Number Formats (Microsoft Excel) use Excel_2_Assignment to complete this lesson

You will need to open up 1 document from my Resouces page for Tutorial 6. Also, make sure you save this in your Excel Folder.

Number_Formatting.xls

Excel 2010 Tutorial For Beginners #7 Formatting Worksheets (Microsoft Excel) use Excel_2_Assignment to complete this lesson
Excel 2010 Tutorial For Beginners #8 Conditional Formatting Pt.1 (Microsoft Excel) use Excel_2_Assignment to complete this lesson
Excel 2010 Tutorial For Beginners #9 Conditional Formatting Pt.2 (Microsoft Excel) use Monthly_Sales.xls to complete this lesson

You will need to open up 1 document from my Resouces page for Tutorial 9. Also, make sure you save this in your Excel Folder.

Monthly_Sales.xls

Excel 2010 Tutorial For Beginners #10 Charts Pt.1 (Microsoft Excel) use Excel_2_Assignment to complete this lesson
Excel 2010 Tutorial For Beginners #11 Charts Pt.2 Pie Chart (Microsoft Excel) use Excel_2_Assignment to complete this lesson
     
Excel 2007 Tutorial

Microsoft Excel Full Tutorial - Ms Excel Full Tutorial in English

Save as Excel_3_Assignment to complete this lesson