Course Objectives
By the end of this course, you will be able to:
Use multiple worksheets and workbooks to track, retrieve, consolidate and report on data using cell links, Group Mode, 3D Reference formulas, and Consolidate
Collaborate with others using Comments, Track Changes, Sharing, Co-Authoring, and Compare and Merge
Prepare a document for sharing by checking for accessibility and sensitive information and adding a digital signature
Protect your worksheets and workbooks from changes
Keep your data consistent and accurate with Data Validation and automate tasks with Macros
Perform complex calculations by developing a deep understanding of Excel’s VLOOKUP, MATCH, and INDEX functions
Quickly find and address errors in your formulas with Tracing, Evaluate Formula, and the Watch Window, as well as add error handling with the IFNA and IFERROR functions
Use your data to plan and forecast trends and explore a variety of outcomes based on variables and scenarios
Visualize geographic data with Map Charts and 3D Map Tours
SUBJECT MATTER EXPERT: Bigger Brains
In 2009, Bigger-Brains founder Chip Reaves was tasked with creating an online training platform for Computer Troubleshooters, a global franchise network. As is the case with most companies, some of the training content was unique to their business, but others (Quickbooks, Online Marketing, Microsoft Office, etc) could be used by many companies.
Frustrated with the poor quality, high prices, and lack of selection in the eLearning marketplace, Chip brought together a team to research the characteristics of effective training. The result is Bigger Brains’ “Uniquely Engaging” teacher/learner format, which replicates the dialogue, interaction, humor, and personal connection of traditional classroom training with the “always available” convenience and searchability of eLearning.
Today Bigger-Brains continues to create the “Absolute Best Online Training” from our studios in Anderson, South Carolina.