Complete the short form below and we'll immediately email you a no obligation access.
What is this?
This is a training materials package with everything an instructor would need for teaching Excel 2010 - Advanced.
Customizable Courseware and Training Materials designed to help you teach Excel 2010 - Advanced.
Excel 2010 - Advanced, like all Velsoft courseware titles is completely customizable, it can be easily edited to better suit your needs or the needs of your clients. Likewise, courses can be personalized to any organization in seconds giving you the ability to brand the material as your own.
All Excel 2010 - Advanced Courseware levelsThe following items in no way constitute service that is part of the course purchase price but are perks we make available to our customers:
Our Microsoft Office Excel 2010 Advanced course 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.
The greatest value comes when purchasing Excel 2010 - Advanced Courseware as part of the Office 2010 Courseware Bundle. For only $2995 you will receive instructional courseware for all the Office 2010 products. Use the chart below as a guide to what most of the courseware titles in this bundle include.
"I have found the material provided by Velsoft.com to be very user-friendly. The arrangement of the materials are so well organized that it makes my training very easy. I love the staff there as well, because each time I need assistance with something they are always willing to help and the response time is remarkable. One of the best things I came across on the Internet is Velsoft.com Computer Training Software. I plan to continue my business relations with them. It's a great company with great people."
- J. Glenn, Maryland"The material is what I expected it to be. I think we got value for money which is what really counts and don't know if I would have been able to do a better job myself. It certainly saved me several weeks of effort, which is well worth it. I appreciate the openness, patience, support and honesty I received throughout and will recommend Velsoft to anyone else in need of courseware."
- Stephen vJ."We are very happy with the product and found the service and advice from Dave to be most helpful."
- Jamie D."I really am happy with my purchased courses. I get rave reviews!"
- Kate G."When bad things happen you get an opportunity to really see who the good guys are. Dave you made my day - can't thank you enough..."
- J. Whitford"I have finally started my Excel training using your material and I am so impressed. I’m even learning things in the Foundation material although I have used Excel extensively for ±13 years (and I used Lotus 123 for about the same length of time before switching to Excel)!"
- Lydia W.