LONESTAR
ACADEMY
Courses
Log In
Join Free
Home
Courses
IT: Cybersecurity, Web & Productivity
Excel Foundations for Financial Analysis
Curriculum
1 Section
24 Lessons
30 hours
Expand all sections
Collapse all sections
Unit 1 — Excel Foundations for Financial Analysis
24
1.1
Exploring Excel’s User Interface
20 mins
1.2
Understanding Operators
20 mins
1.3
Applying Basic Formatting Commands
20 mins
1.4
Freezing Panes
20 mins
1.5
Comparing Data Ranges to Excel Tables
20 mins
1.6
Navigating with VLOOKUP
20 mins
1.7
Reworking Text without Retyping
20 mins
1.8
Making Basic Formulaic Decisions
20 mins
1.9
Sifting Through Data Dynamically
20 mins
1.10
Tracking Precedent and Dependent Cells
20 mins
1.11
Finding and Replacing Data within Cells
20 mins
1.12
Introducing Excel charts
20 mins
1.13
Formatting with Quick Analysis
20 mins
1.14
Unlocking and Protecting Worksheet Cells
20 mins
1.15
Automating with Flash Fill
20 mins
1.16
Contrasting Code Versus Automation
20 mins
1.17
Undoing Actions
20 mins
1.18
Deleting Temporary Files
20 mins
1.19
Entering and Editing Data
20 mins
1.20
Exploring the Order of Operations
20 mins
1.21
Exploring the Format Cells Dialog Box
20 mins
1.22
Utilizing the Sort Feature
20 mins
1.23
Creating Excel Tables
20 mins
1.24
Hoisting HLOOKUP
20 mins
This content is protected, please
login
and
enroll
in the course to view this content!
Modal title
Main Content