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. 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
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
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

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
Customize	Change Page Orientation \| Orientation of Text in Cell
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
Excel Tables
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
Conditional Analysis/ Logical
Mathematical Operation Functions	Subtract \| Calculate Percentage \| Square Root \| Random Number with RANDBETWEEN \| Random String with RANDBETWEEN \| Centimeter to Inches using CONVERT \| Unique Random Number
Rounding Functions	Round
Text Functions	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
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()
Matching & Lookups Functions	Lookup Functions – Intro \| Duplicate Values with MATCH \| Two-Way Lookup \| Offset \| Index & Match \| Income Tax Calculator \| VLookup
Financial Analysis Functions
Statistical Analysis Functions	Small \| Large \| Max & Min
Table & Conditional Formatting	Change Color Based on Value with Conditional Formatting
Array Formulas	Nearest Value
Errors & Formulas
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
What-if Analysis
Goal Seeking & Solver
Analysis Tool pack
Power Pivot & Power Query
Excel Data Analysis Misc	Sort Columns

Excel Visualization

Section	Description & Individual Topics
Excel Visualization Basics
Excel Charts

Excel Automation

Section	Description & Individual Topics
VBA Basics	Reverse a Text \| Remove Multiple Line Breaks
VBA Advanced	Merge Worksheets \| Sort Worksheets \| Remove Non-Numeric Characters \| Disable Research Task Pane \| Protect Worksheets \| Created & Modified Date Time of File using VBA
User Forms	Checkboxes \| Radio Buttons
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
Miscellaneous	Spell Check \| Use Spell Check \| Watch Window