OpenCourser brand icon
Sign in
We may earn an affiliate commission when you visit our partners.
Course Discontinued We've found some alternatives for you:

Top Active Alternatives

Loading Data into Excel 2016 is no longer accepting new enrollments. We've matched the highest-rated active courses in this subject:

Read Reviews → Enroll Active
Read Reviews → Enroll Active
Coursera ★ 4.9
Splunk Query Language and Data Analysis
By George Washington University
Read Reviews → Enroll Active
Pluralsight logo

Loading Data into Excel 2016

Pratheerth Padman

In this course, you'll go from being introduced to Microsoft Excel and its components to discovering how to load data into excel from 6 different types/sources. It is the first in a series that is designed to help you achieve mastery over Excel.

Read more

In this course, you'll go from being introduced to Microsoft Excel and its components to discovering how to load data into excel from 6 different types/sources. It is the first in a series that is designed to help you achieve mastery over Excel.

This is the first course on the Microsoft Excel Data Manipulation, Presentation, and Analysis path and as such this assumes no technical knowledge about excel. First, you'll start by getting introduced to Excel itself. Next, you'll discover what worksheets and workbooks are and how to manipulate them by moving and copying them around. Then, you'll move on to the meat of the course – importing data from various sources into Excel. Finally, you'll be given a brief introduction to these sources and the data usually found within and then go through the steps of loading the data into Excel. When you're finished with the course, you'll have a primary knowledge about Microsoft Excel and its components and how to load data into Excel from various sources.

This course is no longer available. Find something similar by browsing:
Microsoft Excel Data Import Data Manipulation Data Analysis Workbooks Worksheets

What's inside

Syllabus

Traffic lights

Read about what's good
what should give you pause
and possible dealbreakers
Suitable for beginners, as it assumes no prior knowledge of Microsoft Excel
Lays a foundation for subsequent courses in the Microsoft Excel Data Manipulation, Presentation, and Analysis path
Taught by Pratheerth Padman, who has expertise in Microsoft Excel and data analysis

Save this course

Create your own learning path. Save this course 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 Loading Data into Excel 2016 with these activities:
Practice creating and manipulating workbooks
Practice creating and modifying workbooks and worksheets to gain hands-on experience with these fundamental Excel components.
Browse courses on Workbooks
Show steps
  • Create a new workbook with multiple worksheets and explore their structure.
  • Change worksheet names and colors to organize and identify them effectively.
  • Move and copy worksheets within the workbook to rearrange their order and create duplicates.
Practice exercises on data cleaning and transformation
Gain hands-on experience in cleaning and transforming data in Excel, addressing common data quality issues and preparing it for analysis.
Browse courses on Data Cleaning
Show steps
  • Identify and remove duplicate data.
  • Handle missing values by imputing or removing them.
  • Convert data types and formats to ensure consistency.
Guided tutorial on importing data from various sources
Follow a step-by-step tutorial on how to import data from different sources into Excel, including text files, CSV files, databases, and external applications.
Browse courses on Data Import
Show steps
  • Identify the different data sources you can import from in Excel.
  • Choose the appropriate import option based on the source of the data.
  • Configure import settings to ensure accurate and complete data transfer.
Five other activities
Expand to see all activities and additional details
Show all eight activities
Tutorial on best practices for Excel data manipulation
Explore established best practices for data manipulation in Excel, ensuring efficient and error-free workflows.
Show steps
  • Identify common pitfalls and errors in Excel data manipulation.
  • Learn techniques for avoiding and mitigating these issues.
  • Apply best practices to improve the accuracy, efficiency, and maintainability of your Excel data manipulation tasks.
Create a cheat sheet of Excel functions and formulas
Compile a comprehensive cheat sheet summarizing key Excel functions and formulas, providing quick and easy reference for data manipulation tasks.
Browse courses on Excel Functions
Show steps
  • Research and identify the most commonly used Excel functions and formulas.
  • Create a table or document with columns for function name, description, syntax, and examples.
  • Organize the cheat sheet logically, grouping functions by category or purpose.
Create a summary of different data sources
Create a table or document summarizing the different data sources you can import into Excel, their strengths and limitations, and examples of their use cases.
Browse courses on Data Sources
Show steps
  • Research and identify the various data sources that can be imported into Excel.
  • Create a table or document with columns for data source name, description, strengths, limitations, and use cases.
  • Populate the table with information for each data source.
