Master Categories and Topic Ideas

EXCELORA · EXCEL LEARNING HUB

Master Categories and Topic Ideas

A working editorial map for planning future Excelora articles.

This is a working idea bank, not a promise that every idea will become a separate post. Combine overlapping ideas where that creates a better learning path. Keep this page in Draft until the category plan is confirmed.

Excel Basics

  1. What Is Microsoft Excel?
  2. Why Use Microsoft Excel?
  3. Excel Versions and Microsoft 365
  4. Understanding the Excel Interface
  5. Ribbon, Tabs and Groups
  6. Quick Access Toolbar
  7. Formula Bar and Name Box
  8. Workbook and Worksheet
  9. Rows, Columns and Cells
  10. Cell Addresses and References
  11. Selecting Cells and Ranges
  12. Entering Data in Excel
  13. Editing Data
  14. Copy, Cut and Paste
  15. Autofill and the Fill Handle
  16. Moving Data
  17. Undo and Redo
  18. Find and Replace
  19. Inserting and Deleting Rows and Columns
  20. Saving, Opening and Closing Workbooks
  21. Formatting Cells
  22. Font Formatting
  23. Alignment
  24. Borders and Cell Fill
  25. Number Formats
  26. Date and Time Formats
  27. Row Height and Column Width
  28. Format Painter
  29. Cell Styles
  30. Clear Formatting
  31. Sorting Data
  32. Filtering Data
  33. Creating Excel Tables
  34. Freeze Panes
  35. Data Validation — Introduction
  36. Creating Drop-down Lists
  37. Conditional Formatting — Introduction
  38. Adding and Deleting Worksheets
  39. Renaming Worksheets
  40. Moving and Copying Worksheets
  41. Hiding and Unhiding Worksheets
  42. Worksheet Tab Colors
  43. Protecting Worksheets
  44. Basic Workbook Protection
  45. Print Preview
  46. Page Orientation and Margins
  47. Print Area
  48. Page Breaks
  49. Headers and Footers
  50. Printing Excel Worksheets

Formulas & Functions

  1. Formula Fundamentals
  2. Entering and copying formulas
  3. Arithmetic and comparison operators
  4. Order of operations
  5. Relative, absolute and mixed references
  6. Common formula errors
  7. SUM, AVERAGE, COUNT and COUNTA
  8. MAX, MIN, LARGE and SMALL
  9. ROUND, ROUNDUP, ROUNDDOWN and MROUND
  10. IF, IFS and nested IF
  11. AND, OR, NOT and IFERROR
  12. SUMIF and SUMIFS
  13. COUNTIF and COUNTIFS
  14. AVERAGEIF and AVERAGEIFS
  15. XLOOKUP, VLOOKUP and HLOOKUP
  16. INDEX, MATCH and XMATCH
  17. Text functions: LEFT, RIGHT, MID and LEN
  18. TRIM, CLEAN, SUBSTITUTE and REPLACE
  19. TEXTJOIN, CONCAT and TEXT
  20. Date and time functions
  21. Dynamic arrays: UNIQUE, SORT and FILTER
  22. Named ranges and structured references
  23. Debugging and optimizing formulas

Excel Tips & Tricks

  1. Everyday Excel productivity tips
  2. Fast navigation around worksheets
  3. Fill Handle techniques
  4. Paste Special uses
  5. Find and Replace techniques
  6. Quick formatting methods
  7. Working with large worksheets
  8. Avoiding common spreadsheet mistakes
  9. Practical workbook organization
  10. Excel productivity best practices

Excel Shortcuts

  1. Essential keyboard shortcuts
  2. Navigation shortcuts
  3. Selection shortcuts
  4. Editing shortcuts
  5. Formatting shortcuts
  6. Formula shortcuts
  7. Row and column shortcuts
  8. Worksheet and workbook shortcuts
  9. Windows versus Mac shortcut differences
  10. Building a personal shortcut reference

Data Management

  1. Excel Tables
  2. Sorting by multiple columns
  3. Custom sorting
  4. Filtering text, numbers and dates
  5. Finding and removing duplicates
  6. Finding blank cells
  7. Handling missing data
  8. Converting text to numbers
  9. Fixing date formats
  10. Text to Columns
  11. Flash Fill
  12. Splitting and combining columns
  13. Data Validation
  14. Dependent drop-down lists
  15. Preparing data for analysis
  16. Creating a clean data structure

