Excel 2016 Tutorial / 2016 Excel Course

Пройдите 2016 курс Excel

Note : This is not a Microsoft Application this is just a Excel 2016 Tutorial

By the using of this application you may learn the following:

** Basic of Excel – 2016

-1 Introduction of Excel 2016

-2 Data Auto Fill

-Auto Fit the Data

-Fibonacci Sequence

-5 Custom Lists

-6 Comments

-7 Hide Columns or Rows

-8 Skip Blanks

-9 Transpose

-10 Union and Intersect

-11 Flash Fill

-12 Move Columns

**Formulas and Functions

-1 Subtract

-2 Multiply

-3 Divide

-4 Square Root

-5 Percentage

-6 Names in Formulas

-7 Dynamic Named Range

-8 Paste Options

-9 Status Bar

-10 Quick Operations

-11 Not Equal To

-12 Cm to inches

-13 Discount

(Note App have More Formulas)

**Ribbon

-Quick Access Toolbar

-Developer Tab

**Workbook

-Save in 97-2003 Format

-View Multiple Workbooks

-Auto Recover

**Worksheet

-1 Worksheets

-2 Zoom in and Zoom Out

-3 Split Worksheet

-4 Freeze Panes

-5 Group Worksheets

-6 Consolidate

-7 View Multiple Worksheets

-8 Get Sheet Name

-9 Spell Check

**Format Cells

-Format Cells

-Decimal Places

-Date and Time Formats

-Fractions

-Currency vs Accounting

-Text to Numbers

-Numbers to Text

-Custom Number Format

-Format Painter

-Cell Styles

-Themes

-Wrap Text

-Merge Cells

-Strikethrough

-Superscript and Subscript

-Check Mark

And many more with Excel VBA tutorial