"Consolidation: Consolidation (Example 1) (Simple), Consolidation (12 Months Sales Record), Consolidation (Count, Average, Max, Min)".ĭata 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". Using Formula in Excel: "Using SUM Formula (Discuss in Details)".ĭata Analyzing: "Pivot Table", "Pivot Chart", "Subtotal", "Charts", "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". Special Skills: I'll teach you about valuable Keyboard Shortcut keys like: 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". In this course you can learn the following topics: 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. Students can start work on spreadsheet from the beginning.
Students will be able to start working on Spreadsheets.Students will learn "IF Function": "IF Function (Introduction)", "Simple IF (Qty Sold Example)", "Simple IF (Rate per Unit Example)", "Nested IF".Students will learn "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".Students will learn "Data Analyzing" like: "Pivot Table", "Pivot Chart", "Subtotal", "Charts", "Consolidation (Consolidation (Example 1) (Simple), Consolidation (12 Months Sales Record), Consolidation (Count, Average, Max, Min)".
#Beginner excel 2016 training how to#
Students will learn some important Keyboard Shortcut keys like: "Inserting a Formula SUM for all required cells", "Creating 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" etc.Students will learn basics of Microsoft Excel like: "What is a Cell, Column, Row, 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".