Excel Shortcuts

 Top Excel Shortcuts & Vba

1. Basic Shortcuts

ShortcutAction
Ctrl + NNew Workbook
Ctrl + OOpen Workbook
Ctrl + SSave Workbook
Ctrl + PPrint Workbook
Ctrl + ZUndo
Ctrl + YRedo
Ctrl + XCut
Ctrl + CCopy
Ctrl + VPaste
Ctrl + ASelect All

2. Navigation Shortcuts

ShortcutAction
Ctrl + Arrow KeysMove to the edge of data (up, down, left, right)
Shift + Arrow KeysSelect cells in a direction
Ctrl + HomeGo to cell A1
Ctrl + EndGo to last used cell
Page Up / Page DownMove one screen up/down
Alt + TabSwitch between open applications

3. Formatting Shortcuts

ShortcutAction
Ctrl + BBold
Ctrl + IItalic
Ctrl + UUnderline
Alt + H + A + CCenter Align
Ctrl + Shift + LApply/Remove Filters
Ctrl + Shift + %Apply Percentage Format
Ctrl + Shift + $Apply Currency Format
Ctrl + 1Open Format Cells Dialog

4. Working with Rows & Columns

ShortcutAction
Ctrl + SpaceSelect Entire Column
Shift + SpaceSelect Entire Row
Ctrl + Shift + "+"Insert Row/Column
Ctrl + "-"Delete Row/Column
Alt + H + O + IAuto-Fit Column Width
Ctrl + DFill Down (Copy cell above)
Ctrl + RFill Right (Copy cell left)

5. Formula & Data Shortcuts

ShortcutAction
=Start a Formula
F2Edit Active Cell
Alt + =AutoSum
Shift + F3Open Insert Function Dialog
Ctrl + ` (backtick)Show Formulas
Ctrl + Shift + EnterEnter Array Formula
F4Repeat Last Action or Toggle Absolute Reference ($A$1)

6. Pivot Tables & Charts

ShortcutAction
Alt + N + VInsert Pivot Table
Alt + F1Create Default Chart
F11Create Chart in New Sheet

7. Data Handling & Special Functions

ShortcutAction
Ctrl + Shift + LApply/Remove Filter
Ctrl + TCreate Table
Alt + D + F + FTurn Filter On/Off
Ctrl + HFind and Replace
Ctrl + Shift + "*"Select Data Region

8. Miscellaneous & Productivity Shortcuts

ShortcutAction
F12Save As
Ctrl + WClose Workbook
Ctrl + Shift + #Apply Date Format
Ctrl + Shift + @Apply Time Format
Alt + H + O + RRename Worksheet
Alt + E + MMove or Copy Worksheet

Super Useful Shortcuts to Memorize:

  1. Ctrl + Z → Undo
  2. Ctrl + C / Ctrl + V → Copy/Paste
  3. Ctrl + Shift + L → Apply/Remove Filters
  4. Ctrl + D → Copy Cell Down
  5. Ctrl + T → Create a Table
  6. Alt + = → AutoSum
  7. Ctrl + ` → Show Formulas

click here

Assessment: Regular Tests, Assignments, and Final Project Evaluation

Certification: Certificate of Completion from Disha Institute

Number of Days Depends on your practice and feedback. The more you practice and review your work, the faster you will complete the course.

For Batch time and Fess contact to Below Address and Number.

Zamanat Sir       (MCA / Bsc. I.T / ‘A’ / ‘O’ / CCC / Govt. Certified  Domain Skill Trainer Disha Institute 153 Vijay Nagar Opp. Rg Pg College W.K Road Meerut     (9411617329 , 9458516690) 

Courses                Reviews &Location                  Download

For More Details such as Courses , Job updation , Notes , Videos ,Links  Click Here

Comments

Post a Comment

Popular posts from this blog

VBA Modules for Excel Automation (Advance Excel)

  Essential VBA Modules for Excel Automation 1. Auto-Adjust Column Width Automatically adjust all columns to fit content. Sub AutoFitColumns() Cells.EntireColumn.AutoFit End Sub 2. Delete Blank Rows Removes all empty rows in the active sheet. Sub DeleteBlankRows() Dim rng As Range Set rng = ActiveSheet.UsedRange Dim i As Integer For i = rng.Rows.Count To 1 Step -1 If WorksheetFunction.CountA(rng.Rows(i)) = 0 Then rng.Rows(i).Delete End If Next i End Sub 3. Highlight Duplicates Highlights duplicate values in a selected range. Sub HighlightDuplicates() Dim rng As Range Set rng = Selection rng.FormatConditions.AddUniqueValues rng.FormatConditions(1).DupeUnique = xlDuplicate rng.FormatConditions(1).Interior.Color = RGB(255, 0, 0) End Sub 4. Merge Multiple Sheets into One Merges all sheets into a single sheet. Sub MergeSheets() Dim ws As Worksheet, destSheet As Worksheet Set destSheet = Sheets.Add destSh...
Read more

Java Programming

  Java Programming Notes 1. Introduction to Java Programming 1.1 What is Java? Java is a high-level, class-based, object-oriented programming language developed by James Gosling and Mike Sheridan at Sun Microsystems (now owned by Oracle). Java is platform-independent, meaning it can run on any device or operating system that has the Java Runtime Environment (JRE) installed. 1.2 Structure of a Java Program A basic Java program consists of: Class declaration : The class is the blueprint of the object. Main method : The entry point of a Java program, public static void main(String[] args) . Statements inside the main method to perform tasks. public class HelloWorld { public static void main (String[] args) { System.out.println( "Hello, World!" ); } } 2. Java Data Types 2.1 Primitive Data Types Java has eight primitive data types: byte : 8-bit integer. short : 16-bit integer. int : 32-bit integer. long : 64-bit integer. float : 32-bit floating point. d...
Read more