Microsoft Excel Tutorials - Developer Publish Academy

If you are one of the users who want to learn more about Microsoft Excel, you are in the right place. On this page, you will find plenty of excel tutorials covering every excel features.

DeveloperPublish.com offers tutorials on various topics like Excel, Word, PowerPoint, Microsoft Azure, Amazon AWS, C#, PowerShell, and many more niche topics. On this page, you will find an overview of all covered subjects as part of Excel tutorials.

This tutorial is for all the users who want to learn excel. These can vary from users with no knowledge of excel to advanced users.

Microsoft Excel is one of the most used Office productivity software applications. You can use Excel to perform most of the day-to-day, essential to advanced financial, mathematical, statistical, and scientific calculation.

Following are the topics covered as part of this Microsoft Excel Tutorials.

Excel Basics

Section	Description & Individual Topics
Getting Started with Excel	This section covers some of the topics that lets you get started with Excel. You will learn how to the basics of Excel UI, Ribbon, Quick Access Toolbar, Dialog box, Shortcuts etc. Excel Ribbon \| Change Theme \| Themes – Advanced \| Save in XLS format \| Save as PDF \| Export to MHTML \| Export to PDF \| Export to Text File \| Export as HTML \| Save in 97-2003 format \| Quick Access Toolbar in Microsoft Excel \| Spin Control Example \| Add a Comment \| Show/Hide All Comments \| Hide Comment Indicators \| Change Comment Box Shape \| Insert Picture into Comment Box \| Dialog Box Launcher \| Show Developer Tab \| Show/Hide Formula Bar \| Developer Tab \| Status Bar \| Dialog Boxes in Excel \| Undo & Redo \| Task Panes
Workbook & Worksheets	A Workbook is just your Excel file. Each Workbook contains multiple worksheets. A worksheet is a collection of cells to store and manage your data. This section covers everything you need to know about Excel Worksheet and Workbook. Insert/Delete Worksheet \| Hide Workbook \| Hide Sheet \| Unhide Sheet \| Move/Copy Worksheets \| Copy Multiple Worksheets \| Consolidate WorkSheet \| Split WorkSheets \| Clear Hyperlinks \| Remove All Hyperlinks \| Freeze Panes \| Group/UnGroup WorkSheets \| Zoom In/ Zoom Out \| View Multiple Workbooks \| Auto-Recover \| Advanced Auto Recover \| Recover , Backup & Restore \| Find & Select \| Remove Linebreaks
Excel Files & Templates
Excel Cells and Ranges	Move Columns \| Insert Sequence Number \| Column Width & Row Height \| Swap Cell Contents \| Delete Hidden Rows & Columns \| Fill Handle \| Apply Formula without Auto Fill \| Wrap Text \| Wrap Text – Advanced \| Insert Bullets \| Auto Fill \| Flash Fill \| Custom Lists \| Hide/UnHide Columns \| Fibonacci Sequence \| Insert Picture \| Merge Cells \| Multiple Lines in Single Cell \| Union & Intersect Operator
Data Formatting	Remove Time from Date Time \| Highlight Alternate Rows with Conditional Formatting \| Highlight Alternate Rows with Format as Table \| Convert Date to Week Day \| Fill Blank Cell with a Value using Go To Special \| Custom Cell Formatting \| Delete Empty Rows with Go To Special \| Switch Rows to Columns with Go To Special Transpose \| Auto Fit \| Format Cells \| Decimal Places \| Fractions \| Format Painter \| Cell Styles \| Custom Number Format \| Numbers to Text Formatting \| Text to Number Formatting \| Currency vs Accounting Formatting \| Date & Time Format \| Avoid Automatic Data Format \| Superscript & Subscript \| Copy Visible Cells with Go To Special \| Row Differences with Go To Special \| Delete Blank Rows using Go To Special \| Find Blank Cells

Excel Essentials

