We may earn an affiliate commission when you visit our partners.

Viewing and Manipulating Data in Excel 2016

Learn the most efficient ways of viewing and manipulating data in Excel 2016.

Learn the most efficient ways of viewing and manipulating data in Excel 2016. You'll learn about PivotTables, protection settings, charts, working with data and functions.

Enroll now

Or start your subscription today

And complete this course over a free trial

Here's a deal for you

We found an offer that may be relevant to this course.

Save money when you learn. All coupon codes, vouchers, and discounts are applied automatically unless otherwise noted.

Valid for a limited time only

Future-proof your career

Access O'Reilly books, live events, courses, and more. Save with an annual subscription.

Take

15%

off

What's inside

Syllabus

Views, Templates, Links, and Clipboard

PivotTables

Protection

Charts

Data

Functions

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Covers skills and ideas in manipulating data in Excel 2016, which are standard in business

Teaches how to view and manipulate data in Excel 2016, which helps learners do core business tasks

Diane McSorley teaches this course, who are recognized for their work in business and technology

Develops skills in manipulating data in Excel, which are core skills for business and data analytics

Examines the use of Excel 2016 for data manipulation, which is highly relevant in business environments

Save this course

Save Viewing and Manipulating Data in Excel 2016 to your list so you can find it easily later:

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 Viewing and Manipulating Data in Excel 2016 with these activities:

Review basic Excel functions

Show steps

Refresh your memory on fundamental Excel functions to enhance your ability to manipulate and analyze data effectively.

Browse courses on Excel Functions

Show steps

Revisit the course materials or online resources on Excel functions.
Practice using basic functions such as SUM, AVERAGE, and IF.

Gather online resources

Show steps

Build a repository of useful online resources, including tutorials, articles, and datasets, to support your learning journey.

Show steps

Search for reputable websites and platforms offering Excel tutorials.
Create a folder to store and organize the resources.

Identify an experienced Excel user as a mentor

Show steps

Seek guidance and support from an experienced professional to accelerate your learning and address specific challenges.

Show steps

Network with professionals in your field who use Excel extensively.
Request mentorship, explaining your goals and areas where you need support.
Set up regular communication and learning sessions with your mentor.

Five other activities

Expand to see all activities and additional details

Show all eight activities

Engage in peer discussion forums

Show steps

Connect with fellow students, share insights, and clarify concepts through active participation in discussion forums.

Show steps

Introduce yourself and share your learning goals.
Participate in discussions, ask questions, and provide support.
Review and reflect on discussions to reinforce understanding.

Read 'Excel Data Analysis and Modeling' by David A. Simon

Show steps

Learn fundamental principles of data analysis and modeling to enhance your understanding of Excel's capabilities.

View Research Methods for Political Science:... on Amazon

Show steps

Read Chapters 1-3 to understand basic data analysis concepts.
Practice building simple models using Chapter 4 examples.
Apply techniques to analyze real-world datasets.

Follow online tutorials on advanced Excel features

Show steps

Expand your skills by exploring advanced Excel features through guided tutorials.

Show steps

Identify specific areas where you want to enhance your knowledge.
Search for high-quality tutorials from credible sources.
Follow the steps and practice the techniques demonstrated.

Analyze and visualize data

Show steps

Reinforce data analysis and visualization skills through hands-on practice.

Show steps

Use PivotTables and charts to explore data patterns.
Practice creating scatter plots, line graphs, and histograms.
Interpret and communicate data insights effectively.

Create an interactive dashboard

Show steps

Develop hands-on experience by designing and building an interactive dashboard that demonstrates data analysis and presentation skills.

Show steps

Identify a real-world dataset relevant to your interests.
Use data visualization techniques to present key insights.
Develop interactive elements to allow users to explore the data.

Career center

Learners who complete Viewing and Manipulating Data in Excel 2016 will develop knowledge and skills that may be useful to these careers:

Data Analyst

Data Analysts play a crucial role in businesses today. They organize, interpret, and analyze data to extract meaningful insights that can help companies make better decisions. This course on Viewing and Manipulating Data in Excel 2016 provides a strong foundation for this career by teaching you how to effectively manage and analyze large datasets using Excel's powerful tools. You'll learn how to create PivotTables, protect sensitive data, visualize data with charts, and work with functions to automate tasks. By mastering these skills, you'll be well-equipped to succeed as a Data Analyst.

See salaries and explore the career path for Data Analyst

Business Analyst

Business Analysts work closely with stakeholders to understand their business needs and develop solutions that meet those needs. They use data analysis to identify inefficiencies, make recommendations, and improve processes. This course on Viewing and Manipulating Data in Excel 2016 can be a valuable asset for Business Analysts, as it provides a comprehensive understanding of data management and analysis techniques. By learning how to use Excel's tools to organize, clean, and analyze data, you'll be able to develop more effective solutions and make better recommendations.

See salaries and explore the career path for Business Analyst

Financial Analyst

Financial Analysts use data to make informed decisions about investments, financial planning, and risk management. This course on Viewing and Manipulating Data in Excel 2016 can provide a strong foundation for this career by teaching you how to manage and analyze financial data using Excel's tools. You'll learn how to create financial models, perform data analysis, and visualize data to make better investment decisions.

