Intermediate MS Excel هذه الدورة تدرس باللغة الإنجليزية

تفاصيل الدورة

• Spreadsheets & Its Terminology
• Understanding Excel Interface
• Entering & Editing Data
• Opening, Closing & Saving Workbook
• Prevent Data Loss in the Event of System Crash
• Didn't Save a Workbook? Don't Worry - Recover Unsaved
• Workbooks

• Difference between a Formula & Function
• Learning the Core Excel Functions
• Nesting Functions
• Understanding Relative, Absolute & Mixed Referencing
• Defining Names and Using them in Functions

• Useful Formatting Tools
• Using Special Number Formatting
• Applying Predefined Styles & Themes
• Inserting Pictures, Objects & Smart Art

• The Science of Dates & Time in Excel
• Useful Date & Time Functions

• Quick Data Selection Techniques - Use of Ctrl & Shift Keys
• Quick Data Entry Techniques
• Using the Fill Handle
• Accelerating Copy Paste
• Learning Sorting & Filtering

• Highlighting Cells based on Different Criteria

• Exploring the Power of Excel Tables
• Creating Dynamic Ranges with Tables

• Dos & DONTs of Excel Charting
• Creating a Chart in no Time!
• Useful Charting Techniques

• Learning the Powerful IF Function
• Evaluating Multiple Results with Nested IF
• Learning the All Important VLOOKUP & Its
• Limitations
• Analyzing Data with Criteria - SUMIF Family
• Functions

• Understanding the Power of Pivot Tables - An
• Excellent Reporting Tool!
• How to Create a Pivot Table
• How to Generate Reports from Pivot Tables
• Managing & Presenting Pivot Table

• Linking Worksheets & Workbooks
• Performing Calculations across Worksheets with
• 3D Formula
• Creating a Hyperlink
• Printing Fundamentals
• Protecting Workbook with Password
• Restrict Editing Data