Microsoft Excel



Building Basic Formulas in Excel 2016
                                     This chapter from Excel 2016 Formulas and Functions takes you through some formula basics, including constructing simple arithmetic and text formulas, understanding the all-important topic of operator precedence, copying and moving worksheet formulas, and making formulas easier to build and read by taking advantage of range names.





Predictive Analytics with Microsoft Excel: Working with Seasonal Time Series                                          This chapter from More Predictive Analytics: Microsoft Excel takes a look at how to decompose a time series so that you can see how its seasonality operates apart from its trend (if any).


Video: Predictive Analytics with Excel: Smoothing Constant and Exponentiation
                               In this excerpt from Predictive Analytics with Excel LiveLessons (Video Training), Downloadable Video: Exponential Smoothing and Autoregression, Conrad Carlberg takes a look a exponential smoothing. 

Ms Excel Version 

Microsoft Windows

Excel 2.0 is the first version of Excel for Intel platform. There never was an Excel 1.0 for DOS or Windows.

Excel 2.0 (1987)
              The first Windows version was labeled "2" to correspond to the Mac version. This included a run-time version of Windows. 

Excel 3.0 (1990)
             Included toolbars, drawing capabilities, outlining, add-in support, 3D charts, and many more new features.

Excel 4.0 (1992)
             Introduced auto-fill.Also,an easter egg in Excel 4.0 reveals a hidden animation of a dancing set of numbers 1 through 3, representing Lotus 1-2-3, which was then crushed by an Excel logo.

Excel 5.0 (1993)

Microsoft Windows

Excel 2.0 is the first version of Excel for Intel platform. There never was an Excel 1.0 for DOS or Windows.

Excel 2.0 (1987)

The first Windows version was labeled "2" to correspond to the Mac version. This included a run-time version of Windows.

Excel 3.0 (1990)

Included toolbars, drawing capabilities, outlining, add-in support, 3D charts, and many more new features.

Excel 4.0 (1992)

Introduced auto-fill.
Also, an easter egg in Excel 4.0 reveals a hidden animation of a dancing set of numbers 1 through 3, representing Lotus 1-2-3, which was then crushed by an Excel logo.

Excel 5.0 (1993)

Excel 97 (v8.0)

Excel 2000 (v9.0)

Excel 2002 (v10.0)

Excel 2007 (v12.0)

Excel 2010 (v14.0)

Excel 2013 (v15.0)

Excel 2016 (v16.0)

Included in Office 2016, along with a lot of new tools included in this release:
  1. Power Query integration
  2. Read-only mode for Excel
  3. Keyboard access for Pivot Tables and Slicers in Excel
  4. New Chart Types
  5. Quick data linking in Visio
  6. Excel forecasting functions
  7. Support for multi-selection of Slicer items using touch
  8. Time grouping and Pivot Chart Drill Down
  9. Excel data cards


Topic List 

(Click On Any Lesson and Watch Tutorial)

  1. start microsoft excel
  2. Tour of Excel Workspace
  3. The Work Book Window
  4. Resizing the Work Book Window
  5. Working With Quick access Tool Bar
  6. Working With Toll Bar
  7. Exiting Microsoft excel
  8. Cearting New File And TAmplet 
  9. Markin Selections
  10. Entering Data



0 comments:

Post a Comment

Thanks For Feedback

 
Top