Excel: From beginner to intermediate
Gain the knowledge and skills necessary to become an intermediate Excel user with this comprehensive course. Developed by Microsoft, this course will help you master the basics and move on to more advanced features. ▼
ADVERTISEMENT
Course Feature
Cost:
Free
Provider:
Udemy
Certificate:
Paid Certification
Language:
English
Course Overview
❗The content presented here is sourced directly from Udemy platform. For comprehensive course details, including enrollment information, simply click on the 'Go to class' link on our website.
Updated in [March 01st, 2023]
This course provides an overview of Excel from beginner to intermediate level. Participants will learn how to create, configure, and save worksheets and workbooks. They will also learn how to navigate and format worksheets and workbooks, customize options and views, and set up for printing. Additionally, participants will learn how to insert and format data into cells and ranges, create and modify tables, highlight, filter, sort, and group cells, ranges, and tables. They will also learn how to create and format Excel charts in a variety of ways, insert and format objects, and create formulas in Excel, including conditional logic and text modification.
[Applications]
After completing this course, participants should be able to apply their knowledge of Excel to create and manage worksheets and workbooks, format data, create and modify tables, create and format charts, insert and format objects, and create formulas. They should also be able to customize worksheet and workbook options and views, as well as set up Excel worksheets and workbooks for printing.
[Career Paths]
1. Data Analyst: Data Analysts are responsible for collecting, organizing, and analyzing data to help inform business decisions. They use Excel to create reports, charts, and graphs to visualize data and identify trends. As businesses become increasingly data-driven, the demand for Data Analysts is expected to grow.
2. Financial Analyst: Financial Analysts use Excel to analyze financial data and create financial models. They use Excel to forecast future financial performance, analyze investments, and assess risk. With the increasing complexity of financial markets, the demand for Financial Analysts is expected to remain strong.
3. Business Intelligence Analyst: Business Intelligence Analysts use Excel to analyze data and create reports to help businesses make better decisions. They use Excel to create dashboards, charts, and graphs to visualize data and identify trends. As businesses become increasingly data-driven, the demand for Business Intelligence Analysts is expected to grow.
4. Data Scientist: Data Scientists use Excel to analyze large datasets and create predictive models. They use Excel to identify patterns and trends in data, and to develop algorithms to make predictions. With the increasing complexity of data analysis, the demand for Data Scientists is expected to remain strong.
[Education Paths]
1. Bachelor of Science in Computer Science: This degree path focuses on the fundamentals of computer science, including programming, software engineering, and data structures. It also covers topics such as artificial intelligence, computer networks, and computer graphics. This degree path is becoming increasingly popular as technology advances and more businesses rely on computers and software to run their operations.
2. Bachelor of Science in Information Technology: This degree path focuses on the application of technology to solve business problems. It covers topics such as database management, web development, and network security. This degree path is becoming increasingly popular as businesses rely on technology to manage their operations and protect their data.
3. Master of Science in Data Science: This degree path focuses on the analysis of large datasets and the development of algorithms to extract insights from them. It covers topics such as machine learning, data mining, and predictive analytics. This degree path is becoming increasingly popular as businesses rely on data-driven decisions to make informed decisions.
4. Master of Science in Artificial Intelligence: This degree path focuses on the development of algorithms and systems that can learn from data and make decisions. It covers topics such as natural language processing, computer vision, and robotics. This degree path is becoming increasingly popular as businesses rely on artificial intelligence to automate processes and make decisions.
Course Syllabus
An introduction to Excel
Create worksheets and workbooks
Configure worksheets and workbooks to save
Basic formulas
Navigate through Excel worksheets and workbooks
Format worksheets and workbooks
Customise options and views for worksheets and workbooks
Configure Excel worksheets and workbooks to print
Utilise cell ranges and references in formulas and functions
Insert data in cells and ranges
Format cells and ranges
Highlight and filter cells and ranges in Excel
Summarise data with Excel functions
Create a table
Modify a table
Filtering, Sorting and Grouping
Utilise conditional logic in functions
Create a chart in Excel
Format a chart in Excel
Insert and format an object
create and modify images by using the Image Editor
Format and modify text with functions
Course Provider
Provider Udemy's Stats at AZClass
Discussion and Reviews
0.0 (Based on 0 reviews)
Start your review of Excel: From beginner to intermediate