
Microsoft Excel 2013
This VTC course will give you the knowledge and skills you need to get the most out of Microsoft Excel 2013. You will learn about the Excel interface by working in it. You will create and format worksheets, make calculations, create charts, and use tools to analyze data in meaningful ways. Author Helen Bradley teaches Excel from a business perspective, focusing on tools that maximize productivity and accuracy. She demonstrates how to design worksheets intelligently and then shows you how to check for accuracy to ensure that worksheets return correct results. She also covers automating data entry, testing formulas, and using PivotTables for data analysis. She concludes with a discussion of SkyDrive and the Excel WebApp. To begin learning today, simply click on the movie links.
Course content
Excel Basics6 lessons
Getting Started6 lessons
Entering Data8 lessons
Rearranging a Worksheet5 lessons
Basic Formulas & Functions12 lessons
- Using SUM and AutoSum4:251 credit or ad
- Doing Simple Math4:241 credit or ad
- Order of Operations3:201 credit or ad
- Calculating Averages3:541 credit or ad
- Quick Analysis - Totals2:261 credit or ad
- Adding & Subtracting Dates3:081 credit or ad
- Copy Formulas4:201 credit or ad
- Absolute & Relative Addressing4:001 credit or ad
- Naming Ranges4:141 credit or ad
- Calculating Using Names4:111 credit or ad
- Understanding Errors4:171 credit or ad
- Evaluating a Formula4:131 credit or ad
Formatting a Worksheet10 lessons
- Format Numbers4:481 credit or ad
- Format Dates2:251 credit or ad
- Format with Color3:151 credit or ad
- Use Worksheet Themes3:381 credit or ad
- Add Borders4:281 credit or ad
- Conditional Formatting pt. 14:191 credit or ad
- Conditional Formatting pt. 24:231 credit or ad
- Borrow Table Formats3:021 credit or ad
- Create and Use Styles4:211 credit or ad
- Paint and Clear Formats2:231 credit or ad
Creating Charts8 lessons
- Create a Chart4:431 credit or ad
- Add Chart Titles and Legends3:211 credit or ad
- Format a Chart pt. 13:381 credit or ad
- Format a Chart pt. 24:191 credit or ad
- Create a Pie Chart4:281 credit or ad
- Understanding Chart Types3:231 credit or ad
- Plot Data on Multiple Axes3:101 credit or ad
- Create Sparklines4:051 credit or ad
Adding Art4 lessons
More Complex Functions6 lessons
Working with Tables6 lessons
Working with PivotTables5 lessons
Working with Large Worksheets6 lessons
Advanced Tools & Techniques12 lessons
- Goal Seek3:381 credit or ad
- Create and Use a Watch Window3:001 credit or ad
- Create and Save a Template4:011 credit or ad
- Calculate Across Multiple Worksheets3:201 credit or ad
- Working with Comments3:501 credit or ad
- Use a Lookup Table pt. 14:121 credit or ad
- Use a Lookup Table pt. 24:261 credit or ad
- Import Data into Excel4:471 credit or ad
- Find Precedents and Dependents2:391 credit or ad
- Use Data Validation4:131 credit or ad
- Enter Data Using Data Validation3:301 credit or ad
- Work with Other Office Programs4:371 credit or ad