Excel 2013 Essential Training
Whether you're a novice or an expert wanting to refresh your skillset with Microsoft Excel, this course covers all the basics you need to start entering your data and building organized workbooks. Author Dennis Taylor teaches you how to enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data, and build charts and PivotTables. Other lessons cover the powerful IF, VLOOKUP, and COUNTIF family of functions; the Goal Seek, Solver, and other data analysis tools; and how to automate many of these tasks with macros.
- What is Excel and what is it used for?
- Using the menus
- Working with dates and times
- Creating simple formulas
- Formatting fonts, row and column sizes, borders, and more
- Inserting shapes, arrows, and other graphics
- Adding and deleting rows and columns
- Hiding data
- Moving, copying, and pasting
- Sorting and filtering data
- Printing your worksheet
- Securing your workbooks
- Tracking changes
(music playing) Hi! I'm Dennis Taylor and welcome to Excel 2013 Essential Training. In this course, I will show you how to use this popular and powerful software. We'll begin by getting you familiar with Excel's menu System, how to create formulas and use simple functions. How to format your data for appearance sake; how to use printing and charting capabilities of Excel; how to work with powerful functions like "IF" and "VLOOKUP." I'll show you a few data analysis tools like "Goal Seek" and "Solver," and show you how to automate your work via macros.
We've got a lot to cover, so let's get started with Excel 2013 Essential Training.
There are currently no FAQs about Excel 2013 Essential Training.
Access 2013 Essential Training2,494,302 Views
Word 2013 Essential Training1,535,042 Views
Excel 2010 Essential Training5,756,965 Views
PowerPoint 2013 Essential Training1,546,790 Views
Foundations of Programming: Fundamentals6,728,971 Views
Excel 2013: Pivot Tables in Depth1,203,892 Views
Excel 2013: Advanced Formulas and Functions946,009 Views
HTML Essential Training3,250,120 Views
Excel 2013 Tips and Tricks702,997 Views