YoVDO

Microsoft Excel Tutorial for Beginners - Full Course

Offered By: freeCodeCamp

Tags

Microsoft Excel Courses Pivot Tables Courses Text Manipulation Courses Data Entry Courses VLOOKUP Courses

Course Description

Overview

Master Microsoft Excel fundamentals through hands-on practice with six real-world projects in this comprehensive tutorial for beginners. Gain essential skills applicable to both Excel and Google Sheets, including data entry, spreadsheet navigation, formula creation, chart and graph generation, and understanding relative vs. absolute references. Learn to import and export data, implement VLOOKUP, utilize pivot tables, and manipulate text through splitting and concatenation. Progress through projects covering payroll, gradebook management, decision-making factors, sales database creation, car inventory tracking, and problem-solving templates. Develop practical Excel proficiency to enhance your data analysis and management capabilities in various professional contexts.

Syllabus

Intro.
Payroll.
Gradebook.
Decision Factors.
Sales Database.
Car Inventory.
Problem Solving Templates.


Taught by

freeCodeCamp.org

Related Courses

Análisis de datos: Llévalo al MAX()
Delft University of Technology via edX
Create Charts and Dashboard using Google Sheets
Coursera Project Network via Coursera
Data Processing and Analysis with Excel
Rochester Institute of Technology via edX
Grab Data Fast with Vertical and Horizontal LOOKUP
Coursera Project Network via Coursera
Evaluate Profit Margins with VLOOKUP in Google Sheets
Coursera Project Network via Coursera