Microsoft Excel Essentials

Shortcuts

• ** Navigation **
  • Ctrl + Home: Go to the beginning of the worksheet
  • Ctrl + End: Go to the end of the worksheet
  • Ctrl + Page Up/Page Down: Move between worksheets
• ** Editing **
  • Ctrl + C: Copy
  • Ctrl + X: Cut
  • Ctrl + V: Paste
  • Ctrl + Z: Undo
  • Ctrl + Y: Redo
• ** Formatting **
  • Ctrl + 1: Apply the number format
  • Ctrl + Shift +!: Apply the date format
  • Ctrl + Shift + $: Apply the currency format
• ** Other **
  • Ctrl + N: New workbook
  • Ctrl + S: Save
  • Ctrl + P: Print
  • F1: Help
  • F2: Rename
  • F5: Refresh
  • F11: Toggle full screen

Formulas and Functions

• ** Arithmetic Operators **
  • • (Addition)
  • • (Subtraction)
  • • (Multiplication)
  • / (Division)
  • % (Percentage)
  • ^ (Exponentiation)
• ** Common Functions **
  • SUM(range): Returns the sum of a range of cells
  • AVERAGE(range): Returns the average of a range of cells
  • COUNT(range): Returns the count of cells in a range
  • IF(logical_test, [value_if_true], [value_if_false]): Tests a condition and returns a value if true or false
  • VLOOKUP(lookup_value, table_array, col_index, [range_lookup]): Looks up a value in a table and returns a value from a corresponding column
• ** Text Functions **
  • LEN(text): Returns the length of a text string
  • LOWER(text): Converts a text string to lowercase
  • UPPER(text): Converts a text string to uppercase
  • PROPER(text): Converts a text string to proper case
  • CONCATENATE(text1, [text2],...): Joins two or more text strings together

Data Analysis

• ** Data Validation **
  • Restrict input data to a specific format or range
  • Create drop-down lists and checkboxes
• ** Conditional Formatting **
  • Highlight cells based on specific conditions
  • Use formulas to format cells
• ** Pivot Tables **
  • Summarize and analyze large datasets
  • Create custom views and reports
• ** Data Filters **
  • Filter data to show specific rows or columns
  • Use filters to narrow down large datasets

Chart Creation

• ** Chart Types **
  • Column charts
  • Line charts
  • Pie charts
  • Bar charts
  • Scatter charts
• ** Chart Elements **
  • Titles
  • Legends
  • Axes
  • Data labels
  • Gridlines
• ** Chart Customization **
  • Colors and fonts
  • Chart styles and layouts
  • Data series and axis customization

Parts of the Excel Window

• ** Ribbon **
  • Tabs (Home, Insert, Page Layout, etc.)
  • Groups (Clipboard, Font, Alignment, etc.)
  • Buttons and icons
• ** Worksheet **
  • Cells (A1, B2, C3, etc.)
  • Rows and columns
  • Header and footer rows
• ** Formula Bar **
  • Displays the current cell's formula
  • Allows editing of formulas
• ** Status Bar **
  • Displays information about the worksheet and Excel
  • Shows the current cell's coordinates and formula