Excel-in-XL Intermediate

Excel-in-XL course:
Basic to Intermediate Level

Attendees knowledge of this course steps forward from Beginners level to Intermediate level user of Microsoft Excel.


WHO SHOULD ATTEND

This course is important for those who are using Excel as their basic working tool and want to step ahead by learning smart ways. After learning skills in this course and by efficiently use them can save at-least 4 to 5 hours weekly.

Beginner users who have basic knowledge of Excel and can make basic calculations.

WHAT YOU WILL BE ABLE TO DO

Environment:

• Better understanding of Excel 2016 interface
• Easily working around with Excel environment (e.g. rows/columns/etc, selections)
• Secure data and/or restrict your users to post data within required cells only.

Data & File Handling:

• Change the order of data
• View part of data based on criterias
• Reports Preparations (Data and Cell Formatting), 
• Page Setup, File handling and Printing.

Formulas: 
Formulas make Excel a smart spreadsheet program. In this course you will learn ...

• Fundamentals of formulas and functions. 
• Simple and complex formulas introduction
• Cell Referencing, its types and their usages.
• Auto & quick SUMs, other basic functions.

Charts:

• Introduction to data visualization with Charts
• Ability of select appropriate chart, which is suitable for which data
• Create Column, Bar, Line and Pie graphs.
• Customization

Smart practical tips and tricks along-with shortcut keys.






To register yourself in upcomming sessions fill the below form for registration...
<...>
 

*int_v2*

Repeat Last Command Used (Shortkey)

Repeat last command used by pressing <F4> key.

Shortkeys to work around in Excel Environment (Shortkeys/HotKeys)

Important short keys to work around in Microsoft Excel Environment to speedup your productivity ...  

KEYS------------------------	Description-------------------------------------------
Selection
Ctrl + A	Select All (if...)
Shft + ArrowKeys	Select adjacent cell
Shft + SpaceBar	Select whole row
Ctrl + SpaceBar	Select whole column
Column/ Rows/ Cells
Alt O C W	To change column width by points
Alt O R E	To change row height by points
Alt O C A	AutoFit column width as selected cell’s data.
Alt I R	Insert above a blank row
Alt I C	Insert right-side a blank column
Ctrl +	Insert column/ Row/ Cell.
Ctrl –	Delete column/ Row/ Cell.
Ctrl 0	Hide column(s)
Ctrl 9	Hide row(s)
Alt O C U	Unhide columns within selected range
Alt O R U	Unhide rows within selected range
Alt W F F	Toggle Freeze/ Unfreeze rows/columns
Sheets
Ctrl PgUp	Goto previous sheet
Ctrl PgDn	Goto next sheet
Shft F11	Insert new worksheet
Alt H O R	Rename active sheet
Alt T P P	Toggle Protect/ Unprotect sheet
Alt I B	Toggle page break
Alt H O M	To get “Copy and Move” dialogue box
While Cell Editing
Home	Goto start of line
Ctrl Home	Goto Start of cell contents
End	Goto end of line
Ctrl End	Goto end of cell contents
Ctrl LeftArrow	Move one word left side
Ctrl RigthArrow	Move one word right side
Ctrl Delete	To delete all data right side of cursor in cell.

Microsoft Excel 2010 Interface

At first; Microsoft Excel 2010 interface (screen) looks as divided into two parts; 1) Command buttons and 2) Worksheet; but; there are many other parts as well, if you have knowledge about them you will have an ease to read and understand whenever they referred- in any process either downloaded from internet, book or even by a teacher.

Below is a snap along-with parts names. Click to enlarge.

.

Add or Delete Cell Borders (Shortkeys)

Shortkeys to add or remove a cell or range of cells borders

Ctrl + H + B + S ... Border Outline on a selected range
Ctrl + Shft + 7 .... Border Outline on a selected range
Ctrl + H + S + A ... Border all cells on selected range

Ctrl + H + B +N  ... Clear/delete borders
Ctrl + Shft + -  ... Clear/delete borders

Example:

Paste with Source Column Width

Sometimes when u copy data from one location to another, u want to adjust the column width same as source data. You can do it by following steps ...

1. Copy the data u want
2. Goto location where u want to paste
3. Goto Home tab > Paste button (lower part as showing in pic)
4. Click on button "Paste with source width", at 2nd row 2nd column (as showing in pic)

Shortkey is ALT + H + V + W