You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, troubleshoot errors, collaborate on worksheets, and share Excel data with other applications. This course will cover all the aspects and differences from 2016, 2013, 2010, and 2007.
This course is suitable for anybody wanting to learn 2016, 2013, 2010 or 2007, as it cover all the aspects and differences between the versions.
Instructor led, group-paced, classroom-delivery learning model with structured... more details
Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.
Target Students
This course was designed for students desiring to... more details
This course was designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data.
Prerequisites
Before taking this course, students are recommended to... more details
Before taking this course, students are recommended to take the following courses, or have equivalent knowledge:
This course is one of a series of courses that addresses Microsoft Certified Application Specialist (Microsoft Business Certification) skill sets. The Microsoft Certified Application Specialist program is for individuals who use Microsoft's business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more proficiency exams in order to earn Microsoft Certified Application Specialist certification.
Course Objectives
Upon successful completion of this course, students will... more details
Upon successful completion of this course, students will be able to:
Automate worksheet functions.
Audit worksheets.
Analyze data.
Work with multiple workbooks.
Import and export data.
Course Content
Lesson 1: Working with Multiple Worksheets and Workbooks... more details
Lesson 1: Working with Multiple Worksheets and Workbooks Simultaneously
Topic A: Use 3-D References Topic B: Use Links and External References Topic C: Consolidate Data
Lesson 2: Sharing and Protecting Workbooks
Topic A: Collaborate on a Workbook Topic B: Protect Worksheets and Workbooks
Lesson 3: Automating Workbook Functionality
Topic A: Apply Data Validation Topic B: Work with Forms and Controls Topic C: Work with Macros
Lesson 4: Applying Conditional Logic
Topic A: Use Lookup Functions Topic B: Combine Functions Topic C: Use Formulas and Functions to Apply Conditional Formatting
Lesson 5: Auditing Worksheets
Topic A: Trace Cells Topic B: Search for Invalid Data and Formulas with Errors Topic C: Watch and Evaluate Formulas
Lesson 6: Using Automated Analysis Tools
Topic A: Determine Potential Outcomes Using Data Tables Topic B: Determine Potential Outcomes Using Scenarios Topic C: Use the Goal Seek Feature Topic D: Activate and Use the Solver Tool Topic E: Analyze Data with Analysis ToolPak Tools
Lesson 7: Presenting Your Data Visually
Topic A: Use Advanced Chart Features Topic B: Create Sparklines
Locations
Training courses take place at the following locations... more details
Training courses take place at the following locations including Nottingham, London, Birmingham, Manchester, Leeds, Liverpool, Sheffield, Leicester or Your Office
What you get
Professional Microsoft Certified Trainer
Comfortable Premises, equipped with all the technology you need
