Functions, Data Analysis, Presentation and Finance w/ Excel
What you'll learn
- Create and write advanced functions.
- Create charts and buttons
- Sort and filter with regular and advanced filters
- Build pivot tables and calculated columns
- Use randomness for model prediction
- Learn to use the Data Model and Power BI.
Requirements
- None
Description
This course teaches Microsoft Excel, Power Pivot and Power BI. It starts from the beginning and goes all the way through to (and including) VBA. Excel is an extremely powerful tool, one which we will see can be used to understand, analyze and present data. It can be used to build financial models as well. It is an all encompassing tool that blends data analysis with data presentation (using pivot tables and the data model).
We will go through buttons, charts, data validation and conditional formatting; as well as all the regular functions.
It is based on a well worn approach of practice, practice and more practice. Each section has videos and written instructions to hone students' skills.
Who this course is for:
- Everyone
Course content
Introduction2 lectures • 4min
- *IntroductionPreview01:43
- *How to Maximize this Course02:36
Excel Tools and Organization2 lectures • 9min
Functions and All They are Cracked Up To Be2 lectures • 11min
Buttons and Path Generation3 lectures • 20min
Interactive Charts1 lecture • 4min
Creating Data in Excel with VBA1 lecture • 4min
Financial Functions6 lectures • 41min
Formatting and Financial Data1 lecture • 3min
Random Numbers, Monte Carlo and Stock Returns8 lectures • 39min
The "IF" Functions, Database Functions, Filters, and Trendlines7 lectures • 34min
Instructor
![Matthew Fried](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.5 Instructor Rating
- 621 Reviews
- 1,906 Students
- 10 Courses
Matthew Fried teaches full time. He is an educational professional who has many years experience in guiding students to reach their full potential. He has taught computers, networking, math, and finance for nearly a decade. He has taught graduate and undergraduate courses in each subject. He has developed student-centric platforms and feels very strongly that every student can accomplish their goals.
He is full time in Lander College and a Lecturer in SUNY Farmingdale. He teaches courses in programming and derivatives in Queens College and University of Connecticut. He regularly teaches C++, C#, Python, Networking, Financial Modelling and more.