Complete Guide to MS Excel 2013
A 14-part course with Kaceli Technology Tips
Start Free Preview Start CourseCourse Overview
Teacher
With 17+ years of hands-on experience, a graduate degree in technology, certifications like MCSE, CNA and TCT and even teaching experience at a U.S. university, I strive to add value to my valued audience by providing concept-based and simple to... View ProfileDetails
- Total Time 1 hr, 37 min
- Lessons 14
- Attachments 15
- Exercises 41
-
56 CQ
14 Lessons in This Course
-
6 minFREEComputer Science lesson 1Free4 CQ
Begin developing working knowledge of Microsoft Excel 2013 with this intro lesson. Review the main components of the software and learn some basic commands.
Begin developing working knowledge of Microsoft Excel 2013 with this intro lesson. Review the main components of the software and learn some basic commands.
-
17 minComputer Science lesson 29 CQ
Microsoft Excel 2013 is all about automation. In this lesson, learn how to navigate a spreadsheet and review some basic formulas to apply to data.
Microsoft Excel 2013 is all about automation. In this lesson, learn how to navigate a spreadsheet and review some basic formulas to apply to data.
-
6 minMicrosoft Office lesson 34 CQ
In this lesson from Kaceli Technology Tips, learn how to perform basic division, multiplication, and subtraction functions in MS Excel 2013.
In this lesson from Kaceli Technology Tips, learn how to perform basic division, multiplication, and subtraction functions in MS Excel 2013.
-
10 minMicrosoft Office lesson 46 CQ
Getting auto fill errors? Learn how to prevent sequential cell errors by using absolute, relative, and mixed cell references in MS Excel 2013.
Getting auto fill errors? Learn how to prevent sequential cell errors by using absolute, relative, and mixed cell references in MS Excel 2013.
-
3 minMicrosoft Office lesson 52 CQ
In this lesson, learn how to display Excel data in charts and graphs, and review the options and settings when using conditional formatting.
In this lesson, learn how to display Excel data in charts and graphs, and review the options and settings when using conditional formatting.
-
8 minMicrosoft Office lesson 65 CQ
When working with data, half the battle is displaying it in the right chart. In this lesson, learn how to create and customize charts in Microsoft Excel 2013.
When working with data, half the battle is displaying it in the right chart. In this lesson, learn how to create and customize charts in Microsoft Excel 2013.
-
6 minMicrosoft Office lesson 74 CQ
Keep your financial records up to date without lifting a finger! In this lesson, learn how to cross reference Excel spreadsheet with a quick and easy formula.
Keep your financial records up to date without lifting a finger! In this lesson, learn how to cross reference Excel spreadsheet with a quick and easy formula.
-
4 minMicrosoft Office lesson 83 CQ
Learn how to summarize financial data with this lesson on calculating percentages in Excel 2013. Use this formula to calculate ROI, sales figures, and more!
Learn how to summarize financial data with this lesson on calculating percentages in Excel 2013. Use this formula to calculate ROI, sales figures, and more!
-
9 minMicrosoft Office lesson 95 CQ
Learn how to use some of the more popular finance functions in Excel 2013, including formulas for the payment, interest payment, and principal payment rates.
Learn how to use some of the more popular finance functions in Excel 2013, including formulas for the payment, interest payment, and principal payment rates.
-
4 minMicrosoft Office lesson 103 CQ
Tired of recalculating data and shuffling through the Excel database? In this lesson, brush up on three methods for using a named reference in MS Excel.
Tired of recalculating data and shuffling through the Excel database? In this lesson, brush up on three methods for using a named reference in MS Excel.
-
3 minMicrosoft Office lesson 112 CQ
In this lesson, learn how to use data validation to create drop-down lists in Excel 2013, and understand the many benefits of data validation.
In this lesson, learn how to use data validation to create drop-down lists in Excel 2013, and understand the many benefits of data validation.
-
5 minMicrosoft Office lesson 123 CQ
Explore another useful Excel tool with this lesson on how to use pivot tables. Learn how to prepare data, use the recommended tables feature, and more.
Explore another useful Excel tool with this lesson on how to use pivot tables. Learn how to prepare data, use the recommended tables feature, and more.
-
4 minMicrosoft Office lesson 133 CQ
Brush up your business reporting skills with this lesson on merging Excel and Word documents, and learn how to link and update Excel data objects.
Brush up your business reporting skills with this lesson on merging Excel and Word documents, and learn how to link and update Excel data objects.
-
5 minMicrosoft Office lesson 143 CQ
In this lesson, learn how to import .CSV files or delimited text files using the Excel Text Import Wizard, and get tips for exporting and sharing.
In this lesson, learn how to import .CSV files or delimited text files using the Excel Text Import Wizard, and get tips for exporting and sharing.
-
19116 min19-part Microsoft Office course68 CQ
In this course from Kaceli Technology Tips, start out with the basics of MS Word 2013, such as formatting and using styles, and advance to complex editing and publishing tasks—quickly!
In this course from Kaceli Technology Tips, start out with the basics of MS Word 2013, such as formatting and using styles, and advance to complex editing and publishing tasks—quickly!
-
4 minFREEMicrosoft Office lessonFree2 CQ
Get a quick review of how to to calculate percentages in Excel! Watch how to properly format the spreadsheet cells, and how to create the formula.
Get a quick review of how to to calculate percentages in Excel! Watch how to properly format the spreadsheet cells, and how to create the formula.
-
6 minMicrosoft Office lesson4 CQ
Need to create a table of contents in Word, but not sure how to do it? Watch this short lesson to see how easy it is to master this Microsoft Office skill!
Need to create a table of contents in Word, but not sure how to do it? Watch this short lesson to see how easy it is to master this Microsoft Office skill!
-
16 minMicrosoft Office lesson9 CQ
Want to brush up your Microsoft Access skills for designing and running database queries? This lesson will walk you through the steps and get you up to speed.
Want to brush up your Microsoft Access skills for designing and running database queries? This lesson will walk you through the steps and get you up to speed.
-
5 minMicrosoft Office lesson3 CQ
Learn how easy it is to sort data in Excel 2013. Find out how to apply one or more filters to your data, as well as how to reset and customize the filters.
Learn how easy it is to sort data in Excel 2013. Find out how to apply one or more filters to your data, as well as how to reset and customize the filters.
-
762 min7-part Microsoft Office course33 CQ
New to Microsoft Office? Then you're probably eager to get started with Microsoft Word, the go-to program for creating text documents. Over the course of 13 lessons, instructor Richard Rost will walk you through an overview of Microsoft Word basics. Learn to navigate the program using the Word interface and ribbon. Once you're comfortable, learn to create a document—a business letter—and enter edit, and format text. You'll learn a few keyboard shortcuts and how to print, email, and save files.
with AmicronNew to Microsoft Office? Then you're probably eager to get started with Microsoft Word, the go-to program for creating text documents. Over the course of 13 lessons, instructor Richard Rost will walk you through an overview of Microsoft Word basics. Learn to navigate the program using the Word interface and ribbon. Once you're comfortable, learn to create a document—a business letter—and enter edit, and format text. You'll learn a few keyboard shortcuts and how to print, email, and save files.
-
11137 min11-part Microsoft Office course73 CQ
Learn how to crunch through your PowerPoint slides, create decks you’re proud of, and finish your PowerPoint presentation quickly and professionally with hotkeys and the Quick Access Toolbar!
Learn how to crunch through your PowerPoint slides, create decks you’re proud of, and finish your PowerPoint presentation quickly and professionally with hotkeys and the Quick Access Toolbar!
-
26150 min26-part Microsoft Office course89 CQ
Discover some of Microsoft Excel's most handy formulas, shortcuts, and add-ins in this course. From sorting through data, to using a solver to optimize values, increase your Excel productivity today.
Discover some of Microsoft Excel's most handy formulas, shortcuts, and add-ins in this course. From sorting through data, to using a solver to optimize values, increase your Excel productivity today.
-
12175 min12-part Microsoft Office course94 CQ
Whether you’re a beginner or have Excel experience, this course will help you master one of the most powerful Microsoft Office programs available. Motion Training covers the fundamental skills you need to become a power user, including: proper spreadsheet set up, workbooks, calculations, formulas, functions (such as AutoFill and AutoSum), cell formatting, and charting. All lessons include .xlsx files so you can follow along for practice. Note that videos show Excel 2010.
with Motion TrainingWhether you’re a beginner or have Excel experience, this course will help you master one of the most powerful Microsoft Office programs available. Motion Training covers the fundamental skills you need to become a power user, including: proper spreadsheet set up, workbooks, calculations, formulas, functions (such as AutoFill and AutoSum), cell formatting, and charting. All lessons include .xlsx files so you can follow along for practice. Note that videos show Excel 2010.
-
661 min6-part Microsoft Office course34 CQ
Learn everything you need to know to get up and running with Powerpoint in just 1 hour! This course covers design, style, transitions, animations and a few advanced topics too.
Learn everything you need to know to get up and running with Powerpoint in just 1 hour! This course covers design, style, transitions, animations and a few advanced topics too.