Top 10 New Features of Excel 2016

Excel 2016 was released a few months age and considering how much we love Excel we thought it only right to give you the lowdown on our favourite new features in Microsoft's latest version of the popular spread sheeting programme.

1. Tell me what you want to do ?

The "tell me" box is one of the most obvious new arrivals to the Excel party and quite frankly it's a shame it wasn't around in th e2007 edition when the menu ribbon was initially reduced ( remember how hard it was to find our favourite tools?). The tell me box is essentially a search function thhat lists fuctions and operations matchingg your search terms. A really handy shortcut to get you where you want to go! On top of this there's smar look-up which will use the internet to search relevant articles on your search term

Read More

Date Function

The Microsoft Excel DATE function returns the serial date value for a date.

The DATA function is a built -in function in Excel that a categorized as a Date/Time Function. It can be used as a worksheet function in Excel. As a worksheet function, the DATE function can be entered as part of formula in a cell of a worksheet.

Syntax

The syntax for the DATE function in Microsoft Excel is:

Date( Year, month, day)

Parameters or Arguments

Year
      A number that a between one and four digits that represents the year

Month
     A number representing the month value. If the month value is grater that 12, then every   12 months will add 1 year to the year value. This meas that DATE(2016,13,4) is equal to DATE (2017,1,4)

Day
    A number representing the day value. If the day value is grater that the number of days in the month specified, then the appropriate number of months will be added to the month value.


Note

•  If the year is between 0 and 1899, the year value is added to 1900 to determine the year
• If the year between 1900 and 9999, the DATE function uses the year value as the year
• If the year is grater that 9999, the DATA function will return the #NUM error.
• A serial data is how excel stores dates internally and it represents the number of days since January 1, 1900

Read More

Functions

Worksheet functions are categorized by their functionality. Click a category to brows its functions. Or Press Ctrl + F to fine a function by typing a first few letters or a descriptive word. Under Formulas Tab you can find Function Library

Click on Insert Function find more functions. select category or Type function on Search function.

Example :

Type Function in search and click on a function

Use Function wizard.

Video >>

Read More

Excel Keyboard Shortcuts.

Below are listing of all the major shortcut keys usable in Microsoft Excel. 

Data Selection / Navigation

Ctrl + Pg Up/Pg Down       -      Move to Prior / Next Wroksheet

Shift/Ctrl + Space bar         -     Select Entire Row/Column

Ctrl + * (Ctrl + Shift + 8)   -     Select All Adjacent Cells

Ctrl + A                              -      Similar to Ctrl + *, Twice for All Cells Add to Selection

Shift + F8                           -      Add to Selection

Shift + Alt + =>/<=            -      Group / Ungroup Selection

Ctrl +0 /9                            -      Collapse (Hide Columns / Rows )

Ctrl + Shift + 0/9                -      Expend (Unhide Columns / Rows )

Ctrl  + Arrow Keys             -     Move by Blocks of Cells

Shift + Arrow Keys             -    Select Cells

Ctrl + Home / End               -    Move to Upper Left / Lower Right

Ctrl + . (within selection)    -    Move Clock wise to next Corner

Ctrl+_ / Ctrl + +                   -   Delete / Insert Selected Cells

Alt + Down Arrow               -  Show Dropdown List Options

Alt + (Ctrl + Tab )                -  Navigate Menu Items / Toolbar

Date Manipulation

Ctrl + C / Ctrl + Insert            -      Copy

Ctrl + X / Shift + Delete         -      Cut

Ctrl + V / Shift + Insert          -       Past

Ctrl + R / D                             -      Auto fill ( Copy Past Right / Down )

Ctrl + Z / Y                             -     Undo / Redo Last Action

Ctrl + F / H                             -      Find / Replace

Alt + =                                    -      Summation ( Auto Sum)

Ctrl + ' / "                                -      Copy Formula / Value Above

Ctrl + Shift + Enter                -      Enter Formula as an Array

Auditing 

Ctrl + [ / ]                               -    Trace Direct Precedents / Dependents

Ctrl + { / }                              -    Trace All Precedents / Dependents

Alt + T + U + A                     -    Remove All Audition Arrows

F5 / Ctrl + G                          -    Go To Previous Cell ( Go To )

Ctrl + Shift + O                     -    Select All Commented Cells

File / Application Related

Ctrl + S / O / W                    -     Save / Open / Close File

F12 or Alt + F, A                  -     Save File As

Shift + F12 / Ctrl + F12        -     Save File / Open File

Alt + E + L                           -      Delete Worksheet

Ctrl + Tab / Ctrl + F6           -      Toggle Files Within Excel

Alt + Tab                              -     Toggle Application

Windows Button + M          -      Minimize All

Windows Button + D           -     Show Desktop

Windows Button + Shift + M/D- Restort All ( Same order)

Formatting

Alt + E + S, then                     -     Paste Special ( Copy first)
F,T,V                                       -     Formulas, Format, Value
E                                             -     Transpose ( Values only )
S, D, M, I                                 -    Add, Divide, Multiple, Divide
Ctrl + B / U / I                         -    Toggle Bold / Underline / Italic
Ctr + 1                                     -     Format Cells
Ctrl + Shift + Underline          -    No Border
Ctrl + Shift + 7                        -   Box selection
Ctrl + Shift + F / P                   -   Format Font Face / Size
Ctrl + (Shift) + Alt  + Tab      -   Increase / Decrease Indent
Alt + O, C, A                          -   AutoFit Column Width
Alt + O, H, R                          -   Change Worksheet Name 

   

Read More