Microsoft Excel Essential Skills

Doing It Right the First Time is one of the most important focus in this course. Once you get the essentials right, you will instantly identify and avoid the common pitfalls and costly mistakes all along in using Excel.

• Are you using Excel the right way?
• How you ensure data is entered as per required?
• How you ensure that date is entered in the required format?
• Are you spending too much time in getting your data ready?
• Are you spending too much time interpreting your numbers-what they mean? Is your data being so messy that you can’t figure out if its head or tail?
• The amount of my data is not large. Why is my workbook being so slow?

Learn to get familiar with Excel ribbons; entering and formatting data and calculating totals and summaries using formulas. Highlighting data to meet specific conditions, restricting data entries, creating reports & charts will also be covered. These topics will instantly get you going and to start applying what has been taught at work right away.

In this training you will learn:

• Getting Started
• Entering, Editing & Formatting Data and Numbers
• Calculating Totals & Summaries using Formulas
• Data Validation
• Conditional Formatting
• Managing Multiple Worksheets
• Printing: How not to have “Sexy on Spreadsheet, Ugly on Printout
• Basic Skills for Chart Makers
• Module 9: Using Excel Productively