Microsoft Excel Features and Concepts that Everyone (Including Developers) Should Know

Photo by Isaac Smith on Unsplash

Beginner Level

Basic Definitions:

Ribbon Tabs (the top green bar):

Worksheet Tabs (bottom section of the document):

Data Types:

Format Cells:

Main Math Formulas:

Copy/Paste:

Text Alignments:

Basic Computations:

Control + Z:

Control + Arrows:

Excel Shortcuts:

Intermediate Level

Rounding Decimal Numbers:

Find and Select (and Replace):

Add or Remove:

Hiding and Un-Hiding Columns:

Swapping Columns:

Transpose:

Flash Fill:

Text File Importation:

Save As:

Insert Tabular Table:

Data Filters:

Resize:

Alt + Enter:

Sort:

Remove Duplicates:

Clear Content vs. Delete:

Freeze Panes:

Making the Same Change Across Worksheets:

Conditional formatting:

Advanced Level

Text to Columns (button in ‘Data’ within Ribbon Tab):

Create and Manipulate Charts or Graphs:

Pivot Tables:

V-lookup:

Absolute and Relative Cell References:

Expert Level

Macros:

VBA Programming:

Photo by Afif Kusuma on Unsplash

Should You Buy an Online Course to learn Excel?

How can I showcase my Excel skills?

Conclusion:

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store