Section	Description & Individual Topics
Printing	Print Title on Every Page \| Header & Footer \| Header & Footer – Advanced \| Resize Print Area \| Print WorkSheet \| Print WorkSheet – Advanced \| Workbook Views \| Page Break \| Print Comments \| Print Area \| Print GridLines & Headings \| Change Printed Gridline Color \| Print Center on Page \| Insert Page Numbers \| Print Titles
Customize	Change Page Orientation \| Orientation of Text in Cell \| Show/Hide Grid Lines \| Watermark
Protection & Security	Lock Cells \| Protect Sheet \| Protect WorkBook with Password \| Mark as Final \| Mark as Read-Only
Share	Embed PDF
Data Validations	Date Validation \| Restrict to Number/Decimal \| Remove Data Validations \| Simple Drop Down List \| Drop Down List \| Auto Populate on Drop Down Selection \| Drop Down List with Other Worksheet Data \| Color Coded Drop Down List \| Find Cells with Data Validations \| Find Invalid Data \| Named Range \| Dynamic Named Range \| Copy Cell Validation Rule \| Number & Text Filters \| How to use Filters? \| Date Filters
Excel Tables & Illustrations	Flowchart
Excel Keyboard Shortcuts	Excel Options Dialog \| Page Orientation Shortcut \| Format Cell Dialog \| Repeat Command \| Scroll Worksheet without Active Cell Change \| Useful Keyboard shortcuts in Microsoft Excel 2016 that you must know – Part 1

Excel Formulas & Functions

