The Microsoft Excel 2010 Level 2 training is a one-day course that equips students in performing calculations on data, locating and validating data, creating styles and formatting data, filtering data, reordering and summarizing data, and combining data from multiple sources.
Completion of the course equips the participants with the following skill set:
Module 1: Perform Calculations on Data
Lab: Naming Groups of Data
Lab: Creating Formulas to Calculate Values
Lab: Summarizing Data That Meets Specific Conditions
Lab: Finding and Correcting Errors in Calculations
Module 2: Create Styles and Format Data
Lab: Defining Styles
Lab: Making Numbers Easier to Read
Lab: Changing the Appearance of Data Based on Its Value
Module 3: Focus on Specific Data by Using Filters
Lab: Limiting Data that Appears on Your Screen
Lab: Manipulating Worksheet Data
Lab: Defining Valid Sets of Values for Ranges of Cells
Module 4: Reorder and Summarize Data
Lab: Sorting Worksheet Data
Lab: Organizing Data into Levels
Lab: Looking Up Information in a Worksheet
Module 5: Combine Data from Multiple Sources
Lab: Using Workbooks as Templates for Other Workbooks
Lab: Linking to Data in Other Worksheets and Workbooks
Lab: Consolidating Multiple Sets of Data into a Single Workbook
Lab: Grouping Multiple Sets of Data
This course is beneficial for information workers who want to learn intermediate-level Excel 2010 skills.
Before attending this course, candidates must have:
I want to express the extent of my admiration and appreciation for the organization and the effort you had made for the sake to success the training I did particularly and the success to the Institute generally. What I have seen during the past few days will be an opportunity to return again and recommend the Institute among colleagues. Interacting with many tools and share information with the students. Moreover, to that the instructor provides activities and demonstrates the process for running tools in live mode.
I like Mercury Solutions, they provided me with what they promised. All communication with the staff was good. All the tactics used to impart training was good. The trainer was an awesome person. He has a vast knowledge and knows how to train a student, he taught me with all the possibilities in the security field. He knows his subject very well. I highly recommend the trainer for all the security related trainings. The company guest house and the staff was very good. The overall transportation was also good and the drivers are helpful. They also sent me for city tours which were awesome.
I am really delighted about the SQL Training course: Querying Microsoft SQL Server with Mercury Solutions. Every session was great and very valuable. Practical application made the course significantly more valuable. The thing most impressive was the way the entire programme was structured. Instructor is having great experience and diverse knowledge in SQL Server. I am looking for learning Administering Microsoft SQL Server 2014 Databases with same trainer.
I came to make resolution to learn Cisco Security, so I chose Mercury Solutions. I learnt a lot and gained a lot. Presently, I became CCNA certified and EC-Council Penetration Tester. I learnt a lot from good lectures and from trainers, and also I enjoyed a lot and I would advise all to come down and learn."
Mercury Solutions Ltd. is rated 4.6 stars by www.facebook.com/mercurysol based on 18 reviews.