Peer review of Excel data manipulation techniques
Collaborate with peers to review and provide feedback on each other's Excel data manipulation techniques, sharing knowledge and improving understanding.
Browse courses on Data Manipulation
Show steps
  • Find a peer who is also taking the course or has experience with Excel data manipulation.
  • Share your Excel workbooks or specific data manipulation techniques with your peer for review.
  • Provide constructive feedback on your peer's work, focusing on the accuracy, efficiency, and clarity of their techniques.
Project: Build a data dashboard using Excel
Apply the skills learned in the course to create a practical and visually appealing data dashboard in Excel, showcasing data analysis and presentation capabilities.
Browse courses on Data Dashboards
Show steps
  • Identify a dataset or topic for which you want to create a data dashboard.
  • Design the layout and structure of the dashboard, including charts, graphs, and other visualization elements.
  • Import and clean the data into Excel and apply appropriate formulas and functions for calculations and analysis.
  • Create charts, graphs, and tables to visualize and summarize the data.
  • Format and style the dashboard to make it visually appealing and easy to understand.

Career center

Learners who complete Loading Data into Excel 2016 will develop knowledge and skills that may be useful to these careers:
Data Scientist
Data Scientists use their expertise in statistics, machine learning, and data management to build models that can predict future outcomes. They may work in a variety of industries, from healthcare to finance to retail. This course will teach you how to import and analyze data from a variety of sources, which is a critical skill for any Data Scientist. You will also learn how to build and evaluate models, which is essential for making accurate predictions.
See salaries and explore the career path for Data Scientist
Data Analyst
Data Analysts are responsible for transforming raw data into a clear format that can be used for decision-making. They may work in many industries, from healthcare to retail to technology. This course will teach you how to import and analyze data from a variety of sources, which is a critical skill for any Data Analyst. Whether you are a novice or a seasoned professional, this course may be a helpful addition to your learning journey.
See salaries and explore the career path for Data Analyst
Analyst
Analysts typically translate complex data into actionable insights. They help decision makers at all levels of an organization make better choices. Almost every industry employs analysts of some kind, but a course on loading data like this one can be especially useful to those in business and finance. It will teach you how to structure and analyze data to identify trends and patterns. If you want to use data to tell persuasive stories, this course will go a long way in helping you on your journey to becoming an Analyst.
See salaries and explore the career path for Analyst
Database Administrator
Database Administrators are responsible for managing and maintaining databases. They ensure that data is accurate, secure, and accessible. This course will teach you the basics of data management, which is essential for any Database Administrator. You will learn how to import and analyze data from a variety of sources, as well as how to structure and protect your data.
See salaries and explore the career path for Database Administrator
Financial Analyst
Financial Analysts use financial data to make recommendations about investments. They may work in a variety of industries, from banking to insurance to investment management. This course will teach you how to import and analyze financial data, which is a critical skill for any Financial Analyst. You will also learn how to build and evaluate models, which is essential for making accurate predictions about financial markets.
See salaries and explore the career path for Financial Analyst
Market Researcher
Market Researchers collect and analyze data about consumers and markets. They use this information to help businesses make better decisions about their products and services. This course will teach you how to import and analyze data from a variety of sources, which is a critical skill for any Market Researcher. You will also learn how to build and evaluate models, which is essential for making accurate predictions about consumer behavior.
See salaries and explore the career path for Market Researcher
Quantitative Analyst
Quantitative Analysts use mathematical and statistical techniques to analyze financial data. They may work in a variety of industries, from banking to insurance to investment management. This course will teach you the basics of data management, which is essential for any Quantitative Analyst. You will learn how to import and analyze data from a variety of sources, as well as how to build and evaluate models.
See salaries and explore the career path for Quantitative Analyst
Statistician
Statisticians collect, analyze, and interpret data. They may work in a variety of industries, from healthcare to finance to market research. This course will teach you the basics of data management, which is essential for any Statistician. You will learn how to import and analyze data from a variety of sources, as well as how to build and evaluate models.
See salaries and explore the career path for Statistician
Operations Research Analyst
Operations Research Analysts use mathematical and analytical techniques to solve problems in a variety of industries, including healthcare, manufacturing, and transportation. This course will teach you the basics of data management, which is essential for any Operations Research Analyst. You will learn how to import and analyze data from a variety of sources, as well as how to build and evaluate models.
See salaries and explore the career path for Operations Research Analyst
Product Manager
Product Managers are responsible for the development and launch of new products. They work with engineers, designers, and marketers to ensure that products meet the needs of customers. This course will teach you the basics of data management, which is essential for any Product Manager. You will learn how to import and analyze data from a variety of sources, as well as how to build and evaluate models.
See salaries and explore the career path for Product Manager
Data Engineer
Data Engineers build and maintain the systems that collect, store, and manage data. This course will help you build a foundation in data management, which is essential for any Data Engineer. You will learn how to import and analyze data from a variety of sources, as well as how to structure and protect your data.
See salaries and explore the career path for Data Engineer
Strategy Analyst
Strategy Analysts develop and implement strategies for organizations. They may work in a variety of industries, from consulting to healthcare to technology. This course will teach you the basics of data management, which is essential for any Strategy Analyst. You will learn how to import and analyze data from a variety of sources, as well as how to build and evaluate models.
See salaries and explore the career path for Strategy Analyst
Risk Analyst
Risk Analysts identify and assess risks that may affect an organization. They may work in a variety of industries, from finance to healthcare to manufacturing. This course will teach you the basics of data management, which is essential for any Risk Analyst. You will learn how to import and analyze data from a variety of sources, as well as how to build and evaluate models.
See salaries and explore the career path for Risk Analyst
Information Architect
Information Architects design and organize websites and other digital products. They ensure that users can easily find and understand the information they are looking for. This course will teach you the basics of data management, which is essential for any Information Architect. You will learn how to import and analyze data from a variety of sources, as well as how to structure and protect your data.
See salaries and explore the career path for Information Architect
System Analyst
System Analysts design and implement computer systems. They work with users to understand their needs and then develop systems that meet those needs. This course will teach you the basics of data management, which is essential for any System Analyst. You will learn how to import and analyze data from a variety of sources, as well as how to build and evaluate models.
See salaries and explore the career path for System Analyst

