Excel Hacking III - Manipulate Text, Tables & Conditional Formatting | Dragos Stefanescu | Skillshare

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!

98

Students

1

Projects

  • --
  • Beginner
  • Intermediate
  • Advanced
  • All Levels
  • Beg/Int
  • Int/Adv

Level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

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

Report class