Basic & Intermediate Microsoft Excel 2010

Our Basic & Intermediate Level Microsoft Excel 2010 Course is meant for beginners to get a good understanding of Excel. Our powerful training programme is designed as an interactive Hands-on session, in which our participants are  skillfully trained by using real life scenarios.

Excel 2010 – Basic Level Course is primarily designed for participants who are beginners to the excel environment and want to know how to use Excel from scratch. It is ideal for participants who need to produce reports, budgets and lists, using formula for automated calculations and the like.

• Participant will get practical tools to take away with them.
• Participants will be involved whole day with their exercises to learn tricks & tips
• Training is Realistic and relevant. We take the time to learn about you, then tailor the training to your needs.

• Explore the user interface and the ribbon
• Navigate and select in Excel
• Obtain help
• Enter
• Enter Data and Save a workbook

• Modify Fonts
• Add borders and colors  cells
• Change column width and row height
• Apply number formats
• Cell Styles
• Search for Data in a worksheet

• Create Basic Formulas
• Calculate with function
• Commonly used Function
• Copy formula and function
• Using Formula & Function
• Auto fill

• Inserting, Renaming, Deleting, Hiding  Worksheet
• Moving and copying Worksheet
• Inserting, Renaming, Deleting Rows and Columns
• Moving and copying Data’s
• Format Worksheets Tabs

• Printing Workbook
• Set Page break
• Print Area
• Inserting Header and Footer
• Freeze, split  options
• Arrange the windows
• Using Sorting, Custom AutoFill Lists

• Conditional formatting with graphics
• SmartArt graphics
• Screenshots