❗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 [April 29th, 2023]
This course provides an overview of Microsoft Excel and its 333 keyboard shortcuts. Students will learn how to use Microsoft Excel with confidence, which can lead to higher salaries and promotions. The course covers topics such as drag & drop, function keys, making selections, ribbon tab, formulas, macros & VBA, pivot tables, Power BI, Power Pivot, and more. Students will also receive a downloadable Excel workbook to keep on their desktop and practice. Additionally, students will have access to personal Excel support from a professional Excel trainer with 15+ years of Excel training. Finally, students can test their skills with various quizzes.
[Applications]
Those who have completed this course will be able to apply their knowledge of Microsoft Excel to their daily work tasks. They will be able to use the 333 Excel keyboard shortcuts to save time and increase their productivity. They will be able to use the downloadable Excel workbook to practice their skills and become more confident in their use of Microsoft Excel. They will also be able to use the quizzes to test their knowledge and skills. With their increased knowledge and skills, they will be able to apply for higher salary positions and promotions.
[Career Paths]
1. Data Analyst: Data Analysts are responsible for collecting, organizing, and analyzing data to help inform business decisions. They use a variety of tools, such as Microsoft Excel, to analyze data and create reports. As businesses become increasingly data-driven, the demand for Data Analysts is growing.
2. Business Intelligence Analyst: Business Intelligence Analysts use data to help organizations make better decisions. They use Microsoft Excel to analyze data, create reports, and develop dashboards. They also use other tools, such as Power BI, to create visualizations and insights.
3. Financial Analyst: Financial Analysts use Microsoft Excel to analyze financial data and create financial models. They use Excel to create budgets, forecasts, and financial statements. They also use Excel to analyze investments and make recommendations.
4. Data Scientist: Data Scientists use Microsoft Excel to analyze large datasets and uncover insights. They use Excel to create predictive models and develop algorithms. They also use Excel to create visualizations and dashboards. As businesses become increasingly data-driven, the demand for Data Scientists is growing.
[Education Paths]
1. Bachelor of Science in Computer Science: This degree path focuses on the fundamentals of computer science, including programming, software engineering, and computer systems. It also covers topics such as artificial intelligence, machine learning, and data science. This degree is becoming increasingly popular as technology advances and more businesses rely on computer systems and software.
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, network security, and web development. This degree is becoming increasingly popular as businesses rely more heavily on technology to manage their operations.
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, artificial intelligence, and data visualization. This degree is becoming increasingly popular as businesses rely more heavily on data-driven decision making.
4. Master of Science in Business Analytics: This degree path focuses on the application of data science to business problems. It covers topics such as predictive analytics, optimization, and decision making. This degree is becoming increasingly popular as businesses rely more heavily on data-driven decision making.
Course Syllabus
Cell Formatting
Drag & Drop
Formulas & Functions
Frequent
Function Key
Making selections
Ribbon Tab
Cell Navigation
Inside Ribbon
Macros & VBA
Pivot Tables
Power BI
Power Pivot
Other Keyboard Shortcuts