Excel Hacking III - Manipulate Text, Tables & Conditional Formatting

Dragos Stefanescu, TeacHack Founder - Teaching 1000s Online

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
22 Videos (1h 9m)
    • Excel Hacking Series Trailer

      1:44
    • Introduction

      2:13
    • Ensure Proper Formatting With These Formulas

      3:02
    • Here's How To Join Text Strings Together

      3:48
    • Quick Hack: Join Text Strings Without Concatenating

      1:15
    • 3 Ways To Extract Bits Of Text

      3:08
    • Ultimate Guide: Extracting Text By Identifying Specific Strings

      5:37
    • Quick Hack #10: Ensure Text Accuracy

      5:15
    • The Built-In Functionality To Customise Text Strings

      4:09
    • Intro

      1:48
    • Beginners' Guide: Excel Table Creation

      2:33
    • Table Design Basics

      2:03
    • Quick Hack: Adding Total Rows To Tables

      1:23
    • Quick Hack #15: 3 Awesome Table Functionalities

      3:57
    • Conditional Formatting Essentials

      3:17
    • How To Manage Conditional Formatting

      2:21
    • Conditional Formatting With Formulas

      2:49
    • Excel Hack #6: 3 Features To Take Conditional Formatting To The Next Level

      4:53
    • Excel Chart Creation Tutorial

      2:36
    • Quick Hack: How Do I Know What Type Of Chart To Choose?

      2:08
    • Customising Excel Charts

      5:14
    • Excel Hack: How To Make Snap Judgements On Large Sets Of Data

      3:45

About This Class

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:

  • Know exactly how to Manipulate Text Strings in Excel - join text strings together, identify specific strings or ensure automatic proper formatting.
  • Master Excel Tables and all the functionalities that come with them
  • Become an expert of Conditional Formatting and even make use of added features such as Sparklines, Data Bars or Icon Sets
  • Understand how to create & manipulate Excel Charts, decide which type to use and be aware of the plethora of choices available.

Enroll now and let's start building your Excel journey together!

21 of 21 students recommendSee All

Wonderful class. The pace is great. Dragos is a wonderful teacher. He speaks clearly, shows good tips/techniques, and keeps it moving. I'm an experienced Excel user but I picked up a few tips. Always more to learn with Excel...thanks Dragos!
wow! i didnt know i could do that. this video really helps me.
Nice presentations related to excel. it will definately help me out in my work

92

Students

1

Project

Dragos Stefanescu

TeacHack Founder - Teaching 1000s Online

About Me

I'm an Internet Entrepreneur with a background in both the Management Consulting & Telecommunications industries. The skills that I have acquired during those stints and in previous years in general have unleashed my passion to teach.

I have a wide array of skills that I share with you via my courses

(1) Social Media

One of my true passions, I have invested a lot of time building a presence online. Highlights include:

Creating a connection base of 100+...

See full profile