Microsoft Excel - Learn Excel (Beginner Level)
 
 Microsoft Excel - Learn Excel (Beginner Level)
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + .VTT | Duration: 3.5 hours | Size: 2.04 GB

 

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.

Requirements

Microsoft Excel only.

Description

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.

Who is the target audience?

Anyone who wants to learn Microsoft Excel (Beginning Level).

 

 Microsoft Excel - Learn Excel (Beginner Level)


 TO MAC USERS: If RAR password doesn't work, use this archive program: 

RAR Expander 0.8.5 Beta 4  and extract password protected files without error.


 TO WIN USERS: If RAR password doesn't work, use this archive program: 

Latest Winrar  and extract password protected files without error.


 Broknote   |  

Information
Members of Guests cannot leave comments.


SermonBox - Seasonal Collection

SermonBox - The Series Pack Collection

Top Rated News

  • Christmas Material
  • Laser Cut & Print Design Elements Bundle - ETSY
  • Daz3D - All Materials - SKU 37000-37999
  • Cgaxis - All Product - 2019 - All Retail! - UPDATED!!!
  • DigitalXModels Full Collections
  • Rampant Design Tools Full Collections Total: $4400
  • FilmLooks.Com Full Collection
  • All PixelSquid Product
  • The Pixel Lab Collection
  • Envato Elements Full Sources- 3200+ Files
  • Ui8.NET Full Sources
  • The History of The 20th Century
  • The Dover Collections
  • Snake Interiors Collections
  • Inspirational Collections
  • Veer Fancy Collections
  • All Ojo Images
  • All ZZVE Collections
  • All Sozaijiten Collections
  • All Image Broker Collections
  • Shuterstock Bundle Collections
  • Tattoo Collections
  • Blend Images Collections
  • Authors Tuorism Collections
  • Motion Mile - Big Bundle
  • PhotoBacks - All Product - 2018
  • Dekes Techniques - Photoshop & Illustrator Course - 1 to 673
Telegram GFXTRA Group
Udemy - Turkce Gorsel Ogrenme Setleri - Part 2
Videohive Wow Pack Series


rss