Section	Description & Individual Topics
Formulas & Functions Basics	Formula & Functions – Getting Started \| Paste Options \| Sum Alternate Rows with SUMIF \| Duplicate Values with COUNTIF \| Get Count of an Item with COUNTIF \| Advanced COUNTIF \| Hide & Lock Formulas
Cell References	Cell References – Basics \| External References \| 3-D Reference \| Copy Formula \| Circular References
Conditional Analysis/ Logical	Logical Functions – Overview \| IF Statement \| Switch Function \| IFS \| OR \| Comparison Operators
Mathematical Operation Functions	Subtract \| Calculate Percentage \| Square Root \| Random Number with RANDBETWEEN \| Random String with RANDBETWEEN \| Centimeter to Inches using CONVERT \| Unique Random Number \| Modulus \| Even Function in Excel \| Decimal Function \| BASE \| ARABIC \| ABS \| COMBINA \| FLOOR \| COMBIN \| FACTDOUBLE \| FACT \| ODD \| MUNIT \| MOD \| MINVERSE \| MDETERM \| LOG10 \| LCM \| LN \| LOG \| INT \| GCD \| PRODUCT \| SUMIFS \| QUOTIENT \| POWER \| ROMAN \| SUMIF \| RAND \| PI \| SUM \| SUMX2PY2 \| SUMX2MY2 \| SUMXMY2 \| SUMSQ \| RANDBETWEEN \| SIGN \| SQRT
Rounding Functions	MRound, Ceiling & Floor \| Round \| INT & Trunc \| Round Down & Round Up \| Even, Odd, IsEven, IsOdd \| FLOOR.PRECISE \| FLOOR.MATH \| MROUND \| ROUNDDOWN \| ROUND \| ROUNDUP \| CEILING.PRECISE \| CEILING.MATH \| CEILING
Text Functions	TEXT Function – Basics \| Lower \| Title Case with PROPER \| Text to Column Wizard \| Find Nth Occurence of Text \| Merge Column \| Prefix/Suffix with CONCATENATE \| Remove 1st and Last Character with RIGHT & LEFT \| Remove Leading Spaces with TRIM \| Count Number of Words \| Text to Column Wizard \| Seperate Strings \| FIND \| Search \| IsNumber & Search \| Substitute Function \| Find Function \| EXACT Function \| FIXED \| Concatenate \| DOLLAR \| CONCAT \| CODE \| CLEAN \| CHAR \| REPT \| LEN \| SEARCH \| RIGHT \| NUMBERVALUE \| REPLACE \| PROPER \| UNICHAR \| UNICODE \| TRIM \| SUBSTITUTE \| TEXTJOIN \| MID \| UPPER \| LOWER \| LEFT \| VALUE
Date & Time Functions	Basic Date & Time Functions \| Calculate Age with DATEDIF \| Add/Subtract Days \| Current Date with NOW() \| Current Date with TODAY() \| Subtract Two Days – Multiple Ways \| Weekend Check with WEEKDAY() \| Current Date \| Quarter of a Day \| Add/Subtract Time \| Last Day of the Month \| Weekdays \| Time Difference \| Calculate Age \| DATEDIF
Matching & Lookups Functions	Lookup Functions – Intro \| Duplicate Values with MATCH \| Two-Way Lookup \| Offset \| Index & Match \| Income Tax Calculator \| VLookup \| Case Sensitive Lookup \| LEFT Lookup \| ADDRESS \| CHOOSE \| LOOKUP \| COLUMNS \| ROW
Financial Analysis Functions	COUPDAYS \| COUPDAYSBS \| AMORLINC \| AMORDEGRC \| ACCRINTM \| ACCRINT \| IPMT \| COUPPCD \| COUPNCD \| COUPNUM \| EFFECT \| FVSCHEDULE \| ISPMT \| DURATION \| ODDFYIELD \| FV \| DB \| CUMIPMT \| DDB \| INTRATE \| CUMPRINC \| DOLLARDE \| DOLLARFR \| ODDFPRICE \| NPV \| NPER \| NOMINAL \| MIRR \| IRR \| MDURATION \| PRICE \| PMT \| PDURATION \| DISC \| PRICEDISC \| VDB \| TBILLYIELD \| PV \| PRICEMAT \| SYD \| PPMT \| RRI
Statistical Analysis Functions	Small \| Large \| Max & Min \| Aggregate \| Count Function \| AVERAGEIFS \| AVEDEV \| EXP \| AVERAGEA \| AVERAGE \| AVERAGEIF \| BINOMDIST \| MIN \| MINA \| MINIFS \| COUNTA \| COUNTBLANK \| MODE \| DEVSQ \| COUNTIFS \| COUNTIF \| FORECAST \| PERCENTILE \| NORM.S.INV \| NORM.S.DIST \| NORM.INV \| MODE.SNGL \| MODE.MULT \| HARMEAN \| MEDIAN \| MAX \| INTERCEPT \| MAXA \| MAXIFS \| GEOMEAN \| FREQUENCY
Engineering Functions	BITRSHIFT \| BITLSHIFT \| BITAND \| BIN2OCT \| BIN2DEC \| BIN2HEX \| BITOR \| DEC2HEX \| DEC2BIN \| BITXOR \| DELTA \| HEX2BIN \| DEC2OCT \| CONVERT \| COMPLEX \| IMPOWER \| IMAGINARY \| HEX2OCT \| IMSUB \| IMSUM \| IMREAL \| IMPRODUCT \| IMABS
Table & Conditional Formatting	Change Color Based on Value with Conditional Formatting
Array Formulas	Nearest Value \| SORT
Errors & Formulas	Deal with Formula Errors \| ISError \| IF Error in Depth \| Formula Auditing
Excel Function References	Convert Non-Numeric to Numeric Value

Excel Data Analysis

Section	Description & Individual Topics
Importing Data
Excel Advanced Validations	Limit No. of Characters \| Limit to Numeric Value
Worksheet Outlines
Pivot Tables	Pivot Table in Excel – Beginners Guide \| Sparklines with Pivot Tables \| Pivot Charts \| Timeline in Pivot Table \| Slicers in Excel Pivot Table \| Report Layout in Pivot Table \| Selecting, Moving & Clearing Pivot Table Data \| Subtotals & Grand Totals in Pivot Table \| Summarize by Average in Pivot Table \| Summarize by Min & Max in Pivot Table \| Nested Fields in Pivot Table \| Formatting Values for Pivot Table \| Summarizing with Blank Cells in Pivot Table \| Summarizing Pivot Table Data \| Sort a Pivot Table \| Refresh a Pivot Table
What-if Analysis
Goal Seeking & Solver	Solver Add-in \| Sensitivity Analysis \| Shortest Path Problem \| Balanced Assignment Problem \| Transportation Problem
Analysis Tool pack
Power Pivot & Power Query
Excel Data Analysis Misc	Sorting in Excel \| Sort Columns \| Reverse a List in Excel \| Sort by Color

