Excel 2013 Essential Training

MP4 | Video: 1280x720 | 58 kbps | 48 KHz | Duration: 7 Hours | 1.11 GB

Genre: eLearning | Language: English

Teaches you the basics of using Excel 2013 to enter and organize data, use functions, and build charts and PivotTables.

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 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.

Topics include:

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