Excellence with Excel

Pre-Course Survey
Discussion Forum: Excellence with Excel
Download Practice Files
Intro to Excel
Creating New Workbook
Intro to Interface of Excel
Inserting, Renaming & Deleting Worksheets
Move & Copy Worksheets
Printing Workbook
Row, Column, Cell
Inserting & Deleting Row & Column
Deleting Cells
Cell Selection
Fixing Height & Width of Cells
Freezing Row & Column
Hide and Unhide Row & Column
Basics of Entering Data - Part 1
Autofill Data
Duplicate Removal
Merge Text Values of Different Cells
Cell Merge
Data Format
Cell Formatting
Basics of Entering Data - Part 2
Paste Options
Cell Locking
Naming Ranges
Inserting Objects
Inserting Symbols
Inserting Shapes
Inserting Icons
Inserting Pictures
Conditional Formatting
Conditional Formatting – Part 1
Conditional Formatting – Part 2
Conditional Formatting – Part 3
Basic Text Functions
Text Concatenation
Upper Case & Lower Case Text
Date Functions
Day, Month, Year
WeekDay
Realtime Date & Time
Basic Arithmetic Operations
Addition
Subtraction
Division
Multiplication
Arithmetic Operation – Combined
Some Useful Stats Functions
SUM
COUNT
AVERAGE
MIN & MAX
A tricks to know
Subtotal
Functions for Finding Data
Vlookup and Hlookup
Index-Match
Data Validation, Array and Sheet Referencing
Data Validation – Creating a Drop Down List with Manual Input
Removing Data Validation
Data Validation – Creating Drop Down List with Data from separate Sheet
Data Validation – Input and Error Message
Array and Sheet Referencing
Data Cleaning & Mining
Iferror Function
Clean Function
More Cleaning
Trim Function
Text to Value
Left, Right, Find, Length
Substitute Function
Logic Functions
Logic-CountIfs
Logic – Sumifs
Logic – If
Logic – And, Or
Assessment of Basic MS Excel Knowledge
Mid-Quiz: Assessment of Basic MS Excel Knowledge
 2 Quizzes
Basic Excel Final Quiz 1
Basic Excel Final Quiz 2
Pivot Table
Pivot Table – Introduction
Pivot Table – Part 1
Pivot Table – Part 2
Pivot Table – Part 3
Pivot Table – Part 4
Pivot Table – Part 5
Solution to Pivot Table Homework
Common Data Visualization Methods
Column Chart – Part 1
Column Chart – Part 2
Bar Chart
Pie Chart
Pivot Chart
Fundamentals of Pivot Chart
Pivot Chart with Slicer
Pivot Chart with Date Grouping
Important Statistical Functionality of Excel
Variance Calculation in Excel
Standard Deviation in Excel
Covariance in Excel
Correlation in Excel
R-Squared Value Calculation in Excel
Descriptive Statistics using Data Analysis Toolpack in Excel
Multiple Correlation in Excel
Advanced Data Visualization & Simple Forecasting
Bar Chart for Percentages
Histogram
X-Y Scatter Plot and Building Simple Model
Forecast Function
Combo Chart
Data Visualization - Special Topics
Chart Axis Scaling
Log Scale
Log Plot
Post Advanced Data Visualization
Tree Map
Heat Map
Box Plot
Essential Financial Analysis for Evaluation & Decision-Making
NPV
IRR
Initial Investment Evaluation with NPV & IRR
Calculating Payment per Period
Reading: Payment Per Period for Start of the Period Payment
Payback Period & Comparing Alternatives
Advanced Data Analysis for Decision Making
Scenario Analysis: Single Variable
Sensitivity with Multiple Separate Variables
Scenario Analysis: Two Variables
Scenario Simulation and Decision Making
Optimization with Solver
Optimization with Solver – Part 1
Optimization with Solver – Part 2
At the End
What’s Next?
User Feedback on This Course
Capstone One
Capstone Two
Previous Lesson
Next Lesson

Inserting, Renaming & Deleting Worksheets

Excellence with Excel Inserting, Renaming & Deleting Worksheets

Previous Lesson
Back to Course
Next Lesson
×

Cart