Microsoft Excel | Knowledge Base
Welcome to Excel Champs
100: Microsoft Excel
101: Introduction to Excel
102: Designing a Spreadsheet
103: Introduction to Formulas
104: Basic Formatting
105: Working With Worksheets
106: Linking Data With Formulas
107: Importing and Exporting Data
108: Sort, Filter, Freeze, and Split
109 Page Setup and Printing
110: Charts and Sparklines
201: Troubleshooting Formulas
202: Advanced Formatting
203A: Conditional Formatting 1
203B: Conditional Formatting 2
203xxx: Introduction to Excel Functions
204A: IF Statements 1
204B: IF Statements 2
205: Combining and Separating Text
206: Working With Dates
207: Groups, Outlines, and the Subtotal Dialog Box
208: Using VLOOKUP and Quick Analysis
301A: Working With Tables and the SUBTOTAL Function
301B: Tables and the SUBTOTAL Function 2
302: Financial Functions
303A What-If Analysis Tools Goal Seek
303B: What-If Analysis Tools, Scenario Manager
303C: What-If Analysis Tools, Solver
304A: PivotTables 1
304B: PivotTables 2
305: Finishing Touches and Worksheet Protection
401: Paste Special and Go To Special
402: Graphics, Pictures, Clip Art, and SmartArt
403: Comments, Track Changes, and Consolidating Worksheets
501: Recording and Editing Macros
502: Adding Interactivity to Worksheets
601: Database Functions
602: Date and Time Functions
603: Information Functions
604: Logical Functions
605: Lookup and Reference Functions
606: Math and Trig Functions
607: Statistical Functions
608: Text Functions
609: Creating Custom Functions