Microsoft Office Excel 2010 contains powerful tools to help you analyze, manage, and share critical business data. You can also work with industry-standard eXtensible Markup Language (XML) data to make it easier to connect to business processes.
This training combines and covers materials from the following courses:
Topic 3B: Troubleshoot Invalid Data and Formula Errors
Topic 3C: Watch and Evaluate Formulas
Topic 3D: Create a Data List Outline
Lesson 4: Analyzing Data
Topic 4A: Create a Trendline
Topic 4B: Create Sparklines
Topic 4C: Create Scenarios
Topic 4D: Perform a What-If Analysis
Topic 4E: Perform a Statistical Analysis with the Analysis ToolPak
Lesson 5: Working with Multiple Workbooks
Topic 5A: Create a Workspace
Topic 5B: Consolidate Data
Topic 5C: Link Cells in Different Workbooks
Topic 5D: Edit Links
Lesson 6: Importing and Exporting Data
Topic 6A: Export Excel Data
Topic 6B: Import a Delimited Text File
Lesson 7: Integrating Excel Data with the Web
Topic 7A: Publish a Worksheet to the Web
Topic 7B: Import Data from the Web
Topic 7C: Create a Web Query
Lesson 8: Structuring Workbooks with XML
Topic 8A: Develop XML Maps
Topic 8B: Import and Export XML Data
Why You Should Take the Excel 2010
Benefits of Certification
For IT professionals, certification is a third party validation of your skills, that helps distinguish you from your peers. Beyond demonstrating a level of competency and proficiency, certification proves that you are committed to your cause and that you've invested the time and money to prove it. Holding a certification also makes you a more valuable employee, and often results in raises, promotions, and a better career.
For organizations, certifications identify the credentials that can be used to hire the right employee. Having certified employees also increases sales for the organization by proving to prospective clients that the organization has the skills to support its claims.
For the ultimate and complete, all inclusive learning experience, please see our Las Vegas Boot Camp Experience.
We take care of all logistics for you, so you can concentrate on learning, acquiring skills and getting certified. We provide instructors, books, computer equipment and software in a comfortable learning environment for most training.
Do you have the right background for Excel 2010?
We ensure your success by asking all students to take a FREE Skill Assessment test. These short, instructor-written tests are an objective measure of your current skills that help us determine whether or not you will be able to meet your goals by attending this course at your current skill level. If we determine that you need additional preparation or training in order to gain the most value from this course, we will tell you so right away. We will also recommend cost-effective solutions that you can use to get ready for the course.
Our required skill-assessments ensure that:
All students in the class are at a comparable skill level, so the class can run smoothly without beginners slowing down the class for everyone else.
NetCom students enjoy one of the industry's highest success rates, and pass rates when a certification exam is involved.
We stay committed to providing you real value. Again, your success is paramount; we will register you only if you have the skills to succeed.
This assessment is for your benefit and best taken without any preparation or reference materials, so your skills can be objectively measured.
This course was designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, create Pivot Tables and Pivot Charts, incorporate multiple data sources, and import and export data.
As a recognition for training excellence, NetCom Learning was chosen by Microsoft as the 2007 Worldwide Learning Solutions Partner of the year out of 1400 training companies.
In addition, we have won numerous other training awards for quality and customer satisfaction by CompTIA, EC-Council and other vendors. We are simply passionate about learning and achieving the highest customer satisfaction in your learning experience!
See the training value proposition below:
Why Microsoft - Application Training at NetCom?
NetCom Learning is a Microsoft Gold Certified Partner for Learning Solutions (CPLS). CPLS is the premier training channel and delivery mechanism for Microsoft training content. As such, we are one of the only authorized training organizations that can market Microsoft training services and the only ones with access to Microsoft's Official Curriculum and latest technologies.
Microsoft Certified Partner for Learning Solutions Value Proposition:
Microsoft Certified Partner for Learning Solutions
Non-authorized Training Center
Only MCT (Microsoft Certified Trainers) are authorized to teach the class
Non MCT can teach the course
Taught using Microsoft Authorized Courseware (MOC), includes free evaluation software and online training
Do not have access to official courseware
Partners adhere to stringent Microsoft designated lab requirements
Computer and lab equipment may not be up to requirements of course
Successful candidates are awarded Certificate of Completion directly from Microsoft for most of the courses
Not authorized to issue Certificate of Completion
Software Assurance Vouchers can only be redeemed at a CPLS
Cannot redeem Software Assurance Vouchers from Microsoft
NetCom Learning is a Microsoft Gold Certified Partner for Learning Solutions (CPLS), Cisco Learning Partner, CompTIA Platinum Partner, EC-Council Accredited Training Center, Adobe Authorized Training Center, Autodesk Authorized Training Center and many others. We are proud to offer the highest quality, authorized training solutions from our many partners for our customers.
- Phenom in the IT industry, earned her first Microsoft certification at age 15. - B.B.A in Management along with numerous Cisco, Microsoft, and CompTIA certifications. - Database designer and network administrator background.
Amanda is a phenom in the IT industry. The daughter of NetCom Learning Instructor and Subject Matter Expert, Michael Govinda, Amanda was a Microsoft Certified Systems Engineer at age 15 and began earning Cisco credentials at 17. She also holds a B.B.A in Management and worked as a database designer and network administrator in the IT department of a top New York City publishing firm.
Amanda currently teaches CompTIA A+, Network+, and Security+, as well as Cisco CCNA and CCNA Voice courses at NetCom Learning, garnering much acclaim from her students who enjoy a close-to-perfect pass rate on their certification exams. Amanda is a certified trainer for Cisco and CompTIA, and holds numerous technical certifications including Cisco Certified Network Associate-Security, CCSI, CCNP, CCVP, MCSE, CompTIA A+, CompTIA Net+, and CompTIA Security+.
- Highly-skilled in graphics and web software including Adobe CS3, CS4 & CS5 Photoshop, Dreamweaver, Illustrator, InDesign, Captivate, Acrobat and Quark; - Expert in Microsoft Office, including Excel, Word and PowerPoint. Licensed Application Instructor and Microsoft Certified Trainer since 2000. - Over 20 years of experience as Creative Director for multinational corporations such as McCann Erickson, Lintas, and Publicis.
Carmille has been a Licensed Application Instructor and Microsoft Certified Trainer for years. She specializes in web development, business productivity and digital media applications such as SharePoint, Quark and the Adobe Creative Suite as well as numerous programming languages including XML, XHMTL, HTML and CSS.
Carmille is passionate about educating and has a unique talent for making complex design and development principals seem "easy" to students from all levels of expertise. She currently teaches Adobe Graphic and Web Designer, Microsoft Office Specialist, SharePoint End User and the acclaimed Website Development Professional courses at NetCom Learning. Her 20+ years of experience as Creative Director for multinational corporations bring a special and innovative approach to her classes at NetCom Learning.
- Expert in Microsoft Office applications such as Excel, Word, PowerPoint, Outlook, Project, Visio, and Access as well as Adobe Graphic and Web Designer (InDesign, Acrobat, Photoshop, Illustrator, Dreamweaver and Flash Catalyst) - Holds an A.A.S in Graphic Design as well as various Awards and Affiliations, including MCT, MCP, MCAS, and Office 2007 Master. - Senior Lead Trainer for over 10 years.
Charles is a Technical Trainer & Instructional Designer for over 10 years. He is a Microsoft Certified Trainer and dedicates himself to Microsoft Office applications such as Excel, Word, PowerPoint, Outlook, Project, Visio, and Access. He is also an Adobe specialist and holds a degree in Graphic Design.
Charles is well known for his high evaluation scores, achieving 8.75 out of 9 on a regular basis, teaching in one-on-one, instructor-led, and web-based environments; one of the reasons for his high evaluation is his expertise in increasing personnel performance by developing and implementing programs constructed from the job task analysis process. Charles currently teaches Adobe Graphic and Web Designer, and Microsoft Office Specialist courses at NetCom Learning.
- Designs and architects Microsoft IT solutions since the early 1990s. - Hands-on experience in multiple Microsoft Dynamics products including CRM, GP, SL, AX and NAV since 2004. - Taught over 250 courses at NetCom Learning.
Ignacio is a Senior Solutions Architect, Civil Engineer and Certified Expert Trainer. He has been designing and architecting Microsoft IT solutions since the early 1990s, and has extensive experience developing scalable and high performance integration solutions. In 2004, Ignacio expanded into business management and accounting software as well, where he gained hands-on experience in many Microsoft Dynamics products including CRM, GP, SL, AX and NAV.
Ignacio holds a library of industry-wide certifications from Microsoft and other leading IT vendors. He has taught over 250 courses at NetCom Learning and is revered by students for his wide-ranging IT expertise.
- Microsoft Office Specialist with over 14 years of training experience. - Expert in the IT industry, working in the IT field since 1986. - Highly rated instructor with an all-time average evaluation score of 8.7 out of 9.
Paul is Subject Matter Expert specializing in the Microsoft Office Suite and SharePoint end-user technologies with more than 25 years of practical experience in the IT industry. He is also a Microsoft Certified Trainer (MCT) with over 14 years of training experience.
A sought-after instructor and eternal favorite among students, his instructor feedback scores are among the industry's highest at 8.7 out of 9.0. As a trainer, his knowledge and passion for the subject matter as well as his personable nature, excellent communications skills and sense of humor are implicit in every class. NetCom Learning is proud to have Paul on our roster of IT geniuses.
- More than 25 years of know-how in the IT industry, including Product Engineering at Panasonic. - CompTIA and Microsoft Subject Matter Expert with over 9 certifications. - Subject Matter Expert at NetCom Learning since 2006, where has trained more than 1300 students.
Richard Brown is a Microsoft Certified Trainer and Subject Matter Expert specializing in Microsoft and CompTIA. Richard has more than 25 years of experience in the IT industry with a successful career as Product and Network Engineer in Fortune 500 companies such as Panasonic.
A sought-after enterprise technician, Richard is a natural educator teaching beginner to advanced Server 2008 R2 and SharePoint 2010 as well as A+ and Network+ classes. Richard has trained more than 1300 students at NetCom Learning with an average evaluation score of 8.6 out of 9 since 2006.
- Specialist in Microsoft Office applications such as Excel, Word, PowerPoint, Outlook, Project, FrontPage, and Access. Microsoft Office Specialist and Microsoft Office Master. - Degree in Information and Business Technology from South Bank University - United Kingdom. - Business professional since 1992 and Information Technology instructor since 2003.
Vijayanti has been a business professional for over 20 years and an Information Technology instructor for over 10 years. She is a Microsoft Office Specialist and a Microsoft Office Master with a degree in Information and Business Technology from South Bank University in the UK.
Vijayanti also trained and qualified as an Information and Communications Technology Teacher. She has been working at Netcom Learning as a Software Instructor with an extensive know-how in Microsoft Office Suites.
A belated "thank you!" for the Excel training program that took place here at our company. From start to finish, you were all organized, prepared, and professional. I thought Charlie Williams did a great job facilitating, and I received a lot of positive feedback from participants. Please know how much I appreciate your help in coordinating this class. It was a pleasure working with you!
I would recommend NetCom because I thought that the instructors were knowledgeable and patient. I liked that the instructors asked the class for real examples of their work. I liked that the classes were small.
I would recommend NetCom because of the care they take in making certain you learn. The class size was nice and we were able to receive individualized attention thereby promoting deeper absorption of the materials. The place is neat, clean and friendly. They were very hospitable to the students as well.
I would absolutely recommend NetCom to a friend. Both Robert and Octavia are wonderful, and the instructors are a class act.
Octavia is a true gem of a person. NetCom is very fortunate to have her as the "front house" person. She is extremely kind, professional, patient, and efficient. And Robert took a great deal of time with me when I first inquired about classes; he explained the different types of classes, and he went over the curriculum in an in-depth manner.
Hearst Corporation achieves company-wide efficiencies with software migration solution
Published On: 7 September 2012
Customer: Hearst Corporation
Location: New York, NY, US
Hearst Magazines is a unit of Hearst Corporation (www.hearst.com), and one of the world's largest publishers of monthly magazines, with a total of 18 U.S. titles and 145 international editions. Hearst reaches more adults than any other publisher of monthly magazines (76.3 million according to MRI, spring 2005). The company also publishes 19 magazines in the United Kingdom through its wholly owned subsidiary, The National Magazine Company Limited.
Heart Corporation is involved in one of the fastest moving industries in the world. The organization needs to be able to respond quickly and accurately to business needs. The company has been utilizing Office 2003 and Windows XP on a network basis for their employees for many years. It has become necessary to upgrade their networked software solutions to take advantage of the increased network capabilities and faster speeds of both Office 2010 and Windows 7. Updating the software to current software releases will provide employees and the Hearst IT department with improved resources to do their jobs. This will result in company wide work efficiencies. Hearst Corporation needed in-house training to affect the software migration, training that would meet the needs of all levels of the organization. Management requested that the training materials be tailored to how the software would be used in house. NetCom Learning proposed a customized solution to meet customer needs.
Using coursework from the NetCom Office 2010 Class and the Windows 7 class, NetCom Learning created a combined customized solution for the Hearst Corporation including the preparation of custom written training materials. The training was provided over a six month period. The creation of the customized training package involved an on-site needs assessment. Training involved the entire company and was delivered department by department. Hands on training sessions were offered for both Office 2010 and Windows 7. One-on-one training sessions were provided to meet the specific management requirements. The training sessions were completed in six months and involved over 1000 Hearst employees.
The training provided by NetCom Learnings instructors allowed Hearst Corporation to migrate to the updated Windows 7 and Office 2010 software with a minimum of disruption. The six month training sessions allowed employees at all levels the hands on training they needed to feel comfortable with the new software. The company reports that staff is using the full capabilities of the software including PowerPoint, Outlook, Excel, and the network and communication capabilities in Windows 7. Hearst Corporation has noted work efficiencies across the board since the successful migration to the new software.
Customized Training helps improve Business Productivity.
Published On: 6 April 2006
Customer: Whole Foods Market
Location: New York, NY, US
Founded in 1980 as one small store in Austin, Texas, Whole Foods Market® is now the world's leading retailer of natural and organic foods, with 183 stores in North America and the United Kingdom. To date Whole Foods Market remains uniquely mission driven: We're highly selective about what we sell, dedicated to stringent Quality Standards, and committed to sustainable agriculture.
Whole Foods uses Excel for a wide variety of purposes. Each department leader in Whole Foods must track many financial metrices on a daily basis. Whole Foods felt that their was a huge gap in the ability of team members using Excel. Some knew how to create graph and extrapolate data, while others were unsure of what right click meant.
NetCom customized a training program to address the broad spectrum of skills. Through a tailored class delivery format, Whole Foods was able to maximize the ROI on their training investment. By monitoring the feedback from participants, NetCom then suggested further modifications to meet the skill levels of the students.
Whole Foods was pleased to see that their Team Members walked away with practical knowledge of Excel. In addition to usable software skills, they were also inspired to seek out advanced uses of the program. Not only did the customized training helped achieve a high return on investment, it also helped improve day to day productivity.
NetCom Learning trains American multinational banking corporation and provider of financial services
Published On: 4 October 2012
Customer: Anonymous Client
Location: New York, NY, US
In the fast paced world of investment banking and financial services, it is essential that all employees be up to speed on the software used in the business as quickly as possible. This applies to current employees, new hires and interns. The client requires employee training on a wide scale to quickly improve current employee skill levels, and bring new hires and interns to the required competency level in technical applications and installed office software including Microsoft Office 2007.
A customized training solution was developed to meet the educational needs of current employees, new hires and interns. NetCom Learning devised customized learning solution for the client involving several trainers and offsite training sessions in New York and Delaware. With Microsoft Corporations support, NetCom Learning provided offsite training in Microsoft Headquarters in New York.
The major benefit to the client was in terms of cost savings in employee time. The advanced training in Microsoft Office 2007 applications, allowed all employees involved in the training to acquire advanced skills allowing them to save an hour or more each day in their daily business tasks. This time savings per employee resulted in a quantified savings of 20 hours a month that employees were able to move on to other tasks in a time efficient manner, accomplishing more work in the same time frame. This translates to a total of 4000 hours of saved time which can be used for new projects. In a monetary approach this could look like two years of wages, saving the company approximately one half million each month.
NetCom’s classroom training ensures that you have state-of-the-art tools, techniques and practices you need to succeed on the job. Our instructors are active practitioners and true masters in their fields. With convenient classes at multiple learning centers across the US, you never have to go far to get ahead.
NetCom’s premium Live Online Training (we call it LOT) is the ultimate in convenience and cost-effectiveness. LOT combines interactive video instruction via the latest web conference technology, and post-class access to learning labs for a best-in-class learning experience. Learn more about LOT
NetCom’s intensive boot camps are designed to advance your skills in the shortest possible amount of time and get you certified. Boot camps go at a faster pace and often run for longer days, so you must have some level of subject matter experience before enrolling. Boot camps have mandatory assessment tests to ensure no one will slow down the class for other students. Learn more about Boot Camps
With NetCom’s private training programs, you decide where and when courses are held. Tailor the training to reflect your industry, corporate culture, goals and schedule. You pick the course content, length of training and instructional technique. Save money by doing bulk customized training. Learn more about Private Onsite Training
NetCom’s private 1-on-1 training focuses on the highest quality training possible. You get individualized, full attention from the instructor and you decide where and when courses are held. The training is custom tailored to reflect your industry, corporate culture, goals and schedule. You pick the course content, length of training and instructional technique. Learn more about Private 1-on-1 Training