IIRF Online > Finance & Accounting > Financial Modeling & Analysis > Excel > DavidsonX: Excel for Beginners
DavidsonX: Excel for Beginners by Edx
Mastering a basic skills in Excel will open the door to new opportunities, jobs, and more advanced skills that can help you be more efficient in your work or advance your career in your current or a future position. Come join us and reduce barriers to working with Excel!
Course Highlights
- Confidence with spreadsheet layout, anatomy, and terminology
- Good practices for data entry, storage, and manipulation in spreadsheets
- Common methods of data manipulation and summary such as sorting, filtering, writing simple equations, and using pivot tables
- Common methods of data visualization using charts
Skills you will learn!
Curriculum
4 Topics
Excel Orientation and Spreadsheet Basics
Excel Data Types
Entering Data
Spreadsheet Setup
4 Topics
Bar Charts Simple and Clustered
Scatterplots
Pie and Stacked Column Charts
Combining Plot Types
4 Topics
Formulas and Functions in Excel
Absolute vs. Relative Cell References
Sorting & Filtering Data in Excel
Conditional functions
4 Topics
Converting Data Ranges to Tables
Unleashing the Power of Pivot Tables: Simple Tables and Charts
Unleashing the Power of Pivot Tables: Answering Complex Questions
Introducing the Course Project
DavidsonX: Excel for Beginners
Related Excel Courses
Thank You!
Your review has been submitted successfully.