If you’re looking to improve your Excel skills, then you’ve come to the right place. Whether you’re a beginner or an experienced user, this is the perfect spot to learn everything you need to know about Excel.
Introduction
The perfect place to start learning Excel is getting into the fundamental workings of the software. The Range and the Formulas and Functions in Excel are the perfect first steps.
Range
What is a Range in Excel?, Row Vs Column What’s the Difference?
AutoFill | Fibonacci Sequence | Custom Lists | How to Hide Rows in Excel | How to Unhide Rows in Excel | How to Hide Columns in Excel | How to Unhide Columns in Excel | Skip Blanks | AutoFit | Transpose | Split Cells | Flash Fill | Move Columns | Move Rows | ROW function
Formulas and Functions
Formulas and Functions in Excel, Difference Between Functions and Formulas
Excel formulas and functions made easy!
This section focuses on the most commonly used functions and is perfect for beginners and experienced users looking to up their game and learn Excel. Master Excel’s essential tools and become an expert in no time.
Most Used Functions | Add | Subtract | Multiply | Divide | Sum a Column | Square Root | Percentage Increase | Percentage Difference | Percentage | Named Range | Dynamic Named | Range | Paste Options | Discount
For more Excel Functions see our dedicated page for an ever-growing list of Functions with full explanations.
Basics
Master Excel’s fundamentals and become a pro! This section covers all the essentials, making it the perfect resource for beginners and experienced users to learn excel. Get started now and level up your Excel skills.
Ribbon
Formula Bar | Quick Access Toolbar | Customize the Ribbon | Developer Tab | Status Bar | Checkbox | Show or Hide the Formula Bar | Show or Hide the Ribbon | Show Formulas | Hide Formulas
Workbook
Themes | View Multiple Workbooks | AutoRecover | Save in 97-2003 Format | Hide Gridlines | Watermark Add a Header | Insert Page Numbers | Add a Footer | Show Gridlines | Group Rows
Worksheets
Zoom | Split | Freeze Panes | Group Worksheets | Consolidate | View Multiple Worksheets | Get Sheet Name | Comments | Spell Check | How to Hide Sheets | How to Unhide Sheets | How to Insert Sheet | How to Rename Sheet | How to Delete Sheet | Freeze Rows | Resize Multiple Columns | Insert Image | Make Borders | Remove a Page Break | Number Rows | How to Insert Row in Excel | Insert Multiple Rows | How to Delete Row | How to Insert Column | How to Delete Columns | Change Row Height | Change the Width of a Column | Switch Rows and Columns in Excel
Format Cells
Decimal Places | Fractions | Currency vs Accounting | Text to Numbers | Numbers to Text | Custom Number Format | Format Painter | Cell Styles | Wrap Text | Merge Cells | How to Combine Cells | Strikethrough | Superscript and Subscript | Add Leading Zeros | Check Mark | Change the Number of Decimal
Find & Select
Find Features | Wildcards | Delete Blank Rows | Row Differences | Copy Visible Cells Only | Search Box
Templates
Budget | Calendar | Holidays | Meal Planner | Invoice | Automated Invoice | Default Templates | Time Sheet | BMI calculator
Data Validation
Reject Invalid Dates | Budget Limit | Prevent Duplicate Entries | Product Codes | Drop-down List | Dependent Drop-down Lists | Edit a Drop-Down List | Remove a Drop-Down List | Cm to inches | Kg to lbs
Keyboard Shortcuts
Function Keys | Insert Row | Save As | Delete Row | Formula to Value | Scroll Lock | Bullet Points | Line Break | Show Formulas | Paste Special
Workbook Views | Page Breaks | Headers and Footers | Page Numbers | Print Titles | Center on Page | Print Gridlines & Headings | Print Area | Print One Page
Share
Embed | PDF | Convert an Excel File into PDF | Convert Excel to Google Sheets | Share Workbooks | OneDrive | Online | Import Access Data | Microsoft Query | Import/Export Text Files | XML
Protect
Protect Workbook | Protect Sheet | Unprotect Sheet | Lock Cells | Read-only Workbook | Mark as Final
Functions
Unlock Excel’s full potential with our comprehensive functions section! Learn to perform calculations, manipulate data, and analyze information with ease. Whether a beginner or a seasoned pro, this section will take your Excel skills to new heights.
Count and Sum
Countif | Count Blank/Nonblank Cells | Count Characters | Not Equal To | Count Cells with Text | Sum | Running Total | Sumif | Sumproduct
Logical
If | Comparison Operators | Or | Roll the Dice | Ifs | Contains Specific Text | Switch | If Cell is Blank | Absolute Value
Cell References
Copy a Formula | Copy and Paste Values Without Formula | 3D-reference | Name Box | External References | Hyperlinks | Union and Intersect | Percent Change | Absolute Reference | Address | Insert Symbol | Link Cells | Select Two Different Columns
Date & Time
DateDif | Today’s Date | Insert and Format Time | Calculate Hours Worked | Hours Worked (Midnight Span) | Sum Time in Excel | Date and Time Formats | Calculate Age | Time Difference | Weekdays | Days until Birthday | Last Day of the Month | Add or Subtract Time | Quarter | Day of the Year | Days between Dates | Difference Between Two Dates | Calculate Working Days | Change Date Format
Text
Separate Strings | Count Words | Text to Columns | Find | Search | Change Case | Remove Spaces | Compare Text | Substitute vs Replace | Replace Words | Text | Concatenate | Substring | How to Change Text Direction | Separate Names | Combine First and Last Name | Barcodes | Create a QR Code | Change Capital Letters to Lowercase | Change Lowercase to Uppercase | Capitalize First Letters | Convert Text to Number
Lookup & Reference
Vlookup | Tax Rates | Index and Match | Two-way Lookup | Offset | Case-sensitive Lookup | Left Lookup | Locate Maximum Value | Indirect | Two-column Lookup | Closest Match | Compare Two Columns | Xlookup
Financial
PMT | Loans with Different Durations | Investment or Annuity | Compound Interest | CAGR Loan Amortization Schedule | NPV | IRR | Depreciation | Profit Margin | Get Stock Prices
Statistical
Average | Negative Numbers to Zero | Random Numbers | Rank | Percentiles and Quartiles | Box and Whisker Plot | AverageIf | Forecast | MaxIfs and MinIfs | Weighted Average | Mode | Standard Deviation | Frequency | Find the Largest Number | Change Negative Numbers to Positive | Calculate the Median
Round
Chop off Decimals | Nearest Multiple | Even and Odd | Mod | Rounding Times | ROUNDUP | ROUND | ROUND DOWN
Formula Errors
IfError | IsError | Aggregate | Circular Reference | Formula Auditing | Floating Point Errors | IFNA
Array Formulas
Count Errors | Count Unique Values | Count with Or Criteria | Sum Every Nth Row | Sum Largest Numbers | Sum Range with Errors | Calculate the Range | Sum with Or Criteria | Most Frequently Occurring Word | Dynamic Arrays | LET function | Array Manipulation
Math
Write Pi in Excel | Write the Squared Symbol | Insert Degree Symbol
Engineering
convert meters to feet | convert mm to inches | convert km to miles | convert liters to gallons | convert kg to lbs | convert cm to inches
Check out our dedicated page for an ever-expanding list of Excel functions, complete with full explanations.
Data Analysis
Master data analysis in Excel with our comprehensive section! Learn to manipulate, visualize, and analyze data like a pro. Whether you’re a novice or an expert, this section has everything you need to unlock powerful insights and confidently make informed decisions.
Sort
Custom Sort Order | Sort by Color | Reverse List | Randomize List | SORT function | Sort Alphabetically
Filter
Create Filter | Clear or Remove Filter | Number and Text Filters | Date Filters | Advanced Filter | Data Form | Remove Duplicates | Outlining Data | Subtotal | Unique Values | FILTER function | Clear Formatting | Sort by Date
Conditional Formatting
Manage Rules | Data Bars | Color Scales | Icon Sets | Find Duplicates | Shade Alternate Rows | Compare Two Lists | Conflicting Rules | Heat Map | Highlight Blank Cells | Change the Scale | Highlight Every Other Row
Charts
Column Chart | Line Chart | Pie Chart | Bar Chart | Area Chart | Scatter Plot | Data Series | Axes | Chart Sheet | Trendline | Error Bars | Sparklines | Combination Chart | Gauge Chart | Thermometer Chart | Gantt Chart | Pareto Chart | Add Axis Titles | Title to a Chart | Change Chart Style | Change Chart Colour | Add a Legend | Rename a Legend | Add an Average Line | Add a Target Line
Pivot Tables
Group Pivot Table Items | Multi-level Pivot Table | Frequency Distribution | Pivot Chart | Slicers | Update Pivot Table | Calculated Field/Item | GetPivotData
Tables
Structured References | Table Styles | Merge Tables | Table as Source Data | Quick Analysis
What-If Analysis
Data Tables | Goal Seek | Quadratic Equation | Track Changes
Solver
Transportation Problem | Assignment Problem | Capital Investment | Shortest Path Problem | Maximum Flow Problem | Sensitivity Analysis | System of Linear Equations
Analysis ToolPak
Histogram | Descriptive Statistics | Anova | F-Test | t-Test | Moving Average | Exponential Smoothing | Correlation | Regression