[GET] Udemy - Excel - Basic Excel Course

Excel - Basic Excel Course

This MS excel training tutorial teaches you basics of MS Excel 2010 using practical excel case studies

 

FREE UDEMY COUPON CODE:

https://www.udemy.com/excel-function/?couponCode=tintin19

by edu CBA

As the industry standard for spreadsheet software, Microsoft Excel comes with many advantages to the new user. This awesome Excel 2010 for Beginners online course on MS Excel deals with the tools, techniques and functions of Excel 2010. This course will introduce you to different powerful tools of excel 2010.
The “Excel 2010 Beginner: ZERO to HERO in just 1 day“ course content is developed based on feedback from students and professionals with a blend of our years of experience in providing excel training. This program is suitable for housewives, entrepreneurs, marketing and sale professionals, students, accountants and finance & non-finance professionals and anyone looking to learn excel 2010. The objective of the course is to increase the productivity and efficiency by introducing participants to numerous tools and techniques available in Excel.
This Excel 2010 Beginner course is hands on practical course. While instructing, the trainer actually performs the operations over an excel sheet for a better learning. Completion of this course, a participant will be capable of working on an excel sheet using different tools and techniques.
This Excel 2010 Beginner Course has 80 lectures with 6 hours of videos along with 27 quizzes. We have provided 100+ working files for participants to download along with SUBTITLE. We have also shown functions in excel 2003 and 2007 to compare with excel 2010. Take this Excel 2010 Beginner course and learn how to use Microsoft Excel with numerous tools and techniques.


Note: Microsoft Excel 2010 Beginner (this course) is also a part of Excel - Excel Course (Basic and Advanced). If you are looking for both Beginner and Advanced Excel 2010, Please go for Comprehensive program.


SECTION 1: Excel for Beginners - Overview

    04:42
    Lecture 1:
    Excel 2010 Beginner - Overview

SECTION 2: Excel 2010: Getting Started

    10:12
    Lecture 2:
    Getting Started - Ribbons & Quick...
    11:08
    Lecture 3:
    Getting Started - Surfing Excel & HELP...
    4 questions
    Quiz 1:
    Getting Started Quiz

SECTION 3: Case Study

    02:00
    Lecture 4:
    Excel Case Study
    2 questions
    Quiz 2:
    Excel Case Study Quiz
    08:56
    Lecture 5:
    Data Entry in Excel
    4 questions
    Quiz 3:
    Data Entry Quiz
    Text
    Lecture 6:
    Populating the case study - Download...
    07:42
    Lecture 7:
    Populating the Case Study in Excel
    1 question
    Quiz 4:
    Populating the Case Study in Excel Quiz

SECTION 4: Calculations

    Text
    Lecture 8:
    Calculations Working Files - Download...
    07:29
    Lecture 9:
    Calculations - Addition Subtract Multiply...
    2 questions
    Quiz 5:
    Calculations Quiz

SECTION 5: Formulas

    Text
    Lecture 10:
    Formulas Working Files - Download...
    09:58
    Lecture 11:
    Formulas - SUM MAX MIN AVERAGE
    3 questions
    Quiz 6:
    Formulas Quiz

SECTION 6: Formatting

    Text
    Lecture 12:
    Formatting - Number Formats Working...
    08:30
    Lecture 13:
    Formatting - Number Formats
    3 questions
    Quiz 7:
    Formatting - Number Formatting Quiz
    Text
    Lecture 14:
    Formatting (Table) Working Files -...
    07:37
    Lecture 15:
    Formatting - Table Formats
    2 questions
    Quiz 8:
    Formatting - Table Format Quiz

SECTION 7: Updating a Calculation

    Text
    Lecture 16:
    Updating a Calculation Working Files -...
    02:41
    Lecture 17:
    Updating a Calculation
    2 questions
    Quiz 9:
    Updating a Calculation Quiz

SECTION 8: Percentages & Absolute References

    Text
    Lecture 18:
    Working Files - Download These First
    09:19
    Lecture 19:
    Percentages & Absolute References
    1 question
    Quiz 10:
    Percentage and Absolute References Quiz

SECTION 9: Conditional Formatting

    Text
    Lecture 20:
    Conditional Formatting Working Files -...
    08:28
    Lecture 21:
    Conditional Formatting
    2 questions
    Quiz 11:
    Conditional Formatting Quiz

SECTION 10: IF Function

    Text
    Lecture 22:
    IF Working Files - Download These First
    09:58
    Lecture 23:
    IF function
    1 question
    Quiz 12:
    IF Function Quiz

SECTION 11: COUNTIF and SUMIF

    Text
    Lecture 24:
    COUNTIF Working Files - Download These First
    04:18
    Lecture 25:
    COUNTIF Function
    2 questions
    Quiz 13:
    COUNT IF Quiz
    Text
    Lecture 26:
    SUMIF Working Files - Download These First
    08:22
    Lecture 27:
    SUMIF Function
    2 questions
    Quiz 14:
    SUMIF Function Quiz

SECTION 12: Charts and Graphs

    Text
    Lecture 28:
    Charts and Graphs Working Files -...
    08:32
    Lecture 29:
    Creating Charts and Graphs
    1 question
    Quiz 15:
    Charts and Graphs Quiz I
    Text
    Lecture 30:
    Pie Charts Working Files - Download...
    11:24
    Lecture 31:
    Create Pie Charts
    1 question
    Quiz 16:
    Charts and Graphs Quiz II

SECTION 13: Sorts and Filters

    Text
    Lecture 32:
    Sorts Working Files - Download These First
    04:54
    Lecture 33:
    Sorts
    1 question
    Quiz 17:
    SORT Quiz
    Text
    Lecture 34:
    Filters Working Files - Download These First
    04:50
    Lecture 35:
    Filters
    1 question
    Quiz 18:
    Filter Quiz

SECTION 14: Pivot Tables

    Text
    Lecture 36:
    Pivot Table Working Files - Download...
    11:53
    Lecture 37:
    Pivot Tables
    4 questions
    Quiz 19:
    Pivot Table Quiz

SECTION 15: Freeze and Split

    Text
    Lecture 38:
    Freeze and Split Working Files -...
    06:21
    Lecture 39:
    Freeze and Split
    1 question
    Quiz 20:
    Freeze and Split Quiz

SECTION 16: Presentation

    Text
    Lecture 40:
    Presentation I Working Files - Download...
    05:42
    Lecture 41:
    Presentation - Table Formats
    2 questions
    Quiz 21:
    Presentation Quiz I
    Text
    Lecture 42:
    Presentation II Working Files -...
    05:40
    Lecture 43:
    Presentation - Indents and Formatting Charts
    3 questions
    Quiz 22:
    Presentation Quiz II

SECTION 17: Print

    07:29
    Lecture 44:
    Printing the Worksheet
    2 questions
    Quiz 23:
    Printing the Worksheet Quiz
    06:53
    Lecture 45:
    Printing - Headers and Titles
    2 questions
    Quiz 24:
    Print Quiz

SECTION 18: Shortcuts

    Text
    Lecture 46:
    Excel Shortcuts Working Files -...
    14:48
    Lecture 47:
    Shortcuts - Formatting and Navigation
    1 question
    Quiz 25:
    Shortcut Part I Quiz
    10:46
    Lecture 48:
    Shortcuts - Selection, Data and Formula
    1 question
    Quiz 26:
    Shortcut Part II Quiz

SECTION 19: Common Errors

    04:47
    Lecture 49:
    Common Errors
    3 questions
    Quiz 27:
    Common Error Quiz

SECTION 20: Concluding Lecture

    02:32
    Lecture 50:
    Concluding Lecture