Excel Basic Training in Dubai

Excel Productively

• Keyboard Shortcuts
• Mouse Shortcuts
• Excel Productivity Tips
• Making better Excel workbooks

Entering & Formatting Data, Numbers & Tables

• Typing & Formatting Data in Excel
• Impressing your boss with spreadsheet formatting
• Introduction to Excel Tables

Calculating Totals & Summaries Using Formulas

• Introduction to Formulas
• Introduction to IF formula in Excel
• Formulas for aspiring analysts & managers
• Important formulas for everyone

Conditional Formatting

• What is conditional formatting
• Introduction to Conditional Formatting
• Tips on CF
• Highlighting Duplicates

Creating Reports Quickly

• Pivot Tables – Quick & easy reporting feature of Excel
• Creating a pivot report
• How to select correct chart for any situation?
• Making a chart in Excel