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 features like 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, as well as multiple ways to 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 Lookup functions like VLOOKUP, MATCH, and INDEX.
- 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.