Excel Visualization

Section	Description & Individual Topics
Excel Visualization Basics
Excel Charts	Charts in Excel – Basics \| Bar Chart \| Line Chart \| Pie Chart \| Column Chart \| Area Chart \| Data Series \| Scatter Plot \| Gauge Chart \| Custom Combo Chart \| Sparklines \| TrendLine \| Chart Sheet \| Customize Axes \| Pareto Chart \| Gantt Chart \| Thermometer Chart \| Save Excel Chart as Image \| Excel Chart Titles \| Rotate Charts & Worksheets

Excel Automation

Section	Description & Individual Topics
VBA Basics	Macros – Introduction \| Record Macros \| Add a Macro to Toolbar \| Cut, Copy, Paste in Macros \| Macro Security Settings \| Password Protect an Macro \| Swapping Two Values \| Macro Recorder \| Getting Started in Excel VBA \| MsgBox in Excel VBA \| Reverse a Text \| Remove Multiple Line Breaks Active Cell Column and Row \| Get & Set Cell Value \| Clear Cells Sheets & Worksheets \| List Worksheets in a Workbook \| Count Number of Sheets \| Protect & Unprotect Worksheets \| Open & Close WorkBook \| Loop Through All Worksheets \| Delete & Clear Worksheet \| Get Sheet Name \| Active Sheet & Select Sheet \| Create New Workbook \| Get File Path and Name \| Formulas in Excel VBA \| Saving Files \| Conditional Statements in Excel VBA \| Loops in Excel VBA \| Concatenate Strings \| Like Operator \| Copy Range of Cells \| Reverse string \| Space Function \| Remove Characters \| New Line or Carriage Returns \| Rename File \| Copy File \| Copy Worksheets \| Hide/Unhide Worksheets \| Resize Column & Row \| Mod Operator \| Union & Intersect in Excel VBA \| Logical Operators \| Variable Scope \| Count Rows & Columns in Selection \| Autofill Worksheet using VBA \| Remove Formatting using VBA \| Highlight Duplicates with Conditional Formatting in Excel VBA \| Immediate Window in VBA \| Select All Cells using VBA \| Offset Range or Cell \| Get List of All Files \| Set Column Properties \| Delete Row or Column \| Option Explicit in VBA \| Insert Row or Column using VBA \| Wrap Text \| Make Text Bold \| Change Background Color of Cell \| Merge & UnMerge Cells \| INTSTR in Excel VBA \| Convert String to Proper Case \| Split String based on Delimiter
VBA Advanced	Merge Worksheets \| Sort Worksheets \| Remove Non-Numeric Characters \| Disable Research Task Pane \| Protect Worksheets \| Created & Modified Date Time of File using VBA \| Check Prime Number in Excel VBA \| Check if File or Folder Exists \| Delete File \| Hide Worksheet Tabs \| Find & Highlight Duplicate Values \| Using VLookup in Excel VBA \| Count Words in Spreadsheet
User Forms	Checkboxes \| Radio Buttons \| Data Forms
Custom Worksheet Functions

Excel Extras

Section	Description & Individual Topics
How Tos	Calculator \| Text to Speech \| Display Blank Cell on Zero \| List File Names \| Auto Move Cell Pointer \| Vertical & Horizontal Scrollbar \| List of Files \| Created & Last Modified Time of Excel File \| Hide Page Breaks \| Insert Current File Name \| Insert Current File Path to Cell \| Add Additional Author \| Turn off Start Screen \| Insert CheckMark \| Remove Multiple Hyperlinks in Workbook \| Multiple Checkboxes \| Drop-down Calender
Miscellaneous	Spell Check \| Use Spell Check \| Watch Window \| OneDrive & Excel \| Excel Online \| Insert Excel into Word \| Maps in Excel \| Tick Symbol

Section

Description & Individual Topics

How Tos

Miscellaneous