Excel Hacking I - Manipulate Data & Master Formatting (Beginners Intro)
Offered By: Skillshare
Course Description
Overview
Are You Ready To Take Your Excel To The Next Level?
I was an Excel Rookie too at some point. I put in a lot of hours to hone my skill and I managed to be recognised as an Excel expert in the companies that I worked for. Since then, I've gone on to teach thousands of students how to master Excel in the fastest possible time.
How Did I Do This?
By taking a different approach. I don't want this to be the regular Excel course, where I take you through every single different formula and functionality. I want you to:
- Focus on the benefit of each feature, rather than the means of getting there
- Understand the key elements that Excel experts use 80% of the time (my so-called Excel Hacks)
- Do this in a practical & applicable manner by following along the spreadsheets and completing them yourself
The End Result
I've differentiated the lectures between normal ones, Quick Hacks and Excel Hacks. These last 2 are designed to give you a great understanding of the must-know Excel features.
Here's what you will be able to do by the end of this class:
- Master the very basics of Excel - formula writing, formatting cells, manipulating rows & columns
- Using the Format Painter, Hiding & Grouping for better visibility
- Become an expert in fundamental functionalities such as Find and Replace, Auto-Fill, Copy & Paste Special to perform operations faster & more accurately
- Ultimate guide to Filtering, Flash-Fill, Sorting ...
- ...and much more!
Enroll now and let's start building your Excel journey together!
Syllabus
- Excel Hacking Series Promo
- Getting Started & Auto-Fill
- Getting Smart With Alignment-Based Formatting
- Customising The Format With Borders
- How To Effectively Manipulate Rows And Columns
- Quick Hack #1: Insert Several Rows More Effectively
- Beginners' Guide: Cell-Level Formatting
- The Fundamental Excel Tool You Must Be Aware Of
- Quick Hack #2: The Double Click Trick
- Use Hide & Group To Your Advantage
- Quick Hack #3: Effortlessly Select The Whole Sheet
- The Tool To Effortlessly Replicate Formulas & Values
- Quick Hack #4: Auto-Fill... With A Twist!
- The Easy Solution To Transposing Your Tables
- Excel Hack #1: The Essential Functionality I Heavily Used To Build Spreadsheets
- Quick Hack #5: Searching With Wildcard
- How To Make Sense Of Data-Packed Tables
- Sorting Efficiently In Excel
- Quick Hack #6: Fast Navigation With A Few Keys
- Ultimate Guide: Filtering
- How To Get Rid Of Duplicates In Your Data
- Using Subtotals To Your Advantage
- Quick Hack #7: How To Copy Visible Cells Only
- Excel Hack #2: Introducing Flash-Fill
Taught by
Dragos Stefanescu
Related Courses
Excel 2010Miríadax Intro to Data Science
Udacity Data Manipulation at Scale: Systems and Algorithms
University of Washington via Coursera Statistical Computing with R - a gentle introduction
University College London via Independent Introducción a Data Science: Programación Estadística con R
Universidad Nacional Autónoma de México via Coursera