In this course I'll teach you Basics level of Microsoft Excel, and important is that you will learn quickly and in details and can save your much time.
In this course you can learn the following topics:
Introduction: "What is a Cell, What is a Column, What is a Row, What is a Range", "Changing Font Size, Font Color, Fill Color, Border, Alignment (Left, Center, Right), Wrap Text, Merge & Center etc.", "How to Insert a Comment", "How to add/Delete Column, Row".
Special Skills: I'll teach you about valuable Keyboard Shortcut keys like:
"Inserting a Formula SUM for all required cells", "Creating a Chart from Selected Data", "Numbers in Comma Format, Numbers in Currency Format, Numbers in Percentage Format", "Current Date, Current Time", "Select Entire Row, Column, Hide Rows, Columns", "New Line inside a Cell", "Save Active File, Save As Active File", "Insert New Worksheet", "Move Forward between Worksheets in same file / Move Back between Worksheets in same file".
Using Formula in Excel: "Using SUM Formula (Discuss in Details)".
Data Analyzing: "Pivot Table", "Pivot Chart", "Subtotal", "Charts",
"Consolidation: Consolidation (Example 1) (Simple), Consolidation (12 Months Sales Record), Consolidation (Count, Average, Max, Min)".
Data Validation: "Data Validation - Cricket Match ScoreCard", Data Validation - Date of Current Year", "Data Validation - Numeric Values", "Data Validation - Entering Supplier Names", "Data Validation - Entering Item Names".
Inserting Formulas in Simple Reports: "Sales Report (Simple Format)", "Mark Sheet (Simple Format)", "Cricket Series Report".
IF Function: "IF Function (Introduction)", "Simple IF (Qty Sold Example)", "Simple IF (Rate per Unit Example)", "Nested IF".
Filter & Sort: "Filter", "Sort".
So please enroll this course and improve your Microsoft Excel Skills. Please recommend to your friends and colleague.