Wouldn’t it be great to learn how to effectively use all the advanced Excel features? In this practical and information-packed Microsoft Excel training, you’ll see how to truly maximize this program’s functions and capabilities. After all, most organizations rely heavily on Excel to consolidate, analyze, and report data and want their employees to be proficient in this important program. This Excel training class gives you the skills you need to impress your current or future employer—and its online format means you can take this class from anywhere, at any time.
With exercises, quizzes, expert instructors, and all the latest information, the best online Excel training is right here at ed2go. We’ll simplify some of those tricky Excel concepts that might seem hard to grasp, so you can discover how Excel 2016 table tools actually take the complexity out of spreadsheet creation and management. When you’ve completed this course, you’ll be able to accomplish just about everything Microsoft Excel has to offer in displaying, analyzing, reporting, and tracking data—and you’ll understand it so well, you’ll even be able to share your newfound skills with your friends and colleagues.
We’ll explore the Excel Options dialog box, set up your Quick Access Toolbar, and take a look at the status bar and its customizable features. Then we’ll explore data forms and databases, and look at a few alternative database techniques. We’ll delve into advanced formatting and data forms, and you’ll practice using a data form to search for and view records that match specific criteria.
We’ll tackle data validation techniques. You’ll practice using whole number, decimal, date, time, list, and other forms of validation. After that, we’ll explore custom validation. Then it’s time to work with custom controls—graphical objects that help facilitate data input. You’ll learn how to create standard and drop-down list boxes, check boxes, option buttons, and group boxes. You’ll also master the process of creating a dynamic list box.
You’ll discover how to use formula conditional formatting. We’ll work through nine different practice exercises that explore row conditional formatting. You’ll see how to use conditional formatting to hide errors, highlight records based on multiple criteria, find the differences between two lists, how to set up a scorecard, and more. Then we’ll learn about consolidating and outlining, including how to use automatic and manual outlining to view or hide different levels or sections.
We’ll focus on predefined calculations spanning four categories: Logical, Database, Math & Trig, and Lookup & Reference. We’ll take a look at the Insert Function dialog box, the IF function, nesting functions, the DSUM function, and the VLOOKUP function. Next you’ll see how to use the built-in Query Editor, and do an import from an external database that combines two database tables into a single import. Finally, you’ll learn how to perform a web query.
You’ll learn how to use two types of data tables: a one-variable data table (which lets you substitute just one variable into the formula calculation) and the two-variable data table (which allows you to change multiple aspects of the formula). Then we’ll explore three more of Excel’s what-if analysis tools: Goal Seek, Scenario Manager, and Solver. We’ll practice using Scenario Manager and put Excel’s Solver to work.
You’ll discover how to use PivotTables, and practice both methods for creating them. You’ll also learn how to edit a PivotTable, how to filter the table to create individual reports, how to format a PivotTable to make it reader-friendly, how to insert a Timeline, and how to create and use calculated fields and items. Finally, we look at the functions available in the Analysis ToolPak, including the Moving Average and Sampling tools.
Prerequisites / Requirements
There are no prerequisites to take this course.
- This course must be taken on a PC. It is not suitable for Mac users.
- Windows 7 or later.
- Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
- Microsoft Office Home and Student 2016 or Microsoft Office 365.
- A free 30-day trial of Office 365 Home Premium may be available at (https://office.microsoft.com/en-us/try/). Then, a subscription can be purchased for as little as $9.99 per month. Please be sure to install the software on your computer before the course begins.
- Note that the “Starter Version” and “Web App” versions of Microsoft Excel will not work with the full version of Excel taught in this course.
- Adobe Flash Player. Click here to download the Flash Player.
- Adobe Acrobat Reader. Click here to download the Acrobat Reader.
- Email capabilities and access to a personal email account.
- Software must be installed and fully operational before the course begins.
HOW CAN I LEARN EXCEL?
Don’t just rely on Excel training books and manuals. A hands-on education that uses engaging materials and real-life examples is the way to get the most out of your training. But you don’t need to spend your valuable time traveling to classes with strict starting times, either. Learning Excel online is a great way to master new skills, on your own terms.
WHAT IS THE LATEST VERSION OF EXCEL?
The version that we use in this course, Microsoft Excel 2016, is the latest version of the program. You can rest assured you’re getting all the most up-to-date information and learning about this version’s state-of-the-art features.