Reading list

We've selected 11 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 Loading Data into Excel 2016.
Cover image
RibbonX
Save
Provides a comprehensive overview of VBA for Excel developers. It covers a wide range of topics, from basic programming concepts to advanced techniques such as object-oriented programming and data access. The book is written in a clear and concise style, with plenty of examples and exercises.
RibbonX: Customizing the Office 2007 Ribbon
Kindle Edition
$$
Cover image
Microsoft Excel 365 Bible
Save
Is an authoritative reference for experienced Excel users, providing in-depth coverage of complex topics such as data analysis, financial modeling, and automation.
Microsoft Excel 365 Bible
Paperback
$$
Microsoft Excel 365 Bible
Kindle Edition
$$
Cover image
Intermediate Futures And Options: An Active...
Save
Comprehensive guide to using Visual Basic for Applications (VBA) to automate Excel tasks and create custom Excel solutions. It great resource for anyone who wants to learn VBA or who wants to take their Excel skills to the next level.
Intermediate Futures and Options: An Active...
Paperback
$$$
Cover image
Microsoft Excel Data Analysis and Business Modeling...
Save
Provides a comprehensive overview of how to use Excel for data analysis and business modeling. It covers a wide range of topics from basic statistical analysis to advanced techniques such as predictive analytics and optimization. The book is written in a clear and concise style, with plenty of examples and exercises.
Microsoft Excel Data Analysis and Business Modeling...
Paperback
$$
Microsoft Excel Data Analysis and Business Modeling...
Kindle Edition
$$
Cover image
Excel 365 Bible
Save
Is useful for learning how to use Excel for data analysis, data visualization, and other statistical tasks. It great resource for anyone who wants to use Excel for more than just basic data entry and calculations.
Microsoft Excel 365 Bible
Paperback
$$
Microsoft Excel 365 Bible
Kindle Edition
$$
Cover image
Microsoft Excel Formulas and Functions (Office 2021...
Save
Provides a comprehensive overview of the formulas and functions available in Excel 2019. It covers a wide range of topics, from basic arithmetic functions to advanced statistical and financial functions. The book is written in a clear and concise style, with plenty of examples.
Microsoft Excel Formulas and Functions (Office 2021...
Paperback
$$
Microsoft Excel Formulas and Functions (Office 2021...
Kindle Edition
$$
Cover image
Excel Power Pivot & Power Query For Dummies
Save
Comprehensive guide to writing VBA code for Excel. It covers a wide range of topics from basic programming concepts to advanced techniques such as object-oriented programming and data access. This book can be very helpful for those interested in learning how to automate Excel with VBA.
Excel Power Pivot & Power Query For Dummies
Paperback
Check
Excel Power Pivot & Power Query For Dummies
Kindle Edition
Check
Cover image
Excel 2019 All-in-One For Dummies
Save
This best-selling book introduces Microsoft Excel 2019 and shows you how to master the latest features and functions. It is written in a clear and concise style, with step-by-step instructions and plenty of examples.
Excel 2019 All-in-One For Dummies
Paperback
$$
Excel 2019 All-in-One For Dummies
Kindle Edition
$$
Cover image
Microsoft Excel 2019 Step by Step
Save
Comprehensive guide to Microsoft Excel 2019, designed to enable you to create and modify simple and complex workbooks, format data and text, and quickly find the information you need. This book useful reference tool for users of all levels.
Microsoft Excel 2019 Step by Step
Paperback
$$
Microsoft Excel 2019 Step by Step
Kindle Edition
$$
Cover image
Microsoft Excel Pivot Table Data Crunching (Office...
Save
Provides a detailed overview of many of the advanced but commonly used features in Excel. It can serve as a great way to expand your knowledge of Excel.
Microsoft Excel Pivot Table Data Crunching (Office...
Paperback
$$
Microsoft Excel Pivot Table Data Crunching (Office...
Kindle Edition
$$
Cover image
Excel 2019 For Dummies
Save
Quick reference guide to Excel 2019, providing essential information in a concise and easy-to-use format. It great resource for anyone who needs a quick refresher on Excel or who wants to learn the basics of the program.
Excel 2019 For Dummies
Paperback
Check
Excel 2019 For Dummies
Kindle Edition
Check

Share

Help others find this course page by sharing it with your friends and followers:
Facebook
LinkedIn
Reddit
X
Link
Email

Similar courses

Here are nine courses similar to Loading Data into Excel 2016.
Data calculations in Microsoft Excel
Most relevant
From Raw to Ready: Data Preparation in Python
Most relevant
Foundations of Data Analysis with Pandas and Python
Most relevant
Building a Company’s database using MySQL and SQL
Most relevant
Work Smarter with Microsoft Excel
Most relevant
Using Date and Time Functions in Excel
Most relevant
Excel Basics for Data Analysis
Most relevant
Functions, Data Analysis, Presentation and Finance w/...
Most relevant
Microsoft Excel VBA and Macros
Most relevant

Pluralsight Buyer Protection & Guarantee

Verified partner policies & purchase protections

Enterprise Technology Platform
Free Trial & Audit

10-Day Free Trial

10-day free trial (up to 200 minutes of content) with access to the Skills video library and skill assessments. Cancel before day 10 to avoid automatic conversion.

Return & Refund Policy

Cancel Anytime (Non-Refundable Once Billed)

Cancel easily online anytime before the 10-day trial expires to prevent billing. Once subscription fees are paid, individual subscriptions are non-refundable (cancellation stops future renewals).

Buyer Protections

Verified Academic & Industry Partner

Skill IQ and Role IQ diagnostic benchmark assessments, hands-on lab environments, and curated learning paths designed by technology leaders.

Key Purchase Protections
10-day free trial on individual Skills plans
Skill IQ assessments to benchmark proficiency
Cancel anytime online before trial ends without fees
Hands-on interactive labs and enterprise-grade tech content
OpenCourser Verified Partner Policy details last reviewed: 2026-10-22
Course image
Time
48 hours
Level
Introductory
Via
Pluralsight
Instructor
Pratheerth Padman
Language
English
This course belongs to a collection called Microsoft Excel Data Manipulation, Presentation, and Analysis. It's comprised of 11 courses:
  1. Loading Data into Excel 2016 (viewing)
  2. Searching and Manipulating Data in Excel 2016
  3. Formatting Excel 2016 Worksheets and Cells
  4. Calculating Cell Values with Formulas
  5. Summarizing and Organizing Data in Excel
  6. Displaying Tables with Excel
  7. Charting Data with Excel
  8. Exploring Data with PivotTables
  9. Visualizing Data with PivotCharts
  10. Formatting Excel Objects
  11. Distributing Excel Workbooks
Traffic lights
Read about what's good
what should give you pause
and possible dealbreakers
Suitable for beginners, as it assumes no prior knowledge of Microsoft Excel
Lays a foundation for subsequent courses in the Microsoft Excel Data Manipulation, Presentation, and Analysis path
Taught by Pratheerth Padman, who has expertise in Microsoft Excel and data analysis
Share this
Share to help others discover this course.
Facebook LinkedIn X Reddit Link Email
Begin learning today
This course is currently discontinued or unavailable. See active alternatives above.
Course Unavailable
Save for later
Add this course to your list. Find it anytime.
Save
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 - 2025 OpenCourser