Search 6,000+ CA Community College Courses

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

The Magic of Excel - Formulas, PivotTables, Charts, Flash Fill, Sort, Filtering, Functions & More

ExcelIsFun via YouTube

Start learning Write review

Overview

Discover the power of Excel in this comprehensive video tutorial that introduces key features to enhance productivity and efficiency in work, school, and daily life. Learn essential Excel functions including formulas, PivotTables, charts, Flash Fill, sorting, filtering, and more. Explore formatting techniques, keyboard shortcuts, and dynamic table features. Master payroll tax calculations, cell references, and data visualization through column charts. Create dynamic sales reports using PivotTables and clean data effortlessly with Flash Fill. Download provided files to practice along and reinforce your learning experience.

Syllabus

) What is Excel?.
) What does Excel do? 1) Calculations, 2) Storing & Formatting Data, 3) Data Analysis.
) Formatting to make our Data Look Good. Build a Template that you can use over and over..
) See how to create a List of Days of the Week Quickly using the "Angry Rabbit"..
) Formulas & Cell References to make our Job Easier! Learn about the Excel Functions: SUM, AVERAGE, MAX and MIN..
) Keyboard Shortcuts are Amazing. Learn how to highlight 5000 rows of data quickly..
) Payroll Tax Calculations Hard? Not With Excel : ).
) Relative Cell References in Formulas.
) Absolute Cell References in Formulas.
) Excel Table Feature makes everything Dynamic!!! Learn about how to Sort, Filter and create Dynamic Ranges (Update Automatically) using the Excel Table Features..
) Chart Your Results Dynamically!! Learn how to create a Column Chart for visualizing the difference across Categories..
) Boss Ask you to add All Sales for Each Employee!?!? Easy with a PivotTable! See how to create a Sales Report with a PivotTable, including how to Format and Pivot the PivotTable..
) Flash Fill to "Clean Your Data" in Seconds!.
) Summary of all topics..

Taught by

ExcelIsFun

Reviews

5.0 rating, based on 1 Class Central review

Start your review of The Magic of Excel - Formulas, PivotTables, Charts, Flash Fill, Sort, Filtering, Functions & More

  • Christy A Wilkens
    I needed to brush up on my Excel skills in applying for a new job, and I ran across this course. It took me a few minutes to realize the instructor was talking to a high school class, and then his tone of voice made much more sense. I enjoyed every minute of learning! He took the time to explain in different ways, to show examples for each thing he taught, and I was able to follow along easily. I would recommend this course to anyone needing to tone up their skills or learn basic data tables and their uses from scratch. I learned a couple of things I never knew before that will save me a lot of time, and I was reminded of several things I had forgotten! All in all, a definite win.
Start learning

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.