Charts & Dashboards

  1. Choosing the right chart
  2. Creating a first chart
  3. Column and bar charts
  4. Line charts
  5. Pie and doughnut charts
  6. Scatter charts and histograms
  7. Combo charts
  8. Chart titles, axes and labels
  9. Dynamic charts
  10. What is an Excel dashboard?
  11. Planning dashboard metrics
  12. KPI cards and summary tables
  13. Interactive dashboard controls
  14. Sales dashboard project
  15. Expense dashboard project
  16. Dashboard design best practices

PivotTables

  1. What is a PivotTable?
  2. Creating your first PivotTable
  3. Rows, Columns, Values and Filters
  4. Changing value calculations
  5. Sorting and filtering PivotTables
  6. Grouping dates and numbers
  7. Showing values as percentages
  8. Running totals and difference from
  9. Refreshing PivotTables
  10. PivotTables from Excel Tables
  11. What is a PivotChart?
  12. Creating slicers and timelines
  13. Connecting slicers to multiple PivotTables
  14. Interactive Pivot reports

Data Analysis

  1. What is data analysis in Excel?
  2. Preparing data for analysis
  3. Summarizing and comparing data
  4. Finding trends and outliers
  5. Percentage of total and percentage change
  6. Growth rates and variance analysis
  7. Ranking data and Top-N analysis
  8. Median, mode and standard deviation
  9. Variance, percentiles and quartiles
  10. Descriptive Statistics
  11. What-If Analysis
  12. Goal Seek and Scenario Manager
  13. Data Tables
  14. Trendlines and moving averages
  15. Forecasting with Excel
  16. Analysis ToolPak
  17. Correlation and regression
  18. Sales, expense and customer analysis projects

Power Query

  1. What is Power Query?
  2. Power Query Editor interface
  3. Importing Excel and CSV files
  4. Importing files from a folder
  5. Changing data types
  6. Removing rows and columns
  7. Removing duplicates and blank rows
  8. Replacing, trimming and cleaning values
  9. Splitting and merging columns
  10. Handling nulls and errors
  11. Grouping and custom columns
  12. Pivoting and unpivoting data
  13. Merge Queries and join types
  14. Append Queries
  15. Combining monthly files
  16. Parameters and reusable queries
  17. Refresh and load options
  18. Introduction to M language
  19. Cleaning a messy dataset project
  20. Building a refreshable data pipeline

VBA & Automation

  1. What is VBA and a macro?
  2. Macro security basics
  3. Enabling the Developer tab
  4. Opening the VBA Editor
  5. Writing and running a first macro
  6. Recording and editing macros
  7. Variables and data types
  8. IF statements and Select Case
  9. For and Do loops
  10. Workbook, Worksheet and Range objects
  11. Reading and writing cell values
  12. Finding the last row and column
  13. Formatting and sorting with VBA
  14. Message boxes and input boxes
  15. Debugging VBA code
  16. Error handling
  17. Arrays and custom functions
  18. Automated data cleaning project
  19. Automated report generation project
  20. Automated workbook consolidation

Excel & AI

  1. Understanding AI features in Excel
  2. AI-assisted formula explanations
  3. Using AI to brainstorm formula approaches
  4. Checking AI-generated formulas
  5. AI for data-cleaning ideas
  6. AI-assisted chart and dashboard planning
  7. Writing effective prompts for spreadsheet tasks
  8. Privacy and sensitive data when using AI
  9. Verifying outputs and preventing errors
  10. Responsible AI-assisted Excel workflows

Templates & Examples

  1. Personal budget template
  2. Monthly expense tracker
  3. Sales tracker
  4. Inventory tracker
  5. Attendance sheet
  6. Project task tracker
  7. Invoice template
  8. Employee information table
  9. Data-cleaning practice dataset
  10. Formula practice workbook
  11. PivotTable practice dataset
  12. Dashboard sample project
Editorial rule: Before drafting a post, check the existing article list, avoid duplicate topics, choose the best category, and plan useful internal links to related lessons.

Excel Learning Hub (Excelora) · https://excelora.blogspot.com/

Comments

Post a Comment