You receive all these components and have the rights to make any changes you like.
Training materials designed with everything you need to teach…
Our Microsoft Office Excel 2010: Advanced courseware includes all the information that you need on advanced data analysis and reporting tools.
Section One focuses on data analysis tools, including automatic outlining, grouping, and subtotaling; the Scenario Manager; add-ins; goal seek; data tables; and Solver. It also includes a discussion on using hyperlinks in Excel.
Section Two focuses solely on PivotTables. Participants will move through all of the tasks associated with a PivotTable, right from creating the table, to using contextual tabs, to analyzing and managing data, to formatting the table for easy viewing. Information on classic PivotTable frames, Slicers, and PowerPivot is also included.
Section Three focuses on PivotCharts. Participants will build on their PivotTable knowledge to create a PivotChart, pivot data, use the contextual tabs, format it, and add slicers to it. The section will conclude with lessons on using PivotCharts in everyday contexts, like analyzing scenarios.
Section Four will begin by covering financial functions (PMT and FV), logical functions (IF, IFERROR, AND, OR, NOT, FALSE, and TRUE), and VLOOKUP. A discussion on custom AutoFill lists and linking, consolidating, and combining Excel data rounds out the section and wraps up the Microsoft Office Excel 2010: Advanced course.
Number of locations needed:
Course description:
Our Microsoft Office Excel 2010: Advanced courseware includes all the information that you need on advanced data analysis and reporting tools.
Section One focuses on data analysis tools, including automatic outlining, grouping, and subtotaling; the Scenario Manager; add-ins; goal seek; data tables; and Solver. It also includes a discussion on using hyperlinks in Excel.
Section Two focuses solely on PivotTables. Participants will move through all of the tasks associated with a PivotTable, right from creating the table, to using contextual tabs, to analyzing and managing data, to formatting the table for easy viewing. Information on classic PivotTable frames, Slicers, and PowerPivot is also included.
Section Three focuses on PivotCharts. Participants will build on their PivotTable knowledge to create a PivotChart, pivot data, use the contextual tabs, format it, and add slicers to it. The section will conclude with lessons on using PivotCharts in everyday contexts, like analyzing scenarios.
Section Four will begin by covering financial functions (PMT and FV), logical functions (IF, IFERROR, AND, OR, NOT, FALSE, and TRUE), and VLOOKUP. A discussion on custom AutoFill lists and linking, consolidating, and combining Excel data rounds out the section and wraps up the Microsoft Office Excel 2010: Advanced course.
Each instructor-led trainer kit comes with everything a facilitator needs for a successful training session. This includes a comprehensive instructor guide with best practices for delivering the material, a participant manual for learners to follow along and take notes, PowerPoint slides that align with the course content, interactive exercises and worksheets, and icebreaker activities to start each session on a positive note. You’ll also receive quick reference guides that can be printed and distributed, providing learners with immediate on-the-job support after the workshop ends.
Yes. When you purchase an instructor-led training kit from TrainingMaterials.com, you also receive the corresponding eLearning version of the course at no extra cost. This is delivered in SCORM 1.2 or xAPI formats, so you can quickly upload it into your learning management system (LMS) for self-directed, online delivery. This dual-format approach ensures maximum flexibility, allowing you to offer both in-person workshops and on-demand eLearning experiences based on your organization’s needs.
Absolutely. All materials provided by TrainingMaterials.com are delivered in formats you can edit, such as Microsoft Word and Articulate Storyline. You can easily insert your organization’s logo, change color schemes, add or remove content, and tailor examples or case studies to match your industry or team’s unique requirements. Our goal is to empower you to deliver training that feels fully integrated with your organizational brand and culture.
Our self-directed e-learning courses are available for instant download in SCORM 1.2 and xAPI formats. Simply upload them into your learning management system (LMS) and assign the courses to your learners. Because the courses come ready-to-use right out of the box, you can start delivering training within minutes—no lengthy installation or course-building process required.
The Articulate Storyline files offer complete flexibility and control over your e-learning design. They arrive fully written, so you can launch them as-is or open the .story files in Articulate Storyline to customize interactions, add your own images or videos, and integrate organization-specific scenarios or policies. This saves you countless hours of development time while still allowing for thorough personalization of the learning experience.
All of our training materials are carefully crafted by instructional design experts to meet the needs of adult learners. We incorporate interactive exercises, real-world scenarios, and practical problem-solving activities into each course. This approach not only builds learner engagement but also guarantees effective knowledge transfer and measurable performance outcomes. TrainingMaterials.com is trusted by professional organizations in over 160 countries precisely because our methodologies have been proven effective time and again.
Seeing is believing. Download a no obligation sample version of this course.
TrainingMaterials.com supplies professional training providers with expertly designed, ready-to-use resources that empower them to deliver impactful learning experiences, drive workplace performance, and make training seamless, effective, and accessible for their organizations.
Our Location
