When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.
Excel 2013 Essential Training
Teaches you the basics of using Excel 2013 to enter and organize data, use functions, and build charts and PivotTables.
This Course Includes
udemy
5 (36 reviews )
6h 34m 
english
Online - Self Paced
professional certificate
Udemy
About 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 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_
What You Will Learn?
- Hi! I'm Andrey 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..