My Excel Class

What is and why “Comprehensive MS EXCEL 2010 ONLINE video Series”

Now you can learn MS EXCEL from home with this ONLINE Series. This ONLINE Series has been designed for them who want to learn according to their free time as they are busy in other activities also like their jobs, in colleges in house hold course etc.

It saves your cost of traveling like cost of petrol on arriving coaching centers, it provides safety from the accident that may happens on the way, is saves time that can consume on arriving coaching centers and that time can be used in learning more things.

These lectures are made by a team of twenty-two persons. Half of them researched for the lectures of excel all over the world. They made their own lecture series from the best lectures they found. The necessary topics for everyone in daily use

This enthusiastic introduction provides support for MS Excel beginners and focuses on using the program immediately for maximum efficiency. With explicit information on everything from rows, columns, and cells to subtotaling, sorting, and pivot tables, this guide aims to alleviate the frustrations that come with using the program for the first time. This manual offers strategies for avoiding problems and streamlining efficiency and assists readers from start to finish, turning Excel 2010 novices into experts.

‘Compressive MS excel video ONLINE Series’ actually tells the story of what you can do with Excel from beginning to end. No bits are left out. You get the complete story of how to build a foundation of Excel skills that will enable you to accomplish any of your goals at work, home, or play. However, this ONLINE Series is not just for beginners. Because most Excel users have never been given the complete story of how Excel works, this ONLINE Series will provide an excellent foundation for beginners as well as for more advanced users.

The ONLINE Series is for Beginner Level Excel people. However…. most ONLINE Series are designed to give you just enough Excel to get by; this ONLINE Series is different. It gives you a complete foundation in Excel. How to do things and what to avoid – so that you don’t end up in a bind later on.

It is also really good for someone who has to self-study to get a better job where they rely on Excel

Along the way, you will learn 43 Excel Efficiency Rules to make your life easier in Excel.

After complete this course you will able to do all this.

1_ How Excel Is Set Up, Customize Ribbon and Toolbar

2_ Excel 2010 Keyboard Shortcuts Are Fast!

3_ Data Into Information_ SUMIFS, PivotTable, Verifying Formulas _ Data

4_ Table Format Structure For Raw Data _ Data Analysis

5_ Excel Table Feature (Excel as Database)

6 Number Formatting As Decimal, Date, Time, Percentage

7_ Excel Data Alignment_ Pitfalls & Advantageous Tricks

8_ Excel Stylistic Formatting

9_ Excel Page Setup For Reports Large or Small

10_ Excel Cell Styles and Table Styles

11_ Comprehensive Excel Formula Creation Guide (Formula Types, Elements)

12_ How Excel Formulas Are Evaluated Order of Operations Excel 1Formulas

13_ Putting Cell References In Formulas (3 Methods)

14 Percentage Increase Or Decrease Formulas

15_ Cell References in Formulas_ Relative, Absolute, Mixed

16: Relative, Absolute, Mixed Cell Ranges & Adding With Two Criteria

17_ Mixed Cell References & Orientation of Formula Inputs

18_ What If and Scenario Analysis in Excel

19_ Worksheet, WorkDVD3-D Cell References, Arrange All Feature

20_ Efficient Use Of Cell Ranges in Formulas. Insert Row, Range Updates.

21_ Benefits of Insert Function Dialog Box. FV Function Example

22_ Averaging without Zeros AVERAGEIF function or Replace Feature

23 PMT Function For Loan Payment

24_ Defined Names, Create Names From Selection & Name Manager

25_ AND and OR Criteria For Adding, Counting, and Averaging Formulas

26_ SUMPRODUCT Function (12 Examples)

27 IF function (12 Examples), AND OR functions, Nesting Ifs

28_ VLOOKUP Function & Data Validation Dropdown List (11 Examples)

29_ MATCH Function To Compare Two Lists, Tables or Databases

30_ INDEX & MATCH Function For Unusual Lookup Situations (10 Examples)

31_ ROUND Function — When & How To Use ROUND

32_ 3 Types Of Averages AVERAGE, MEDIAN, MODE, COUNTIF Functions

33_ RANK Functions _ Excel 2010 Compatibility Functions RANK.AVE RANK.EQ

34_ Goal Seek What If Analysis_2

35_ Basic Array Formulas _ Functions

36_ Custom Number Format _ the TEXT function

37_ Sort Sorting in Excel, Data Analysis (Sorting 20 Examples)

38_ Data Analysis Subtotal Feature (9 Examples)

39_ Data Analysis Pivot Tables _ Pivot Charts, PivotTables _ PivotCharts

40_ Grouping Dates in PivotTables_ Years, Months or Weeks, and more

41_ Blanks (Empty Cells) or Text in Number Fields PivotTable Trouble

42_ PivotTable Slicers, Report Filter _ Show Report Filter Pages

43_ 5 Special PivotTables __ Changing Functions and Calculations

44_Data Analysis Filter Feature_ Extract Data Based on Criteria

45_ PivotTables Treat Integer _ Decimal Numbers Differently inGrouping

46_ Advanced Filter For Extracting Records From Data Set (12 Examples)

