Embark on a comprehensive journey through Microsoft Excel with this extensive 5-hour tutorial designed for beginners. Master the interface, formulas, functions, data analysis tools, and advanced features like Pivot Tables, Macros, and VBA. Learn essential skills such as formatting, chart creation, data validation, and financial modeling. Explore powerful tools like Goal Seek, Solver, and Scenarios for complex problem-solving. Enhance productivity with time-saving techniques, custom styles, and automation. By the end of this course, gain the confidence to manipulate data, create insightful visualizations, and leverage Excel's full potential for personal and professional use.
Overview
Syllabus
Intro
Startup Screen
Increase Screen Size
Quick Access Toolbar
Ribbon
Common Shortcuts
Newline in Cell
Sheets
Formula Bar / Cells
Views
Formatting
Alignment
Dates / Custom Dates
Formulas
Auto Sum
Percentages
Relative / Absolute References
Date Calculation Error
Formula Omits Adjacent Cells
Order of Operation
Superscript
Common Functions
Average
Count
Max
Min
If
Concatenate
Vlookup
Index
Subtotal
Search for Function / Help
Modulus
Power
Ceiling
Floor
Length
Replace
Substitute
Changing Case
Date / Time Functions
Templates
Design Attractive Worksheets
Themes
Moving Tables
Merge Cells
Borders
Currency Formatting
Percentage Formatting
Format Painter
Create Custom Style
Change Style
Accent Rows
Conditional Formatting
Import Images
Import Shapes
Import Icons
3D Models
Charts
Recommend Chart
Filter Chart
Move Chart
Pie Charts
Printing Options
Page Layout
Move Page Cutoff
Create Template
Fixing Errors
IFERROR Don’t Show Formula Errors
Change Formula in Whole Column
Save Template
Import CSV
See All Sheets
Add Row
Sorting
Multi Column Sort
Sort by Month
Filter
Subtotal Advanced
Find Duplicates
Tables
Table Design Remove Duplicates
Sum vs. Subtotal
DSUM Database Sum
Calculations based on Conditions
DCOUNT Database Count
Export Data
Validating Data
Defined Minimum Length
Verify Email ISNUMBER REGEX
Valid Options from List / Data Validation
Data Validation Defined Length
Validation Custom Error Message
Split Column by Delimiter
Convert Date into Month
RANDBETWEEN Randomly Generate Values
Pivot Tables
Grouping
Formatting Pivot Tables
Showing Average
Value Field Settings
Pivot Charts
Slicer
Power Pivot
Link Tables
Using Calculations in Power Pivot
KPI Key Performance Indicator
Fixing the Budget Template
Named Ranges
Named Range Negative
Fixing Strange Excel Errors
Jump to Named Ranges
Name Manager
Conditional Characters
IF
OR
COUNTIF
Trace Precedents / Dependence
Show Formulas
Use Values from One Worksheet in Another
Watch Window
Password Protecting Worksheets
Turn Off Protection
Error Checking
Goal Seek
Paying off a Loan
Formula Dialog
How to Become a Millionaire
FV Future Value
Data Table
Solver
Maximize Profit Inventory Management
SUMPRODUCT
Scenarios
Gross Profit Scenarios
Macros
Create a Macro
Edit a Macro
Visual Basic for Applications
Create Macro Button
Taught by
Derek Banas
