
This lecture shows students how to create and format a simple spreadsheet in Excel.
This lecture shows students how to construct a spreadsheet and enter numbers and entries. This lecture also shows students how to edit entries and covers basic spreadsheet navigation.
This lecture shows students how to do calculations in Excel as well as methods of how to use Excel to create calculations automatically.
This lecture shows students how to use the AutoSum function including copying and editing functions.
This lecture shows students how to create and use the Average, Max, Min, and Count functions in Excel.
This lecture shows students how to create basic number formats in Excel including currency, comma, and percentage formats. The format painter in Excel is also explained and applied.
This lecture shows students how to apply formatting to their worksheets such as highlighting and applying colors. Print preview and adding grid lines is also covered.
This lecture shows students how to create and format a column chart in Excel.
This lecture shows students how to create and format a pie chart in Excel.
This course guarantees you to learn the fundamental basics of Microsoft Excel.
Taught by Excel Master John Brickwater, this jam packed course is a fast paced tutorial for Excel beginners. Although Excel may seem like a complicated software, this course breaks it down piece by piece in easily understandable terms. No prior experience with Microsoft Excel is necessary.
You will begin by learning the simplest tools in Excel, creating and editing your spreadsheet. This course will teach you the basic calculations and functions Excel has to offer, as well as make you familiar with ways of formatting your spreadsheets to make them look more professional. Lastly, this course will teach you how to convert data from your spreadsheet into different kinds of charts.
When you have completed this course, you will be comfortable with performing daily operations on this software. You will be able to create your own spreadsheets with calculations and functions, along with creating professional charts and graphs from your data. To get a better taste of what this course will teach like, watch a preview of the Introduction Video.