We may earn an affiliate commission when you visit our partners.
Bill Kulterman
In this course, Excel 2019 Essentials, you’ll learn the basics of working with Excel 2019. You’ll learn how to work with the Excel interface and begin the process of putting data into Excel and manipulating that data to gain results.
Read more
In this course, Excel 2019 Essentials, you’ll learn the basics of working with Excel 2019. You’ll learn how to work with the Excel interface and begin the process of putting data into Excel and manipulating that data to gain results.
Read more
In this course, Excel 2019 Essentials, you’ll learn the basics of working with Excel 2019. You’ll learn how to work with the Excel interface and begin the process of putting data into Excel and manipulating that data to gain results.
Knowing the basics of Excel 2019 can help make you a more well rounded professional. In this course, Excel 2019 Essentials, you will learn foundational knowledge of the Excel interface and settings. First, you will learn how to work with the Ribbon interface and Backstage View. Next, you will discover how to work with worksheets, cells, columns, and rows. Finally, you will explore how to use formatting and Auto options, as well as how to save your file. When you’re finished with this course, you will have the skills and knowledge of Excel 2019 needed to begin creating your own spreadsheets (and begin preparation for the Microsoft Office exams.)
Register for this course and see more details by visiting:
OpenCourser.com/course/j8rj2e/excel
What's inside
Syllabus
Getting to Know Excel 2019
Backstage View
Working with Worksheets and Data
Working with Rows and Columns
Read more
Syllabus
Getting to Know Excel 2019
Backstage View
Working with Worksheets and Data
Working with Rows and Columns
Read more
Formatting
Totaling Values
Saving a File
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
Explores core skills in data manipulation, which is standard in data-driven industries
Develops foundational knowledge in spreadsheet modeling and analysis
In step with the Microsoft Office certification exams in this domain
Builds data manipulation skills for beginners
Save this course
Save Excel 2019 Essentials 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 Excel 2019 Essentials with these
activities:
Review Basic Math Concepts
Show steps
Refreshing your knowledge of basic math concepts can strengthen your foundation for understanding spreadsheet formulas and calculations.
Show steps
-
Review basic arithmetic operations (addition, subtraction, multiplication, division).
-
Practice converting between different units (e.g., inches to centimeters, dollars to euros).
-
Solve simple algebraic equations.
Review the basics of spreadsheet software
Show steps
Reviewing the basics of spreadsheet software will help you refresh your memory on the essential functions and features of Excel, making it easier to follow along with the course content.
Show steps
-
Go through a beginner's tutorial on spreadsheet software
-
Practice creating and editing simple spreadsheets
Review Microsoft Excel 2019 in Depth
Show steps
Reviewing this book's chapters will provide you with supplemental practice and reinforcement on the core concepts and skills covered in the course, especially those covered in the second half of the course.
View
Microsoft Excel 2019 VBA and Macros
on Amazon
Show steps
-
Identify the chapters that correspond with the course's sections or modules.
-
Read the chapters while following along with the corresponding course materials.
-
Complete the exercises and practice problems at the ends of the chapters.
Eight other activities
Expand to see all activities and additional details
Show all 11 activities
Explore the Excel interface and its features
Show steps
Familiarizing yourself with the Excel interface and its features will help you navigate the software more efficiently and understand the location of the tools you need.
Show steps
-
Follow a guided tutorial on the Excel interface
-
Practice using the different menus and toolbars
Complete the Practice Drills for Excel 2019
Show steps
Completing these drills will provide you with additional practice and repetition on the topics covered so far in the course.
Show steps
-
Locate the practice drills or exercises that correspond with each lesson.
-
Complete the drills and exercises as directed.
-
Review your results to identify any areas where you need additional practice.
Practice entering and formatting data in Excel
Show steps
Practicing data entry and formatting will help you develop proficiency in handling data in Excel, ensuring the accuracy and organization of your spreadsheets.
Show steps
-
Complete exercises on data entry and formatting
-
Practice creating tables and charts from data
Join a study group or online forum for Excel users
Show steps
Connecting with other Excel users can provide you with support, encourage knowledge sharing, and expose you to different perspectives on using the software.
Show steps
-
Find a study group or online forum dedicated to Excel
-
Participate in discussions and ask questions
Create a Spreadsheet to Track Your Finances
Show steps
Creating a practical spreadsheet will help solidify your understanding of spreadsheet design, data entry, formula creation, and data analysis.
Show steps
-
Determine the categories of financial data you want to track.
-
Create a new spreadsheet and design the layout.
-
Enter your financial data and create formulas to calculate totals and other relevant information.
-
Format the spreadsheet for readability and presentation.
Create a spreadsheet to track your personal budget
Show steps
Creating a personal budget spreadsheet will provide you with hands-on experience in applying the skills you learn in the course to a practical task.
Show steps
-
Gather information on your income and expenses
-
Design a spreadsheet to track your budget
-
Enter your data and use formulas to calculate totals
Explore Advanced Excel Features Through Guided Tutorials
Show steps
Following these tutorials will expose you to additional features and techniques in Excel, which can extend your capabilities for data analysis and manipulation.
Show steps
-
Identify advanced Excel features that align with your interests or career goals.
-
Search for online tutorials or video courses that cover these features.
-
Follow the tutorials step-by-step and practice the techniques.
Compile a collection of Excel tips and tricks
Show steps
Creating a compilation of Excel tips and tricks will help you organize and retain the knowledge you gain throughout the course, providing you with a valuable resource for future reference.
Show steps
-
Gather tips and tricks from online resources and books
-
Organize the tips and tricks into categories
Review Basic Math Concepts
Show steps
Refreshing your knowledge of basic math concepts can strengthen your foundation for understanding spreadsheet formulas and calculations.
Show steps
Show steps
Show steps
- Review basic arithmetic operations (addition, subtraction, multiplication, division).
- Practice converting between different units (e.g., inches to centimeters, dollars to euros).
- Solve simple algebraic equations.
Review the basics of spreadsheet software
Show steps
Reviewing the basics of spreadsheet software will help you refresh your memory on the essential functions and features of Excel, making it easier to follow along with the course content.
Show steps
Show steps
Show steps
- Go through a beginner's tutorial on spreadsheet software
- Practice creating and editing simple spreadsheets
Review Microsoft Excel 2019 in Depth
Show steps
Reviewing this book's chapters will provide you with supplemental practice and reinforcement on the core concepts and skills covered in the course, especially those covered in the second half of the course.
View
Microsoft Excel 2019 VBA and Macros
on Amazon
Show steps
Show steps
Show steps
- Identify the chapters that correspond with the course's sections or modules.
- Read the chapters while following along with the corresponding course materials.
- Complete the exercises and practice problems at the ends of the chapters.
Eight other activities
Expand to see all activities and additional details
Show all 11 activities
Explore the Excel interface and its features
Show steps
Familiarizing yourself with the Excel interface and its features will help you navigate the software more efficiently and understand the location of the tools you need.
Show steps
Show steps
Show steps
- Follow a guided tutorial on the Excel interface
- Practice using the different menus and toolbars
Complete the Practice Drills for Excel 2019
Show steps
Completing these drills will provide you with additional practice and repetition on the topics covered so far in the course.
Show steps
Show steps
Show steps
- Locate the practice drills or exercises that correspond with each lesson.
- Complete the drills and exercises as directed.
- Review your results to identify any areas where you need additional practice.
Practice entering and formatting data in Excel
Show steps
Practicing data entry and formatting will help you develop proficiency in handling data in Excel, ensuring the accuracy and organization of your spreadsheets.
Show steps
Show steps
Show steps
- Complete exercises on data entry and formatting
- Practice creating tables and charts from data
Join a study group or online forum for Excel users
Show steps
Connecting with other Excel users can provide you with support, encourage knowledge sharing, and expose you to different perspectives on using the software.
Show steps
Show steps
Show steps
- Find a study group or online forum dedicated to Excel
- Participate in discussions and ask questions
Create a Spreadsheet to Track Your Finances
Show steps
Creating a practical spreadsheet will help solidify your understanding of spreadsheet design, data entry, formula creation, and data analysis.
Show steps
Show steps
Show steps
- Determine the categories of financial data you want to track.
- Create a new spreadsheet and design the layout.
- Enter your financial data and create formulas to calculate totals and other relevant information.
- Format the spreadsheet for readability and presentation.
Create a spreadsheet to track your personal budget
Show steps
Creating a personal budget spreadsheet will provide you with hands-on experience in applying the skills you learn in the course to a practical task.
Show steps
Show steps
Show steps
- Gather information on your income and expenses
- Design a spreadsheet to track your budget
- Enter your data and use formulas to calculate totals
Explore Advanced Excel Features Through Guided Tutorials
Show steps
Following these tutorials will expose you to additional features and techniques in Excel, which can extend your capabilities for data analysis and manipulation.
Show steps
Show steps
Show steps
- Identify advanced Excel features that align with your interests or career goals.
- Search for online tutorials or video courses that cover these features.
- Follow the tutorials step-by-step and practice the techniques.
Compile a collection of Excel tips and tricks
Show steps
Creating a compilation of Excel tips and tricks will help you organize and retain the knowledge you gain throughout the course, providing you with a valuable resource for future reference.
Show steps
Show steps
Show steps
- Gather tips and tricks from online resources and books
- Organize the tips and tricks into categories
Career center
Learners who complete Excel 2019 Essentials will develop knowledge and skills
that may be useful to these careers:
Data Analyst
Data Analyst
A Data Analyst is responsible for collecting, cleaning, and analyzing data to identify trends and patterns. They use this information to make recommendations to businesses on how to improve their operations. Excel 2019 Essentials can help you develop the skills you need to be successful in this role by teaching you how to use Excel to import and export data, create and use formulas, and perform statistical analysis. This course can also help you develop the critical thinking and problem-solving skills that are essential for success in this field.
Financial Analyst
Financial Analyst
A Financial Analyst is responsible for analyzing financial data to make recommendations on investments. They use this information to help businesses make informed decisions about their financial future. Excel 2019 Essentials can help you develop the skills you need to be successful in this role by teaching you how to use Excel to create financial models, perform financial analysis, and create charts and graphs. This course can also help you develop the communication and problem-solving skills that are essential for success in this field.
Business Analyst
Business Analyst
A Business Analyst is responsible for understanding the needs of a business and translating those needs into technical requirements. They work with stakeholders to gather requirements, analyze data, and develop solutions. Excel 2019 Essentials can help you develop the skills you need to be successful in this role by teaching you how to use Excel to organize and analyze data, create charts and graphs, and perform calculations. This course can also help you develop the communication and problem-solving skills that are essential for success in this field.
Management Consultant
Management Consultant
A Management Consultant is responsible for helping businesses improve their operations. They work with clients to identify problems, develop solutions, and implement those solutions. Excel 2019 Essentials can help you develop the skills you need to be successful in this role by teaching you how to use Excel to analyze data, create presentations, and develop financial models. This course can also help you develop the communication and problem-solving skills that are essential for success in this field.
Market Researcher
Market Researcher
A Market Researcher is responsible for collecting and analyzing data on consumer behavior. They use this information to help businesses develop products and services that meet the needs of their customers. Excel 2019 Essentials can help you develop the skills you need to be successful in this role by teaching you how to use Excel to design surveys, collect data, and analyze results. This course can also help you develop the communication and problem-solving skills that are essential for success in this field.
Quality Assurance Analyst
Quality Assurance Analyst
A Quality Assurance Analyst is responsible for testing software to ensure that it meets the required quality standards. They work with developers to identify and fix bugs. Excel 2019 Essentials can help you develop the skills you need to be successful in this role by teaching you how to use Excel to create test plans, track defects, and analyze data. This course can also help you develop the communication and problem-solving skills that are essential for success in this field.
Project Manager
Project Manager
A Project Manager is responsible for planning, executing, and closing out projects. They work with teams to ensure that projects are completed on time, on budget, and to the required quality standards. Excel 2019 Essentials can help you develop the skills you need to be successful in this role by teaching you how to use Excel to create project plans, track progress, and manage budgets. This course can also help you develop the communication and problem-solving skills that are essential for success in this field.
Sales Manager
Sales Manager
A Sales Manager is responsible for leading and motivating a sales team. They work with sales representatives to develop sales strategies, track progress, and close deals. Excel 2019 Essentials can help you develop the skills you need to be successful in this role by teaching you how to use Excel to create sales forecasts, track sales performance, and manage budgets. This course can also help you develop the communication and problem-solving skills that are essential for success in this field.
Product Manager
Product Manager
A Product Manager is responsible for developing and managing a product from concept to launch. They work with engineers, designers, and marketers to bring a product to market and ensure that it meets the needs of customers. Excel 2019 Essentials can help you develop the skills you need to be successful in this role by teaching you how to use Excel to create product roadmaps, track progress, and analyze data. This course can also help you develop the communication and problem-solving skills that are essential for success in this field.
Operations Manager
Operations Manager
An Operations Manager is responsible for overseeing the day-to-day operations of a business. They work with employees to ensure that the business is running smoothly and efficiently. Excel 2019 Essentials can help you develop the skills you need to be successful in this role by teaching you how to use Excel to track inventory, create schedules, and manage budgets. This course can also help you develop the communication and problem-solving skills that are essential for success in this field.
Supply Chain Manager
Supply Chain Manager
A Supply Chain Manager is responsible for managing the flow of goods and services from suppliers to customers. They work with suppliers, manufacturers, and distributors to ensure that products are delivered to customers on time, on budget, and to the required quality standards. Excel 2019 Essentials can help you develop the skills you need to be successful in this role by teaching you how to use Excel to create supply chain models, track inventory, and manage budgets. This course can also help you develop the communication and problem-solving skills that are essential for success in this field.
Teacher
Teacher
A Teacher is responsible for educating students in a variety of subjects. They work with students to develop their knowledge and skills, and to prepare them for further education or employment. Excel 2019 Essentials can help you develop the skills you need to be successful in this role by teaching you how to use Excel to create lesson plans, track student progress, and manage your classroom. This course can also help you develop the communication and problem-solving skills that are essential for success in this field.
Writer
Writer
A Writer is responsible for writing and editing content for a variety of purposes, including articles, blog posts, website content, and marketing materials. Excel 2019 Essentials can help you develop the skills you need to be successful in this role by teaching you how to use Excel to organize your writing projects, track your progress, and manage your time. This course can also help you develop the communication and problem-solving skills that are essential for success in this field.
Web Developer
Web Developer
A Web Developer is responsible for designing and developing websites. They work with clients to gather requirements, create mockups, and develop and test websites. Excel 2019 Essentials can help you develop the skills you need to be successful in this role by teaching you how to use Excel to create prototypes, track progress, and manage budgets. This course can also help you develop the communication and problem-solving skills that are essential for success in this field.
Technical Writer
Technical Writer
A Technical Writer is responsible for writing and editing technical documentation. They work with engineers and other technical experts to create user guides, manuals, and other documents that explain how to use products and services. Excel 2019 Essentials can help you develop the skills you need to be successful in this role by teaching you how to use Excel to create tables, charts, and graphs. This course can also help you develop the communication and problem-solving skills that are essential for success in this field.
For more career information including salaries, visit:
OpenCourser.com/course/j8rj2e/excel
Reading list
We've selected eight 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 2019 Essentials.
Practical, step-by-step guide to using Microsoft Excel 2019. It covers all the basics, from creating and formatting spreadsheets to using formulas and functions. In addition, it provides more advanced tips and techniques for working with data in Excel.
Comprehensive reference guide to Microsoft Excel 2019. It covers everything from basic concepts to advanced techniques. It is an excellent resource for both beginners and experienced users.
Beginner-friendly guide to Microsoft Excel 2019. It covers all the basics, from creating and formatting spreadsheets to using formulas and functions. It great option for those who are new to Excel or who need a refresher.
Guide to using Visual Basic for Applications (VBA) to automate tasks in Microsoft Excel 2019. It covers all the basics, from recording macros to writing custom functions. It valuable resource for those who want to take their Excel skills to the next level.
Guide to using Microsoft Excel 2019 for data analysis and business modeling. It covers all the basics, from importing data to creating charts and graphs. It valuable resource for those who want to use Excel to make better decisions.
Guide to using PivotTables and PivotCharts in Microsoft Excel 2019. It covers all the basics, from creating a PivotTable to formatting the PivotTable. It valuable resource for those who want to use Excel to analyze data more effectively.
Guide to using macros and VBA in Microsoft Excel 2019. It covers all the basics, from recording a macro to writing a custom function. It valuable resource for those who want to take their Excel skills to the next level.
Guide to using formulas and functions in Microsoft Excel 2019. It covers all the basics, from entering a formula to using the most common functions. It valuable resource for those who want to use Excel to perform calculations more efficiently.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/j8rj2e/excel
Share
Similar courses
Here are nine courses similar to
Excel 2019 Essentials.
Word 2019 Essentials
OpenCourser.com/course/9pxkxf/word
Word 2019 Essentials
Most relevant
Excel 2021 Essentials
OpenCourser.com/course/18hvfz/excel
Excel 2021 Essentials
Most relevant
Excel 365 Essentials
OpenCourser.com/course/knj0zp/excel
Excel 365 Essentials
Most relevant
PowerPoint 2019 Essentials
OpenCourser.com/course/ngo8zv/powerpoint
PowerPoint 2019 Essentials
Most relevant
Outlook 2019 Essentials
OpenCourser.com/course/c04inl/outlook
Outlook 2019 Essentials
Most relevant
Access 2019 Essentials
OpenCourser.com/course/ioh2me/access
Access 2019 Essentials
Most relevant
Excel 2019 Power Users
OpenCourser.com/course/ncsrxi/excel
Excel 2019 Power Users
Most relevant
PowerPoint 2021 Essentials
OpenCourser.com/course/d6gpjg/powerpoint
PowerPoint 2021 Essentials
Most relevant
PowerPoint 365 Essentials
OpenCourser.com/course/4srrwm/powerpoint
PowerPoint 365 Essentials
Most relevant
Time
125 hours
Level
Introductory
Via
Pluralsight
Instructor
Bill Kulterman
Language
English
Good to know
Explores core skills in data manipulation, which is standard in data-driven industries
Develops foundational knowledge in spreadsheet modeling and analysis
In step with the Microsoft Office certification exams in this domain
Builds data manipulation skills for beginners
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