Ir al contenido principal

DavidsonX: Excel for Beginners

4.6 stars
73 ratings

No prior knowledge or experience with Excel? No problem!

Mastering a basic skills in Excel will open the door to new opportunities, jobs, and more advanced skills that can help you be more efficient in your work or advance your career in your current or a future position. Come join us and reduce barriers to working with Excel!

Excel for Beginners
4 semanas
3–5 horas por semana
A tu ritmo
Avanza a tu ritmo
Gratis
Verificación opcional disponible

Hay una sesión disponible:

¡Ya se inscribieron 132,237! Una vez finalizada la sesión del curso, será archivadoAbre en una pestaña nueva.
Comienza el 29 mar
Termina el 31 jul

Sobre este curso

Omitir Sobre este curso

If you’re seeking to grow your knowledge of spreadsheets from zero to basic comfort and competence in Excel, then this is a perfect course for you.

The goal of this course is to provide you with a foundation on which you can build more advanced skills in the future. In this online course you will learn foundational Microsoft Excel (also applicable to Google Sheets) knowledge including spreadsheet and workbook anatomy, data entry, summary, and manipulation, plotting and visualization, and powerful tools such as functions, conditional formatting, vlookup, mathematical formulas, graphs, macros, keyboard shortcuts, cell references, filters, sorts, and pivot tables.

Not only will this Excel tutorial provide you with a step-by-step training to obtain strong skills in Excel basics, but you will also find several pathways to continue learning the skills you need after the course. Basic Excel skills are required for many jobs, but more advanced skills are often learned on the job. This course can help you quickly get to the point of being able to learn more advanced skills on your own or on the job.

The approach of this course will be different from a typical software course. Rather than focusing on moving through as many tools and skills as quickly as possible, this course will emphasize gaining comfort and familiarity with some of the most useful and foundational skills, the skills that will be key to your success in using Excel now and in the future. You will have the opportunity to practice these skills and identify general principles of successfully working with spreadsheets to be more efficient, reliable, and effective in your work.

De un vistazo

  • Institución: DavidsonX
  • Tema: Análisis de datos
  • Nivel: Introductory
  • Prerrequisitos:

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

  • Idioma: English
  • Transcripciones de video: اَلْعَرَبِيَّةُ, Deutsch, English, Español, Français, हिन्दी, Bahasa Indonesia, Português, Kiswahili, తెలుగు, Türkçe, 中文
  • Programas asociados:
  • Habilidades asociadas:Basic Math, Data Entry, Spreadsheets, Keyboard Shortcuts, Google Sheets, Anatomy, Excel Macros, Conditional Formatting, Pivot Tables And Charts, Vlookups, Microsoft Excel

Lo que aprenderás

Omitir Lo que aprenderás
  • Confidence with spreadsheet layout, anatomy, and terminology
  • Good practices for data entry, storage, and manipulation in spreadsheets
  • Common methods of data manipulation and summary such as sorting, filtering, writing simple equations, and using pivot tables
  • Common methods of data visualization using charts

Plan de estudios

Omitir Plan de estudios

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

Preguntas frecuentes

Omitir Preguntas frecuentes

I have never worked with Excel. Should I take a prerequisite course prior to starting Excel for Beginners?

You've come to the right place. This course is built for beginners with no prior experience and serves as a refresher for those who have used Excel in the past.

What is the value of the verified track?

Beyond the certificate which you can post on LinkedIn and other social media channels to show off your accomplishment to others, you will also gain valuable supplementary matertials to dive deeper and take the next step beyond the audit track content to learn deeper within Excel.

Este curso es parte del programa Data Analysis Basics with Excel and R Professional Certificate

Más información 
Instrucción por expertos
2 cursos de capacitación
A tu ritmo
Avanza a tu ritmo
2 meses
4 - 8 horas semanales

¿Te interesa este curso para tu negocio o equipo?

Capacita a tus empleados en los temas más solicitados con edX para Negocios.