We may earn an affiliate commission when you visit our partners.
Craig Golightly
Excel is used for many jobs, and while you can invent all of your own functions, knowing how to use the built-in functions can save you time and frustration. In this course, Excel Statistics and Finance Function Playbook, you will get an in-depth look at common statistics and finance functions in Excel. First, you will learn the SUMIFS, AVERAGEIFS, and COUNTIFS functions. Next, you will discover the NPV, FV, and PV functions. Finally, you will explore how to apply these functions in various real-life scenarios. When you’re finished with this course, you will have the skills and knowledge of excel statistics and finance functions...
Read more
Excel is used for many jobs, and while you can invent all of your own functions, knowing how to use the built-in functions can save you time and frustration. In this course, Excel Statistics and Finance Function Playbook, you will get an in-depth look at common statistics and finance functions in Excel. First, you will learn the SUMIFS, AVERAGEIFS, and COUNTIFS functions. Next, you will discover the NPV, FV, and PV functions. Finally, you will explore how to apply these functions in various real-life scenarios. When you’re finished with this course, you will have the skills and knowledge of excel statistics and finance functions...
Read more
Excel is used for many jobs, and while you can invent all of your own functions, knowing how to use the built-in functions can save you time and frustration. In this course, Excel Statistics and Finance Function Playbook, you will get an in-depth look at common statistics and finance functions in Excel. First, you will learn the SUMIFS, AVERAGEIFS, and COUNTIFS functions. Next, you will discover the NPV, FV, and PV functions. Finally, you will explore how to apply these functions in various real-life scenarios. When you’re finished with this course, you will have the skills and knowledge of excel statistics and finance functions needed to create accurate reports and compare financial scenarios. Software required: Excel
Register for this course and see more details by visiting:
OpenCourser.com/course/yuynsh/excel
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
Useful in a finance workspace from large corporation to small business
Teaches finance and statistic functions such as NPV, FV, PV, and more
Taught by the excel expert Craig Golightly
Covers common functions that are essential for financial analysis in many industries
Course assumes some prior knowledge of Excel
Save this course
Save Excel Statistics and Finance Function Playbook to your list so you can find it easily later:
Save
Save
Activities
Coming soon
We're preparing activities for
Excel Statistics and Finance Function Playbook.
These are activities you can do either before, during, or after a course.
Career center
Learners who complete Excel Statistics and Finance Function Playbook will develop knowledge and skills
that may be useful to these careers:
Risk Analyst
Risk Analyst
Risk Analysts identify, assess, and manage risks for organizations. They use financial and statistical models to evaluate potential risks and develop strategies to mitigate them. The Excel Statistics and Finance Function Playbook can provide a hands-on experience with the financial and statistical functions needed in Risk Analysis.
Financial Manager
Financial Manager
Financial Managers oversee the financial health of an organization. They develop and implement financial plans, manage investments, and provide financial advice. The Excel Statistics and Finance Function Playbook can expose you to the financial tools and functions used by Financial Managers.
Budget Analyst
Budget Analyst
Budget Analysts help organizations plan and manage their finances. They create and monitor budgets, forecast revenue and expenses, and provide financial advice. The Excel Statistics and Finance Function Playbook can teach you useful financial forecast and budgeting functions.
Portfolio Manager
Portfolio Manager
Portfolio Managers oversee investment portfolios for clients. They make investment decisions, manage risk, and provide financial advice. The Excel Statistics and Finance Function Playbook may help you to learn the essential financial functions used by Portfolio Managers.
Investment Banker
Investment Banker
Investment Bankers help companies raise capital and provide financial advice. They analyze financial data, develop financial models, and execute transactions. The Excel Statistics and Finance Function Playbook may help build a foundation in the financial functions needed in Investment Banking.
Accounting Manager
Accounting Manager
Accounting Managers oversee the financial operations of an organization. They prepare financial statements, manage cash flow, and ensure compliance with accounting regulations. The Excel Statistics and Finance Function Playbook may help you build a foundation in the financial functions that Accounting Managers use.
Quantitative Analyst
Quantitative Analyst
Quantitative Analysts use mathematical and statistical models to solve complex business problems. They work in various industries, including finance, healthcare, and technology. The Excel Statistics and Finance Function Playbook can introduce you to the quantitative functions and tools used by professionals in this field.
Actuary
Actuary
Actuaries use financial models to calculate the probability of an event occurring. They may work with insurance companies to determine customer rates. They may also provide guidance on investment strategy for clients. With the Excel Statistics and Finance Function Playbook, you may explore some of the financial modeling skills that Actuaries use often.
Business Analyst
Business Analyst
Business Analysts identify and solve business problems using data and analysis. They work with stakeholders to define requirements, develop solutions, and measure results. The Excel Statistics and Finance Function Playbook can help you build some of the data analysis and financial modeling skills needed in Business Analysis.
Data Analyst
Data Analyst
Data Analysts collect, clean, and analyze data to provide insights into business performance. They use this information to identify trends, make recommendations, and improve operations. The Excel Statistics and Finance Function Playbook may give you hands-on practice with functions often used by Data Analysts.
Financial Analyst
Financial Analyst
Financial Analysts make informed recommendations on investment decisions. They do so by applying financial skills to evaluate the performance of a company and its stock. Using the Excel Statistics and Finance Function Playbook may help build a foundation in some of the financial modeling skills needed for this role.
Data Scientist
Data Scientist
Data Scientists use data to solve business problems and improve decision-making. They use statistical and machine learning methods to analyze data and build predictive models. The Excel Statistics and Finance Function Playbook may introduce you to essential statistical and financial functions utilized by Data Scientists.
Market Research Analyst
Market Research Analyst
Market Research Analysts study market conditions to understand consumer behavior. They use this information to help businesses make informed decisions about product development and marketing. The Excel Statistics and Finance Function Playbook may expose you to the statistical and financial functions that are commonly used by Market Research Analysts.
Statistician
Statistician
Statisticians collect and analyze data to identify patterns and trends. This data can be used to make predictions, solve problems, and improve decision-making. Taking the Excel Statistics and Finance Function Playbook may expose you to the types of formulas and functions used by Statisticians.
Machine Learning Engineer
Machine Learning Engineer
Machine Learning Engineers design and build machine learning models. They work with data scientists to develop and deploy machine learning solutions. The Excel Statistics and Finance Function Playbook may provide exposure to some of the data analysis and finance functions used by Machine Learning Engineers.
For more career information including salaries, visit:
OpenCourser.com/course/yuynsh/excel
Reading list
We've selected ten books
that we think will supplement your
learning. Use these to
develop background knowledge, enrich your coursework, and gain a
deeper understanding of the topics covered in
Excel Statistics and Finance Function Playbook.
Provides a comprehensive introduction to statistical learning, covering topics such as data mining, inference, and prediction. It useful resource for anyone who wants to learn more about statistical learning.
Provides an introduction to the statistical methods used in finance, covering topics such as descriptive statistics, probability, and regression analysis. It useful resource for anyone who wants to learn more about the statistical methods used in finance.
Provides a comprehensive introduction to finance theory and practice, covering topics such as financial markets, corporate finance, and investments. It useful resource for anyone who wants to learn more about finance theory and practice.
Provides a comprehensive introduction to finance, covering topics such as financial markets, corporate finance, and investments. It useful resource for anyone who wants to learn more about finance.
Provides a comprehensive introduction to statistics for business and economics, covering topics such as descriptive statistics, probability, and regression analysis. It useful resource for anyone who wants to learn more about statistics for business and economics.
Provides a hands-on introduction to data analysis using Python, covering topics such as data cleaning, data visualization, and statistical analysis. It useful resource for anyone who wants to learn more about data analysis using Python.
Provides a comprehensive guide to using Microsoft Excel for financial and accounting tasks, covering topics such as data analysis, budgeting, and forecasting. It useful resource for anyone who wants to learn more about using Excel for financial and accounting tasks.
Save
Provides a gentle introduction to statistics, covering topics such as descriptive statistics, probability, and regression analysis. It useful resource for anyone who wants to learn more about statistics.
Provides a clear and concise introduction to machine learning, covering topics such as supervised learning, unsupervised learning, and deep learning. It useful resource for anyone who wants to learn more about machine learning.
Save
Provides a comprehensive guide to Microsoft Excel, covering all the basics of the software, from data entry and formatting to formulas and functions. It useful resource for anyone who wants to learn more about Excel.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/yuynsh/excel
Share
Similar courses
Similar courses are unavailable at this time. Please try again later.
Time
1 hours
Via
Pluralsight
Instructor
Craig Golightly
This course belongs to a
collection
called
Microsoft Excel Programming. It's comprised of six courses:
- Recording and Managing Excel 2016 Macros
- Excel Logic Function Playbook
- Excel Statistics and Finance Function Playbook (viewing)
- Excel Data Lookup Function Playbook
- Excel 2016 Time and Date Function Playbook
- Developing for Excel with VBA
Good to know
Useful in a finance workspace from large corporation to small business
Teaches finance and statistic functions such as NPV, FV, PV, and more
Taught by the excel expert Craig Golightly
Covers common functions that are essential for financial analysis in many industries
Course assumes some prior knowledge of Excel
Our mission
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
Affiliate disclosure
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
© 2016 - 2024 OpenCourser