The Microsoft Excel 2010 Level 2 training is a one-day course that equips students in analyzing alternative data sets, creating dynamic worksheets by using PivotTables, creating charts and graphics, automating repetitive tasks, working with other Microsoft Office programs, and collaborating on workbooks.
Completion of the course equips the participants with the following skill set:
Module 1: Analyse Alternative Data Sets
Lab: Defining an Alternative Data Set
Lab: Defining Multiple Alternative Data Sets
Lab: Varying Your Data to Get a Desired Result by Using Goal Seek
Lab: Finding Optimal Solutions by Using Solver
Lab: Analysing Data by Using Descriptive Statistics
Module 2: Create Dynamic Worksheets by Using PivotTables
Lab: Analysing Data Dynamically by Using PivotTables
Lab: Filtering, Showing, and Hiding PivotTable Data
Lab: Editing PivotTables
Lab: Formatting PivotTables
Lab: Creating PivotTables from External Data
Module 3: Create Charts and Graphics
Lab: Creating Charts
Lab: Customizing the Appearance of Charts
Lab: Finding Trends in Your Data
Lab: Summarizing Your Data by Using Sparklines
Lab: Creating Dynamic Charts by Using PivotCharts
Lab: Creating Diagrams by Using SmartArt
Lab: Creating Shapes and Mathematical Equations
Module 4: Automate Repetitive Tasks by Using Macros
Lab: Enabling and Examining Macros
Lab: Creating and Modifying Macros
Lab: Running Macros When a Button Is Clicked
Lab: Running Macros When a Workbook Is Opened
Module 5: Work with Other Microsoft Office Programs
Lab: Including Office Documents in Workbooks
Lab: Storing Workbooks as Parts of Other Office Documents
Lab: Creating Hyperlinks
Lab: Pasting Charts into Other Documents
Module 6: Collaborate with Colleagues
Lab: Sharing Workbooks
Lab: Managing Comments
Lab: Tracking and Managing Colleagues' Changes
Lab: Protecting Workbooks and Worksheets
Lab: Authenticating Workbooks
Lab: Saving Workbooks for the Web
This course is beneficial for information workers who want to learn advanced-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.