Najlepsze kursy internetowe w kategorii IT i oprogramowanie

[100% Off] Microsoft Excel - Learn Excel (Beginner Level)| Worth 99,99$

[100% Off] Microsoft Excel - Learn Excel (Beginner Level)| Worth 99,99$

Microsoft Excel - Learn Basics Level Quickly, Learn Formulas and Special Skills.

What Will I Learn?

  • 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".
  • 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: Using SUM formula, Using Average, Max, Min Formulas, How to use Formulas in Reports like: "Sales Report (Simple Format)", "Mark Sheet (Simple Format)", "Cricket Series Report".
  • 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)".
  • 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 "IF Function": "IF Function (Introduction)", "Simple IF (Qty Sold Example)", "Simple IF (Rate per Unit Example)", "Nested IF".
  • Students will learn Filter & Sort.
  • Students will be able to start working on Spreadsheets.
  • Students can start work on spreadsheet from the beginning.

Includes

  • 3.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion

Interactive Features 

  • 24 Downloadable resources

Aucun commentaire