4 Hour Live Virtual Training on MS Excel Formulas and Tools of the Trade
Details
In this practical and interactive webinar, you will work along with the instructor. As you progress through the provided spreadsheet of exercises, you will learn a handful of the most often used formulas in Excel. These will include: VLookup, HLookup, Index and Match (solved at last!), Text to Columns, Concatenate, remove Duplicates, IF Functions, Flash Fill and more! You will also discover the tools Andy uses almost daily, but are overlooked and mostly forgotten in Excel. These include, Formula Auditing, Formula Watch, Show Formulas and special tools to add to the Quick Access Toolbar.
Course ObjectiveText To Columns and then Reverse w/ Concatonate
Use two types of IF Functions (Logical and Error)
Understand the syntax of the VLookup and HLookup formulas
Understand the syntax of the Index and Match formulas (finally ‘simply’ explained)
Transpose Data that may be organized incorrectly
Remove Duplicates while staying in charge of the process with Conditional Formatting
Flash Fill (new in 2016)
Absolute Ref vs Named Range in Formulas
Formula Auditing + Show Codes
Formula Watch Window
And hidden tools to add to your Quick Access Toolbar
Who is the Target Audience?Accountants, Accounts, Audit
Aviation
Banking, CFOs
Controllers, CPAs
Education
Energy
FDA
Finance, Financial consultants
Human Resource
Insurance
Investments
IT
Logistics & Supply Chain
Marketing
Medical Devices
Pharmaceutical
Retail,Sales
Telecom
Basic Knowledge:This is an intermediate level class. Attendees should be familiar with Excel and use it on a regular basis, at least weekly.
Online learning platforms such as Simpliv are completely changing the face of the education landscape for better. Among the many advantages of the e-learning platforms, one of the most significant ones is that it allows the learners to access the expertise of the trained instructors and gives the opportunity to become active participants within the eLearning community.
Benefits for Instructors /Authors
With the educational landscape changing at a rapid pace, the instructors are becoming a key player in the progress of academic teaching and learning experience.
Our online instructors/ authors, at Simpliv, play an important role in the online learning as they hold the requisite knowledge and experience that not only benefit the learners but also provide the necessary encouragement to the learners to master the skills needed for the professional success. Our authors aren’t only subject matter experts in their respective fields but they are great teachers as well.
There are several benefits to the instructors/ authors by being associated with the Simpliv platform. The platform allows the authors to get paid decently for sharing their expertise and knowledge. Other than the flexible schedule, the rapid growth in online educational opportunities, attractive payment options, it also gives the chance to be the change makers in the larger e-learning format. ...