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
Excel Essentials
Excel Formulas & Functions
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
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 |