Microsoft Excel Practical 2007, 2010, 2013, 2016, 2019
File:
New: To Create A New Workbook/ File In Excel.
Steps: Office Button / File→ New - Create.
Open: To Open An Existing Excel File
Steps: Office Button / File – Open – Select The File – Open.
Close: To Close The Current File (With Shift Key You Can Have ‘Close All’.
Steps: Office Button / File – Close.
Save: To Save Or Modify A File.
Steps: Office Button / File – Save – File Name – Save.
Save As: To Save Another Copy Of The File.
Steps: Office Button / File – Save As – New File Name – Save.
Save As Webpage: To Save The File As Html Page For Publishing Into The Internet
Steps: Office Button / File – Save As Webpage – Add Inter Activity – Any File Name – Save.
Save Workspace: To Save Multiple Files Within One File.
Steps: Office Button / File – Open – Select Some Excel Files – Open – View – Save Workspace – Any Name – Save. File – Close All . Office Button / File – Open - Select The Workspace File – Open. Window – Arrange – Tiled – Ok.
Page Setup: To Set The Page To Make Some Print Out.
Steps: Page Layout – Page Setup – Page – Portrait/Landscape – Margin – Top = Bottom = Left = Right = 1” – Ok.
Print Area: To Set / Discard The Selected Printing Area.
Steps : Select The Cells – Page Layout – Print Area – Set Print Area. Office Button / File – Print - Print Preview – Close.
To Clear The Print Area : Page Layout – Print Area – Clear Print Area.
Print Preview: To View The Page Before The Print Out
Steps: Office Button / File – Print - Print Preview.
Send : To Send The Data To Another Microsoft/Internet Application.
Steps: Office Button / File – Send – Email.
Properties: To Get The General Information About The Files.
Steps: Office Button / File – Prepare - Properties – General/Summery/Statistics/Content – Ok.
Print : To Make Some Printouts On The Page.
Steps: Office Button / File - Print - Number Of Copies = 1 – Ok.
Exit: To Close The Microsoft Excel.
Steps: Office Button / File – Exit.
Undo: One Step Backward.
Steps: Quick Tool Bar – Undo.
Repeat/ Redo : One Step Forward.
Steps: Quick Tool Bar – Repeat/ Redo.
Cut: To Cut And Paste The Text / Object To The Desired Position. Once You Cut An Object You Can Paste It Many Times If It Is Available On Clipboard.
Steps: Select The Cells – Home – Cut – Select The Position – Edit – Paste.
Copy: To Create Another Copy Of The Same Text. Once You Cut An Object You Can Paste It Many Times If It Is Available On Clipboard.
Steps: Select The Cells – Home – Copy – Select The Position – Edit – Paste.
Paste: After Cut Or Copy You Can Get The Result With The Paste.
Steps: Home – Paste
Office Clipboard: To Copy Multiple Objects Within A Clip Board.
Steps: Home – Office Clipboard – Edit – Copy.
Paste Special: To Create A Link Between To Copy & Pasted Area. If Any Chages Occurred In Mother Sheet (Copied) Then All Changes Are Available In Child Sheet (Pasted) Also.
Steps: Select The Cells – Home – Copy – Sheet 2 – Home – Paste Special – Paste Link.
Fill: To Fill Some Cells With Same Number (1,1,1,1) Or Value Or Series As (1,2,3….)
Steps: Write Any Number In Any Cell – Select Some More Cell Downwards – Home – Fill – Down.
Steps: Write Any Number In Any Cell – Select Some More Cell Downwards – Home – Fill – Series – Step Value =1 – Ok.
Clear: To Clear Out The Colors, Values Or Any Modification.
Steps: Select The Area - Home– Clear – All. (Everything Will Be Wiped Out)
Select The Area - Home – Clear – Formats. (Formatting Will Be Wiped Out)
Select The Area - Home – Clear – Contents. (Values Will Be Wiped Out)
Select The Area - Home– Clear – Comments. (Comments Will Be Wiped Out)
Delete: To Erase A Selected Row Or Column Or Cell.
Steps: Select The Row/Column/Cell – Home – Delete.
Delete Sheet: To Erase A Sheet.
Steps: Home – Delete Sheet.
Move Or Copy Sheets: To Create Another Copy Of The Sheet Or To Move To Another Workbook.
Steps: Home – Format – Move Or Copy Sheets – Choose The Work Book – Check The Create Copy – Ok
Find : To Search Some Values.
Steps: Home – Find – Write The Word To Be Found – Find Next.
Replace: To Change A Value With Another Value.
Steps: Home – Replace – In Find What ( The Word To Be Replaced) – In Replace With ( The Word With Which It Will Be Replaced) – Replace.
Select All: To Select Whole Worksheet.
Steps: Ctrl + A
Goto: To Select Some Cells.
Steps: Ctrl + G – Give The Range – Ok.
Normal: After Watching Page Break Preview You An Normalize The View .
Steps: View – Normal.
Page Break Preview: To Get The Print Area Page wise.
Steps : View – Page Break Preview – Ok.
Formula Bar: To Activate Or Deactivate The Formula Bar.
Step: View – Formula bar.
Header & Footer: To Write The Information At The Top Or Bottom Of The Page.
Steps: Insert – Header & Footer – Custom Header/Footer – Write The Texts – Ok.
Comment: To Pass/View Some Texts For The Reference.
Steps: Select The Cell – Review – Comments – New Comment – Write The Comment.
Custom View: To Name Some Selected Area With Name.
Steps: Select The Area – View – Custom View – Add – Write Any Name - Ok.
Zoom: To Enlarge The View Up to 200%
Steps: View – Zoom – Select The View = 200% - Ok.
Cell: To Insert A New Cell On Desired Position.
Steps: Select The Cell - Home– Insert – Cell – Shift Cell Down/Right – Ok
Row: To Insert A New Row On Desired Position.
Steps: Select The Row – Home - Insert – Row.
Column: To Insert A New Column On Desired Position.
Steps: Select The Column - Home – Insert – Column.
Worksheet: To Insert A New Worksheet On Desired Position.
Steps: Right Click on The Worksheet Tab – Insert – Worksheet - OK.
Chart: Visual Representation Of The Value / Data.
Steps: Select The Data – Insert – Chart – Select The Type – Next – Add The Name - As A New Sheet – Finish.
Function: To Calculate Easily With The Set Of Commands
Steps: Select The Cell – Formula – Function – Select The Category – Select Function - Ok .
Name: To Name The Cells Instead Of Cell Addresses.
Steps: Select The Area – Formula – Create – Ok – Insert – Name – Apply – Ok.
Steps: Select The Area – Formula - Name – Define – Any Name – Add – Sheet 2 – Insert – Name- Paste – Ok.
Comment: To Pass A Comment On Any Cell.
Steps: Select The Cell – Review– Comment – Write Some Text.
Picture: To Insert Any Picture From Any Drive.
Steps: Insert – Picture – Select The Drive – Select The Folder – Select The File – Insert.
Diagram: To Insert Any Diagram As Chart To Represent The Data Visually.
Steps: Insert – Diagram – Select Any One - Ok
Objects: To Insert Any Object From Any Other Application .
Steps: Insert – Objects – Select The Application E.G Bitmap Image – Ok.
Hyperlink: To Create A Link Between Two The Files.
Steps: Select The Cell – Insert – Hyperlink – Select The File – Ok.
Cell: To Change The Color, Direction, Currency Symbol, Pattern Etc.
Steps: Select The Cells – Insert - Format – Cells – Select The Options – Ok.
Row: To Modify The With Its Height, Hide Or Unhide.
Steps: Select The Cell – Insert - Format – Row – Height ( Increase The Height) / Auto fit (Automatically Adjustment) / Hide ( Concealing Row) / Unhide (Unveil).
Column: To Modify The With Its Height, Hide Or Unhide.
Steps: Select The Cell – Insert - Format – Column– Height ( Increase The Height) / Auto fit (Automatically Adjustment) / Hide ( Concealing Row) / Unhide (Unveil).
Sheet: To Modify/Rename The Worksheet Background / Hide / Unhide.
Steps: Insert - Format – Worksheet – Background – Choose The Picture File - Ok
Table format as: To Apply Selected Predefine Style.
Steps: Select The Cells – Insert – Table Format As – Select The Style – Ok.
Conditional Formatting: To Make Modification According To The Conditions.
Steps: Select The Cell – Insert - Conditional Formatting – Select The style –
Spelling : To Check The Spelling Of The Corresponding Cell.
Steps: Select The Cell – Review – Spelling and Grammar – Change – Ok.
Track Change: To Protect Your Sheet Without Having Any Data Lose.
Steps: Review – Track Change – Highlight The Changes - Select The Range – Ok.
Protection: You Van Protect Your Sheet With Password.
Steps: Review – Protect Sheet – Enter The Password – Reenter The Password – Ok.
Goal Seek: To make Any Adjustment Entry in the Current Sheet.
Steps: Select The Contains A Formula – Data – What if analysis – Goal Seek -Input The To Value – Select A Cell Which Doesn’t Contain Any Formula – Ok.
Scenarios: To Make Multiple Sheet Within One Sheet.
Steps: Select Less Than 32 Cells – Data – What if analysis - Scenario – Add – Change The Cell Values – Ok.
Formula Auditing: To View The Dependency Of Cell On Each Other.
Steps : Select The Cell – Formulas – Formula Auditing – Trace President / Trace Dependence .
Macro: To Record Some Steps.
Steps: View – Macro – Record New Macro – Ok – Do Some Steps More – Stop Recording.
Now You Can Run It From : View – Macro – Run Macro – Select The Macro No. –Run
Sort: To Arrange The Data In Ascending Or Descending Order.
Steps: Select The Data – Data - Sort – Select The Column – Ok
Filter: To Filter The Value According To Your Need.
Steps: Select The Data – Data – Filter –Auto filter - Select The Column – Custom – Set The Condition – Ok.
Form: To Make Automatic Entry To The Corresponding Cells.
At first you need to add this from excel option as : Office button – excel option – customize – All commands – form – add – ok.
Steps: Select The Data – Quick Launch Toolbar – Form – New – Enter The Data – Ok.
Subtotal: To Add And Arrange The Data Within Groups.
Steps: Select The Data – Data – Sort On A Field – Data – Subtotal – Select The Same Field – Select The Field To Be Added – Ok.
Validation: To Set The Acceptance Criteria For The Cells.
Select The Cells – Data – Validation – Select Whole Number – Set The Maximum And Minimum Number – Input Message – Title – Write The Massage – Error Alert – Write The Title – Write Error Alert – Ok.
Table: To Make A Table For Any Number.
Steps: Make A Series – Data - What if analysis - Table – Set Row Input Cell – Set Column Input Cell – Ok.
Text To Column: To Arrange Or Shift The Criteria To The Corresponding Column
Steps: Write Some Values With Using Comma – Data – Text To Column- Now Select Comma – Next – Finish.
Group And Out Line: To Create The Group Of Rows Or Column
Steps: Select The Column – Data – Group – Select The Row Or Column –Ok.
Arrange : To Arrange The Files In Any Order .
Steps: View – Arrange – Tiled – Ok.
Hide: To Hide Or Unhide The Window.
Steps: View – Hide/Unhide – Ok.
Split: To Divide The Window.
Steps: View– Split .
Freeze Pane: To Make A Fixed Column Or Row.
Steps: Select The Row/Column – View – Freeze Pane.
No comments:
Post a Comment