Microsoft Excel Masterclass- From Beginner to Expert

Microsoft Excel Masterclass- From Beginner to Expert

COURSE DESCRIPTION:

• 16 to 24 Hours
• Knowing Excel and Start Working
• Cell Reference (Absolute Vs Relative)
• Lookup and References
• Working with Date
• Data Summarizing Techniques
• Most Using Essential Functions
• Bullet-Proofing Your Reports and Excel Workbook
• Describe Your Data Using PivotTable
• with Slicers and PivotChart
• Decorate Your Report Using Advanced
• Conditional Formatting
• Error Handling and Cleaning Data
• Data Consolidation
• Dynamic Graphical Presentation
• Some Essential Shortcut Keys
• Dashboard Link
• Power pivot