Skillsharebeginneren

Excel Bootcamp - Master Data and Formulas like a pro

Master Excel fundamentals! Learn data management with practical spreadsheet creation. Perfect for beginners.

75students
1h 19m
Certificate
Keith Griggs
Keith GriggsInstructor

Course Content

Excel Bootcamp - Master Data and Formulas like a pro is a beginner-level Skillshare course taught by Keith Griggs. It runs 1h 19m, is taught in English, and includes a certificate of completion. 75 students have enrolled. It is a paid course, first published October 2022.

Master Excel: From Beginner to Pro – Learn Essential Skills

Unlock the power of Excel with this comprehensive course designed to take you from a beginner to an Excel expert. This hands-on course focuses on practical application, with a downloadable spreadsheet to follow along and compare your work. Learn Excel fundamentals and develop skills you can immediately use to boost your productivity and impress your colleagues.

This course covers a wide range of essential Excel skills, including:

  • Data Management:
    • Creating and organizing a table of data in Excel.
    • Effective filtering techniques to analyze your data.
    • Identifying and removing duplicates efficiently.
    • Extracting data using powerful VLOOKUP and HLOOKUP functions.
  • Data Transformation:
    • Splitting cells into multiple columns.
    • Merging columns for better data presentation.
    • Searching and replacing text within your spreadsheets.
  • Formulas & Calculations:
    • Understanding and using simple formulas for calculations.
    • Counting cells with data for accurate reporting.
    • Rounding numbers for professional formatting.
    • Calculating percentage increases quickly and easily.
    • Copying formulas using absolute and relative references to ensure accuracy.
  • Advanced Techniques:
    • Automatic table formatting with filters for a polished look.
    • A closer look at formulas and their application.

This course is designed for anyone who wants to improve their Excel skills, whether you're a student, professional, or simply looking to become more efficient with your data. You'll learn to create professional-looking spreadsheets, analyze data effectively, and save valuable time.

Join over 53,609 satisfied students who have transformed their Excel abilities! See what they're saying:

  • "Very good hands-on course on Excel" - Aleksandar A.
  • "Easy to follow after previous basic courses" - Frank F.
  • "Excellent delivery and very easy to understand" - Erick K.
  • "Helpful and clear, with tips for creating charts" - Mark J.
  • "Very Useful & Informative" - Ahsan A.

Start your journey to Excel mastery today!

$ whoami — the devs behind tutorialsearch.io

Need a web app built? Hire the team behind TutorialSearch.io

We ship fast, production-grade full-stack apps (Next.js, React, edge infra) — the same stack that powers this site.

5.0
53m
beginner
pluralsight
5.0(413)
3h 45m
beginner
skillshare
5.0
1h 29m
beginner
pluralsight