We may earn an affiliate commission when you visit our partners.
Spike Xavier
In this course, we will go through some real world based examples to show how these formulas can be used. The course goes in-depth in each of the supported areas.
Read more
In this course, we will go through some real world based examples to show how these formulas can be used. The course goes in-depth in each of the supported areas.
Read more
In this course, we will go through some real world based examples to show how these formulas can be used. The course goes in-depth in each of the supported areas.
Calculated columns are a powerful part of the out of the box feature set of SharePoint foundation 2007, 2010, and 2013. Any SharePoint deployment can benefit from the use of this powerful tool. In this course, we will go through some real world based examples to show how these formulas can be used. The course goes in-depth in each of the supported areas. SharePoint calculated column formulas are based on the Excel functions and syntax, however only a subset of these is supported. This course is about mastering the supported formulas in a short period of time.
Register for this course and see more details by visiting:
OpenCourser.com/course/smk5hx/microsoft
What's inside
Syllabus
What Are Calculated Columns?
Which Formulas Are Supported?
Example of Using Calculated Columns
Conditional Formulas
Read more
Syllabus
What Are Calculated Columns?
Which Formulas Are Supported?
Example of Using Calculated Columns
Conditional Formulas
Read more
Date and Time Formulas
Mathematical Formulas
Text Formulas
Advanced Calculated Columns
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
Covers the subset of supported formulas quicky
Suitable for users with any level of experience with SharePoint calculated columns
Save this course
Save Microsoft Azure Cost Optimization Deep Dive to your list so you can find it easily later:
Save
Save
Activities
Be better prepared
before
your course. Deepen your understanding
during
and
after
it. Supplement your coursework and achieve mastery of the topics covered
in Microsoft Azure Cost Optimization Deep Dive with these
activities:
Read: Power BI for Beginners
Show steps
Grasp the fundamental principles of Power BI to strengthen your analytical skills.
View
Microsoft Power BI Cookbook - Second Edition:...
on Amazon
Show steps
-
Purchase the book and allocate 60 minutes to read chapters 1-3.
-
Summarize the key takeaways from each chapter and create a mind map.
-
Complete the exercises at the end of each chapter to reinforce your understanding.
Practice DAX Calculations
Show steps
Enhance your understanding of DAX by solving practice problems and solidifying your ability to write efficient calculations.
Browse courses on
DAX
Show steps
-
Access online resources or purchase a practice workbook with DAX exercises.
-
Attempt to solve the problems on your own, referring to documentation or tutorials when needed.
-
Review your solutions and identify areas where you can improve your approach.
Follow Guided Tutorials on Power Query
Show steps
Enhance your data manipulation skills by following guided tutorials on Power Query, enabling you to efficiently transform and clean data for analysis.
Browse courses on
Power Query
Show steps
-
Search for reputable online tutorials or courses on Power Query.
-
Select a tutorial that aligns with your learning goals and skill level.
-
Follow the instructions in the tutorial, pausing to experiment and practice.
Five other activities
Expand to see all activities and additional details
Show all eight activities
Compile a Glossary of Power BI Terminology
Show steps
Deepen your understanding of Power BI by creating a comprehensive glossary of key terms and concepts.
Browse courses on
Terminology
Show steps
-
Start with a list of commonly used Power BI terms from course materials or online resources.
-
Define each term accurately, providing examples and illustrations where possible.
-
Organize the terms alphabetically or by category for easy reference.
Join a Study Group for Collaborative Learning
Show steps
Enhance your learning experience by joining a study group, where you can share knowledge, ask questions, and engage in discussions with peers.
Browse courses on
Collaboration
Show steps
-
Reach out to classmates or fellow students to form a study group.
-
Establish regular meeting times and allocate roles for each member.
-
Review course materials together, discuss concepts, and share resources.
Create a Dashboard Using Power BI
Show steps
Apply your knowledge of Power BI by creating an interactive dashboard that showcases your proficiency in data visualization and analysis.
Browse courses on
Dashboarding
Show steps
-
Identify a dataset that aligns with your interests or professional goals.
-
Import the dataset into Power BI and explore its contents.
-
Design and create visualizations to represent key insights and trends from the data.
-
Organize your visualizations into a cohesive and informative dashboard.
Attend a Power BI User Group Meeting
Show steps
Connect with other Power BI users, share knowledge, and learn about industry best practices to expand your professional network and enhance your learning.
Browse courses on
Networking
Show steps
-
Locate a local Power BI user group or attend virtual meetings.
-
Attend a meeting and introduce yourself to other attendees.
-
Participate in discussions and ask questions to gain insights and perspectives.
Participate in a Power BI Challenge
Show steps
Test your skills and push your boundaries by participating in a Power BI challenge, allowing you to showcase your abilities and learn from others.
Browse courses on
Challenges
Show steps
-
Identify a relevant Power BI challenge or competition.
-
Form a team or work independently to analyze the problem statement and develop a solution.
-
Create a compelling presentation or report to showcase your findings.
-
Submit your entry and await the results.
Read: Power BI for Beginners
Show steps
Grasp the fundamental principles of Power BI to strengthen your analytical skills.
View
Microsoft Power BI Cookbook - Second Edition:...
on Amazon
Show steps
Show steps
Show steps
- Purchase the book and allocate 60 minutes to read chapters 1-3.
- Summarize the key takeaways from each chapter and create a mind map.
- Complete the exercises at the end of each chapter to reinforce your understanding.
Practice DAX Calculations
Show steps
Enhance your understanding of DAX by solving practice problems and solidifying your ability to write efficient calculations.
Browse courses on
DAX
Show steps
Show steps
Show steps
- Access online resources or purchase a practice workbook with DAX exercises.
- Attempt to solve the problems on your own, referring to documentation or tutorials when needed.
- Review your solutions and identify areas where you can improve your approach.
Follow Guided Tutorials on Power Query
Show steps
Enhance your data manipulation skills by following guided tutorials on Power Query, enabling you to efficiently transform and clean data for analysis.
Browse courses on
Power Query
Show steps
Show steps
Show steps
- Search for reputable online tutorials or courses on Power Query.
- Select a tutorial that aligns with your learning goals and skill level.
- Follow the instructions in the tutorial, pausing to experiment and practice.
Five other activities
Expand to see all activities and additional details
Show all eight activities
Compile a Glossary of Power BI Terminology
Show steps
Deepen your understanding of Power BI by creating a comprehensive glossary of key terms and concepts.
Browse courses on
Terminology
Show steps
Show steps
Show steps
- Start with a list of commonly used Power BI terms from course materials or online resources.
- Define each term accurately, providing examples and illustrations where possible.
- Organize the terms alphabetically or by category for easy reference.
Join a Study Group for Collaborative Learning
Show steps
Enhance your learning experience by joining a study group, where you can share knowledge, ask questions, and engage in discussions with peers.
Browse courses on
Collaboration
Show steps
Show steps
Show steps
- Reach out to classmates or fellow students to form a study group.
- Establish regular meeting times and allocate roles for each member.
- Review course materials together, discuss concepts, and share resources.
Create a Dashboard Using Power BI
Show steps
Apply your knowledge of Power BI by creating an interactive dashboard that showcases your proficiency in data visualization and analysis.
Browse courses on
Dashboarding
Show steps
Show steps
Show steps
- Identify a dataset that aligns with your interests or professional goals.
- Import the dataset into Power BI and explore its contents.
- Design and create visualizations to represent key insights and trends from the data.
- Organize your visualizations into a cohesive and informative dashboard.
Attend a Power BI User Group Meeting
Show steps
Connect with other Power BI users, share knowledge, and learn about industry best practices to expand your professional network and enhance your learning.
Browse courses on
Networking
Show steps
Show steps
Show steps
- Locate a local Power BI user group or attend virtual meetings.
- Attend a meeting and introduce yourself to other attendees.
- Participate in discussions and ask questions to gain insights and perspectives.
Participate in a Power BI Challenge
Show steps
Test your skills and push your boundaries by participating in a Power BI challenge, allowing you to showcase your abilities and learn from others.
Browse courses on
Challenges
Show steps
Show steps
Show steps
- Identify a relevant Power BI challenge or competition.
- Form a team or work independently to analyze the problem statement and develop a solution.
- Create a compelling presentation or report to showcase your findings.
- Submit your entry and await the results.
Career center
Learners who complete Microsoft Azure Cost Optimization Deep Dive will develop knowledge and skills
that may be useful to these careers:
Data Analyst
Data Analyst
A Data Analyst plays a vital role in the success of a business by using data to make informed decisions. Calculated columns are a powerful feature in SharePoint that allows you to create custom formulas to extract meaningful insights from your data. This course will teach you how to use calculated columns effectively, giving you the skills you need to succeed as a Data Analyst.
Business Analyst
Business Analyst
A Business Analyst is responsible for analyzing business processes and identifying areas for improvement. Calculated columns can be used to create custom reports and dashboards that can help you visualize and analyze data, making it easier to identify trends and patterns. This course will give you the skills you need to use calculated columns effectively, which will help you succeed as a Business Analyst.
Project Manager
Project Manager
A Project Manager is responsible for planning, executing, and closing projects. Calculated columns can be used to create custom project plans and timelines, which can help you track progress and identify potential risks. This course will give you the skills you need to use calculated columns effectively, which will help you succeed as a Project Manager.
Software Engineer
Software Engineer
A Software Engineer is responsible for designing, developing, and testing software applications. Calculated columns can be used to create custom code that can be used to automate tasks and improve the efficiency of your software applications. This course will give you the skills you need to use calculated columns effectively, which will help you succeed as a Software Engineer.
Data Scientist
Data Scientist
A Data Scientist is responsible for using data to solve business problems. Calculated columns can be used to create custom data models and algorithms that can be used to predict outcomes and make recommendations. This course will give you the skills you need to use calculated columns effectively, which will help you succeed as a Data Scientist.
Database Administrator
Database Administrator
A Database Administrator is responsible for managing and maintaining databases. Calculated columns can be used to create custom queries and reports that can help you optimize the performance of your databases. This course will give you the skills you need to use calculated columns effectively, which will help you succeed as a Database Administrator.
Information Technology Manager
Information Technology Manager
An Information Technology Manager is responsible for planning, implementing, and managing information technology systems. Calculated columns can be used to create custom reports and dashboards that can help you track the performance of your IT systems and identify areas for improvement. This course will give you the skills you need to use calculated columns effectively, which will help you succeed as an Information Technology Manager.
Systems Analyst
Systems Analyst
A Systems Analyst is responsible for analyzing business systems and identifying areas for improvement. Calculated columns can be used to create custom reports and dashboards that can help you visualize and analyze data, making it easier to identify trends and patterns. This course will give you the skills you need to use calculated columns effectively, which will help you succeed as a Systems Analyst.
Business Intelligence Analyst
Business Intelligence Analyst
A Business Intelligence Analyst is responsible for using data to make informed decisions. Calculated columns can be used to create custom reports and dashboards that can help you visualize and analyze data, making it easier to identify trends and patterns. This course will give you the skills you need to use calculated columns effectively, which will help you succeed as a Business Intelligence Analyst.
Financial Analyst
Financial Analyst
A Financial Analyst is responsible for analyzing financial data and making recommendations. Calculated columns can be used to create custom reports and dashboards that can help you visualize and analyze financial data, making it easier to identify trends and patterns. This course will give you the skills you need to use calculated columns effectively, which will help you succeed as a Financial Analyst.
Marketing Analyst
Marketing Analyst
A Marketing Analyst is responsible for analyzing marketing data and making recommendations. Calculated columns can be used to create custom reports and dashboards that can help you visualize and analyze marketing data, making it easier to identify trends and patterns. This course will give you the skills you need to use calculated columns effectively, which will help you succeed as a Marketing Analyst.
Sales Analyst
Sales Analyst
A Sales Analyst is responsible for analyzing sales data and making recommendations. Calculated columns can be used to create custom reports and dashboards that can help you visualize and analyze sales data, making it easier to identify trends and patterns. This course will give you the skills you need to use calculated columns effectively, which will help you succeed as a Sales Analyst.
Operations Analyst
Operations Analyst
An Operations Analyst is responsible for analyzing operational data and making recommendations. Calculated columns can be used to create custom reports and dashboards that can help you visualize and analyze operational data, making it easier to identify trends and patterns. This course will give you the skills you need to use calculated columns effectively, which will help you succeed as an Operations Analyst.
Human Resources Analyst
Human Resources Analyst
A Human Resources Analyst is responsible for analyzing human resources data and making recommendations. Calculated columns can be used to create custom reports and dashboards that can help you visualize and analyze human resources data, making it easier to identify trends and patterns. This course will give you the skills you need to use calculated columns effectively, which will help you succeed as a Human Resources Analyst.
Customer Service Analyst
Customer Service Analyst
A Customer Service Analyst is responsible for analyzing customer service data and making recommendations. Calculated columns can be used to create custom reports and dashboards that can help you visualize and analyze customer service data, making it easier to identify trends and patterns. This course may be useful for you if you are interested in a career as a Customer Service Analyst.
For more career information including salaries, visit:
OpenCourser.com/course/smk5hx/microsoft
Reading list
We've selected six 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
Microsoft Azure Cost Optimization Deep Dive.
Provides a comprehensive guide to SharePoint calculated columns, covering everything from the basics to advanced techniques. It valuable resource for anyone looking to learn more about this powerful feature.
Provides a developer's guide to SharePoint calculated columns, covering everything from the basics to advanced techniques. It valuable resource for anyone looking to learn more about how to develop custom calculated columns.
Covers a wide range of SharePoint topics, including calculated columns. It provides an overview of the concepts and techniques involved in using calculated columns, making it a useful resource for getting started.
Save
Provides a comprehensive overview of Excel functions and formulas. It valuable resource for anyone who wants to learn more about using Excel formulas.
This step-by-step guide to SharePoint includes a section on calculated columns. It provides clear instructions and screenshots, making it suitable for those who prefer a more hands-on approach to learning.
Save
Provides a user's guide to SharePoint 2010. It covers basic tasks such as creating and managing documents, lists, and libraries.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/smk5hx/microsoft
Share
Similar courses
Here are nine courses similar to
Microsoft Azure Cost Optimization Deep Dive.
Big Picture: SharePoint 2016 On-prem, Online, or Hybrid?
OpenCourser.com/course/w2rpvf/big
Big Picture: SharePoint 2016 On-prem, Online, or Hybrid?
Scaling up SharePoint Framework Development for Enterprises
OpenCourser.com/course/3v19yp/scaling
Scaling up SharePoint Framework Development for...
Automate Approval Process with SharePoint & Power Automate
OpenCourser.com/course/9zggiz/automate
Automate Approval Process with SharePoint & Power Automate
Creating Deployment Packages for SharePoint Framework Projects
OpenCourser.com/course/n9izvk/creating
Creating Deployment Packages for SharePoint Framework...
Implementing Authentication in SharePoint 2019
OpenCourser.com/course/vwlfkl/implementing
Implementing Authentication in SharePoint 2019
Updating Legacy SharePoint Customizations
OpenCourser.com/course/mrh8aw/updating
Updating Legacy SharePoint Customizations
Broadening the Reach of Power BI
OpenCourser.com/course/7b6de7/broadening
Broadening the Reach of Power BI
Microsoft Excel: Advanced Excel Formulas & Functions
OpenCourser.com/course/bgtuz8/microsoft
Microsoft Excel: Advanced Excel Formulas & Functions
Build Solutions with Power Apps, Power Automate & SharePoint
OpenCourser.com/course/j0pdhl/build
Build Solutions with Power Apps, Power Automate &...
Time
256 hours
Level
Introductory
Via
Pluralsight
Instructor
Spike Xavier
Language
English
Good to know
Covers the subset of supported formulas quicky
Suitable for users with any level of experience with SharePoint calculated columns
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