Excel 2013 Essential Training
What you'll 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.
Requirements
- Hope you excel2013 installed, and learning all work files are in the folder Exercise Files, download and learn.
Description
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
Who this course is for:
- This course is designed for the user who first sees the operating environment excel and advanced user podcherpnet yourself something useful.
Instructor
- 4.6 Instructor Rating
- 36 Reviews
- 117 Students
- 1 Course
I'm an Excel developer and trainer. I also run a consultancy business specializing in custom Excel apps and data analytics. Over the years, I've been asked to run so many training sessions on Excel that I finally decided to put my content online. My focus is on helping people get the most out of Excel with the minimum effort, pain, and the least boredom.
Let's face it, using Excel isn't always the highlight of everyone's day. For many it's a constant pain because they have to go to ask the office guru every time they need to do a VLookup, or a Pivot Table. Perhaps they don't even know what a Pivot Table is! My courses are all about helping you to get the most out of Excel, so that you can be faster and more effective with your spreadsheets, without boring you with technical manuals or long form lessons.
There is so much opportunity to improve efficiency, automate tasks, get better data insights, reduce errors, and create happier staff, simply by improving the level of competence in Excel across organizations. I have seen countless Excel classes that focus just on what the various buttons in Excel do and how to use them. I never felt this was enough. Excel users need to know WHEN and WHY they should use these tools, not just HOW. There's also huge scope for to coach Excel users away from common pitfalls and bad practice. I created these courses to provide more comprehensive, training for Excel users of all levels from beginners to seasoned experts.