Fundamentals of Excel, Data Analysis & VBA
Step-by-step reference guides to master Microsoft Excel. Build a strong foundation in data analysis techniques and apply new skills to projects.
Range
Formulas & Functions
Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Templates
Data Validation
Keyboard Shortcuts
Share
Protect
Protect
Count and Sum Functions
Logical Functions
Cell references
Date & Time
Text functions
Lookup & references
Financial functions
Statistical Functions
Round numbers
Formula errors
Array formulas
Sort
Filter
Conditional formatting
Pivot tables
What-if analysis
Solver
Analysis ToolPak
Histogram
Descriptive Statistics
Anova
F-test
t-Test
Moving average
Exponential smoothing
Correlation
Regression
Create a macro
MsgBox
Workbook & Worksheet objects
Range objects
Variables
If-Then statements
Loop
Macro errors
String manipulation
Date & Time
Events
Array
Function and Sub
Application object
Active X Controls
Userform