See salaries and explore the career path for Financial Analyst

Market Researcher

Market Researchers collect and analyze data to understand consumer behavior and market trends. This course on Viewing and Manipulating Data in Excel 2016 can be useful for Market Researchers, as it provides a comprehensive understanding of data management and analysis techniques. By learning how to use Excel's tools to organize, clean, and analyze data, you'll be able to extract meaningful insights from market research data and develop effective marketing strategies.

See salaries and explore the career path for Market Researcher

Operations Research Analyst

Operations Research Analysts use data analysis to improve efficiency and productivity in organizations. This course on Viewing and Manipulating Data in Excel 2016 may be helpful for Operations Research Analysts, as it provides a foundation in data management and analysis techniques. By learning how to use Excel's tools to organize, clean, and analyze data, you'll be able to identify inefficiencies, develop solutions, and improve processes within organizations.

See salaries and explore the career path for Operations Research Analyst

Data Scientist

Data Scientists use data to develop predictive models and solve complex problems. This course on Viewing and Manipulating Data in Excel 2016 may be helpful for Data Scientists, as it provides a foundation in data management and analysis techniques. By learning how to use Excel's tools to organize, clean, and analyze data, you'll be able to build more accurate models and extract more valuable insights from data.

See salaries and explore the career path for Data Scientist

Statistician

Statisticians collect, analyze, and interpret data to draw conclusions about populations. This course on Viewing and Manipulating Data in Excel 2016 may be useful for Statisticians, as it provides a foundation in data management and analysis techniques. By learning how to use Excel's tools to organize, clean, and analyze data, you'll be able to perform statistical analysis more efficiently and effectively.

See salaries and explore the career path for Statistician

Actuary

Actuaries use data to assess risk and uncertainty for insurance companies and other financial institutions. This course on Viewing and Manipulating Data in Excel 2016 may be helpful for Actuaries, as it provides a foundation in data management and analysis techniques. By learning how to use Excel's tools to organize, clean, and analyze data, you'll be able to develop more accurate risk models and make better decisions.

See salaries and explore the career path for Actuary

Auditor

Auditors examine financial records and other data to ensure that organizations are operating in accordance with laws and regulations. This course on Viewing and Manipulating Data in Excel 2016 may be useful for Auditors, as it provides a foundation in data management and analysis techniques. By learning how to use Excel's tools to organize, clean, and analyze data, you'll be able to perform audits more efficiently and effectively.

See salaries and explore the career path for Auditor

Consultant

Consultants provide expert advice and solutions to businesses and organizations. This course on Viewing and Manipulating Data in Excel 2016 may be helpful for Consultants, as it provides a foundation in data management and analysis techniques. By learning how to use Excel's tools to organize, clean, and analyze data, you'll be able to develop more effective solutions and make better recommendations to your clients.

See salaries and explore the career path for Consultant

Data Entry Clerk

Data Entry Clerks input data into computer systems. This course on Viewing and Manipulating Data in Excel 2016 may be useful for Data Entry Clerks, as it provides a foundation in data management and analysis techniques. By learning how to use Excel's tools to organize and clean data, you'll be able to enter data more accurately and efficiently.

See salaries and explore the career path for Data Entry Clerk

Office Administrator

Office Administrators provide administrative support to businesses and organizations. This course on Viewing and Manipulating Data in Excel 2016 may be useful for Office Administrators, as it provides a foundation in data management and analysis techniques. By learning how to use Excel's tools to organize, clean, and analyze data, you'll be able to manage data more efficiently and effectively.

See salaries and explore the career path for Office Administrator

Receptionist

Receptionists greet visitors, answer phones, and provide general administrative support to businesses and organizations. This course on Viewing and Manipulating Data in Excel 2016 may be helpful for Receptionists, as it provides a foundation in data management and analysis techniques. By learning how to use Excel's tools to organize, clean, and analyze data, you'll be able to manage data more efficiently and effectively.

See salaries and explore the career path for Receptionist

Customer Service Representative

Customer Service Representatives provide support to customers via phone, email, or chat. This course on Viewing and Manipulating Data in Excel 2016 may be helpful for Customer Service Representatives, as it provides a foundation in data management and analysis techniques. By learning how to use Excel's tools to organize, clean, and analyze data, you'll be able to manage customer data more efficiently and effectively.

See salaries and explore the career path for Customer Service Representative

Sales Associate

Sales Associates assist customers with their purchases and provide general customer service. This course on Viewing and Manipulating Data in Excel 2016 may be helpful for Sales Associates, as it provides a foundation in data management and analysis techniques. By learning how to use Excel's tools to organize, clean, and analyze data, you'll be able to manage sales data more efficiently and effectively.

See salaries and explore the career path for Sales Associate

Reading list

We've selected 18 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 Viewing and Manipulating Data in Excel 2016.

Excel 2019 Bible

Save

Comprehensive guide to Excel 2016, covering everything from basic to advanced topics. It valuable reference for anyone who wants to learn more about Excel.

Viewing and Manipulating Data in Excel 2016

Here's a deal for you

What's inside

Syllabus

Good to know

Save this course

Activities

Career center

Reading list

Share

Similar courses