47_ Text To Columns Last Name First Name _ Address

48_ Importing Data Into Excel From Excel, Text File, Access, Web Query

49_ Complete Lessons On Excel Charts (26 Examples)

50_ Conditional Formatting (12 Examples)

51_ Find and Replace _ Go To Special

52_ Recorded Macros

53_ Defined Name Formula Dynamic Ranges For Charts and Array Formulas

Course Curriculum

01_ How Excel Is Set Up, Customize Ribbon and Toolbar Details 00:00:00
02 Excel 2010 Keyboard Shortcuts Are Fast! Details 00:00:00
03 Data Into Information Sumifs, Pivottable, Verifying Formulas Data Details 00:00:00
04 Table Format Structure For Raw Data & Data Analysis Details 00:00:00
05 Excel Table Feature (excel As Database) Details 00:00:00
06 Number Formatting As Façade Decimal, Date, Time, Percentage Details 00:00:00
07 Excel Data Alignment Pitfalls & Advantageous Tricks Details 00:00:00
08 Excel Stylistic Formatting Details 00:00:00
09 Excel Page Setup For Reports Large Or Small Details 00:00:00
10 Excel Cell Styles And Table Styles Details 00:00:00
11 Comprehensive Excel Formula Creation Guide (formula Types, Elements Details 00:00:00
12 How Excel Formulas Are Evaluated Order Of Operations Excel 1formulas Details 00:00:00
13 Putting Cell References In Formulas (3 Methods) Details 00:00:00
14 Percentage Increase Or Decrease Formulas Details 00:00:00
15 Cell References In Formulas Relative, Absolute, Mixed Details 00:00:00
16 Relative, Absolute, Mixed Cell Ranges and Adding With Two Criteria Details 00:00:00
17 Mixed Cell References and Orientation Of Formula Inputs Details 00:00:00
18 What If And Scenario Analysis In Excel Details 00:00:00
19 Worksheet, Workbook 3-d Cell References, Arrange All Feature Details 00:00:00
20 Efficient Use Of Cell Ranges In Formulas. Insert Row, Range Updates Details 00:00:00
21 Benefits Of Insert Function Dialog Box. Fv Function Example Details 00:00:00
22 Averaging Without Zeros Averageif Function Or Replace Feature Details 00:00:00
23 Pmt Function For Loan Payment Details 00:00:00
24 Defined Names, Create Names From Selection AND Name Manager Details 00:00:00
25 And And Or Criteria For Adding, Counting, And Averaging Formulas Details 00:00:00
26 Sumproduct Function (12 Examples) Details 00:00:00
27 If Function (12 Examples), And Or Functions, Nesting Ifs Details 00:00:00
28 Vlookup Function and Data Validation Dropdown List (11 Examples)NOT Details 00:00:00
29 Match Function To Compare Two Lists, Tables Or Databases Details 00:00:00
30 Index and Match Function For Unusual Lookup Situations (10 Examples) Details 00:00:00
31_ ROUND Function — When and How To Use ROUND Details 00:00:00
32 Three Types Of Averages AVERAGE, MEDIAN, MODE, COUNTIF Functions Details 00:00:00
33 Rank Functions Excel 2010 Compatibility Functions Rank.ave Rank.eq Details 00:00:00
34 Goal Seek What If Analysis Details 00:00:00
35 Basic Array Formulas Functions Details 00:00:00
36 Custom Number Format The Text Function Details 00:00:00
37 Sort Sorting In Excel, Data Analysis (sorting 20 Examples) Details 00:00:00
38 Data Analysis Subtotal Feature (9 Examples) Details 00:00:00
39 Data Analysis Pivot Tables and Pivot Charts, PivotTables and PivotCharts Details 00:00:00
40 Grouping Dates in PivotTables_ Years, Months or Weeks, and more Details 00:00:00
41_ Blanks (Empty Cells) or Text in Number Fields PivotTable Trouble Details 00:00:00
42 PivotTable Slicers, Report Filter and Show Report Filter Pages Details 00:00:00
43 Five Special PivotTables — Changing Functions and Calculations Details 00:00:00
44; Data Analysis Filter Feature_ Extract Data Based on Criteria Details 00:00:00
45 Pivottables Treat Integer Decimal Numbers Differently Ingrouping Details 00:00:00
46 Advanced Filter For Extracting Records From Data Set (12 Examples) Details 00:00:00
47 Text To Columns Last Name First Name Address Details 00:00:00
48 Importing Data Into Excel From Excel, Text File, Access, Web Query Details 00:00:00
49 Complete Lessons On Excel Charts (26 Examples) Details 00:00:00
50 Conditional Formatting (12 Examples) Details 00:00:00
51 Find And Replace Go To Special Details 00:00:00
52 Recorded Macros Details 00:00:00
53 Defined Name Formula Dynamic Ranges For Charts And Array Formulas Details 00:00:00

Course Reviews

N.A

ratings
  • 1 stars0
  • 2 stars0
  • 3 stars0
  • 4 stars0
  • 5 stars0

No Reviews found for this course.