Excel for Beginners

Excel for Beginners

Course
en
English
16 h
This content is rated 0 out of 5
Source
  • From edx.org
Conditions
  • Self-paced
  • Free Access
  • Fee-based Certificate
More info
  • 4 Sequences
  • Introductive Level
  • Starts on July 31, 2023

Their employees are learning daily with Edflex

  • Safran
  • Air France
  • TotalEnergies
  • Generali
Learn more

Course details

Syllabus

Week 1: Getting to Know Excel & Entering Data

  • Excel Orientation and Spreadsheet Basics
  • Excel Data Types
  • Entering Data
  • Spreadsheet Setup

Week 2: Making Charts

  • Bar Charts, Simple and Clustered
  • Scatterplots
  • Pie and Stacked Column Charts
  • Combining Plot Types

Week 3: Manipulating & Summarizing Data Using Functions

  • Formulas and Functions in Excel
  • Absolute vs. Relative Cell References
  • Sorting & Filtering Data in Excel
  • Conditional functions

Week 4: Bringing it All Together

  • Converting Data Ranges to Tables
  • Unleashing the Power of Pivot Tables: Simple Tables and Charts
  • Unleashing the Power of Pivot Tables: Answering Complex Questions
  • Introducing the Course Project

Prerequisite

This course is meant to teach the fundamentals of Excel to beginning learners with little to no prior experience.

Instructors

Kevin Smith
Associate Professor of Biology 6 Davidson College

Editor

Davidson College

Platform

Harvard University, the Massachusetts Institute of Technology, and the University of California, Berkeley, are just some of the schools that you have at your fingertips with EdX. Through massive open online courses (MOOCs) from the world's best universities, you can develop your knowledge in literature, math, history, food and nutrition, and more. These online classes are taught by highly-regarded experts in the field. If you take a class on computer science through Harvard, you may be taught by David J. Malan, a senior lecturer on computer science at Harvard University for the School of Engineering and Applied Sciences. But there's not just one professor - you have access to the entire teaching staff, allowing you to receive feedback on assignments straight from the experts. Pursue a Verified Certificate to document your achievements and use your coursework for job and school applications, promotions, and more. EdX also works with top universities to conduct research, allowing them to learn more about learning. Using their findings, edX is able to provide students with the best and most effective courses, constantly enhancing the student experience.

This content is rated 4.5 out of 5
(no review)
This content is rated 4.5 out of 5
(no review)
Complete this resource to write a review