Microsoft Office Excel 2013: Level 3 Training in Cambridge
Enroll in or hire us to teach our Microsoft Office Excel 2013: Level 3 class in Cambridge, Massachusetts by calling us @303.377.6176. Like all HSG
classes, Microsoft Office Excel 2013: Level 3 may be offered either onsite or via instructor led virtual training. Consider looking at our public training schedule to see if it
is scheduled: Public Training Classes
Provided there are enough attendees, Microsoft Office Excel 2013: Level 3 may be taught at one of our local training facilities.
We offer private customized training for groups of 3 or more attendees.
|
||
Course Description |
||
Upon successful completion of this course, you will be able to perform
advanced data analysis, collaborate on workbooks with other users, and
automate workbook functionality. You will: Work with multiple worksheets
and workbooks simultaneously. Share and protect workbooks. Automate
workbook functionality. Apply conditional logic. Audit worksheets. Use
automated analysis tools. Present your data visually.
Course Length: 1 Days
Course Tuition: $250 (US) |
Prerequisites |
|
Students should have some experience creating formulas and using Excel functions; creating, sorting, and filtering datasets and tables; presenting data by using basic charts; creating and working with PivotTables, slicers, and PivotCharts; and customizing the Excel environment. |
Course Outline |
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
Appendix A: Microsoft Office Excel 2013 Exam 77-420
Appendix B: Microsoft Office Excel 2013 Expert Exams 77–427 and 77-428
Appendix C: Cube Functions
Appendix D: Import and Export Data
Appendix E: Internationalize Workbooks
Appendix F: Work with PowerPivot
|
Course Directory [training on all levels]
Technical Training Courses
Software engineer/architect, System Admin ... Welcome!
- .NET Classes
- Agile/Scrum Classes
- Ajax Classes
- Android and iPhone Programming Classes
- Blaze Advisor Classes
- C Programming Classes
- C# Programming Classes
- C++ Programming Classes
- Cisco Classes
- Cloud Classes
- CompTIA Classes
- Crystal Reports Classes
- Design Patterns Classes
- DevOps Classes
- Foundations of Web Design & Web Authoring Classes
- Git, Jira, Wicket, Gradle, Tableau Classes
- IBM Classes
- Java Programming Classes
- JBoss Administration Classes
- JUnit, TDD, CPTC, Web Penetration Classes
- Linux Unix Classes
- Machine Learning Classes
- Microsoft Development Classes
- Microsoft SQL Server Classes
- Microsoft Team Foundation Server Classes
- Microsoft Windows Server Classes
- Oracle, MySQL, Cassandra, Hadoop Database Classes
- Perl Programming Classes
- Python Programming Classes
- Ruby Programming Classes
- Security Classes
- SharePoint Classes
- SOA Classes
- Tcl, Awk, Bash, Shell Classes
- UML Classes
- VMWare Classes
- Web Development Classes
- Web Services Classes
- Weblogic Administration Classes
- XML Classes
Business Training Courses
Project Managers, Business Analysts, Paralegals ... Welcome!
Upcoming Classes
Gain insight and ideas from students with different perspectives and experiences.
- Intermediate Python 3.x
16 February, 2021 - 19 February, 2021 - VMware vSphere 6.7 with ESXi and vCenter
25 January, 2021 - 29 January, 2021 - Agile Development with Scrum
3 February, 2021 - 4 February, 2021 - C++ Programming
19 April, 2021 - 23 April, 2021 - 20483: Programming in C#
1 February, 2021 - 5 February, 2021 - See our complete public course listing