100 Powerful Excel Tips with Microsoft Excel 2016

Andreas Exadaktylos, Teacher | Expert Computer Scientist | Entrepreneur

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
102 Videos (2h 50m)
    • Welcome to the class

      2:40
    • 2017 New Hacks: How To Protect Excel Workbooks, Worksheets And Cells

      6:13
    • TIP 1 Navigate between worksheets quickly

      1:54
    • TIP 2 How to prevent someone to unhide a worksheet – Very Hidden Property

      2:02
    • TIP 3 Blocking a user to interact outside a specific range – ScrollArea Property

      1:08
    • TIP 4 Entering Data to Multiple Worksheets at a time

      1:23
    • TIP 5 Learning different techniques for navigating within a given worksheet

      1:47
    • TIP 6 Entering Data quickly and efficiently

      2:05
    • TIP 7 How to use FlashFill to fill values in a range rapidly

      1:28
    • TIP 8 Changing values without formulas

      1:35
    • TIP 9 How to generate Random Decimal Numbers between 0 and 1

      1:13
    • TIP 10 Creating a charts with keyboard Shortcuts

      1:24
    • TIP 11 Customizing the Quick Access Toolbar

      1:59
    • TIP 12 Customizing the Ribbon

      1:57
    • TIP 13 Using Keyboard to Access Ribbon

      1:03
    • TIP 14 Undo, Redo and Repeat

      1:47
    • TIP 15 Navigate between workbooks quickly

      1:42
    • TIP 16 Zooming in and out quickly

      1:36
    • TIP 17 Applying Document Themes in a Workbook

      1:18
    • TIP 18 Copying and Moving Worksheets with various ways

      1:52
    • TIP 19 The best techniques for inserting, deleting, hiding and unhiding columns and rows

      2:32
    • TIP 20 How to print a 2 page worksheet on 1 page

      1:02
    • TIP 21 Hiding scrollbars in a worksheet

      1:11
    • TIP 22 How to set the number of worksheets

      1:01
    • TIP 23 Using Status bar to get a quick Summary of your Data

      1:23
    • TIP 24 How to hide the Status Bar

      1:37
    • TIP 25 How to display a print preview using Keyboard Shortcuts

      1:00
    • TIP 26 How to freeze titles and split screens

      2:13
    • TIP 27 Saving Excel as a read only Web Page file

      1:13
    • TIP 28 How to analyze an active Workbook using the Inquire add in

      2:08
    • TIP 29 Getting Data from a PDF File

      1:22
    • TIP 30 Solving the problem with Leading Zero

      1:35
    • TIP 31 How to add text to a number

      1:14
    • TIP 32 How to enter a Line Break into one of your cell’s data

      1:11
    • TIP 33 How to show hours greater than 24

      1:08
    • TIP 34 Using Wrap Text and Shrink Cell Tools to have the size of the cells right

      1:50
    • TIP 35 Creating a Conditional Format based on a value

      1:50
    • TIP 36 Identifying and fixing error inside of an Excel Formula

      1:31
    • TIP 37 Converting formulas to values easy

      1:19
    • TIP 38 How to add comments inside Formulas

      1:11
    • TIP 39 How to highlight formula cells using Conditional Formatting

      2:09
    • TIP 40 How to color Rows using Conditional Formatting Alternate row shading

      2:29
    • TIP 41 How to Format Numbers using Keystroke Shortcuts

      1:36
    • TIP 42 How to modify or create a cell style

      2:31
    • TIP 43 Duplicate records and how to get rid of these

      1:38
    • TIP 44 Creating Bulleted List

      1:17
    • TIP 45 Format Painter Tips

      1:40
    • TIP 46 How to insert a Watermark

      2:07
    • TIP 47 Making your comments stand out

      2:00
    • TIP 48 How to compare two lists of items and identify differences between them

      3:01
    • TIP 49 How to select Data using various Keystroke Shortcuts

      2:17
    • TIP 50 Copying and Moving Data with various ways

      1:29
    • TIP 51 Using Fill Handle to enter Sequences of Values

      1:40
    • TIP 52 The Paste Special feature

      1:52
    • TIP 53 Using Quick Analysis Tool to find information about your Data

      1:21
    • TIP 54 How to set a specific print area

      1:09
    • TIP 55 How to create a hyperlink to other worksheets

      1:54
    • TIP 56 How to create and save custom views of a worksheet

      2:03
    • TIP 57 Presenting Information in a more Compact way, using Group Tool

      1:17
    • TIP 58 Applying Goal Seek Tool to find a target

      1:44
    • TIP 59 Using Pick from Drop down List and enter Data quickly

      1:09
    • TIP 60 Forecasting Scenarios with Scenario Manager

      3:16
    • TIP #61 Using AutoCorrect to Enter Data Fast

      1:33
    • TIP #62 Creating a Custom List

      2:57
    • TIP #63 How to Create a Data Entry Form

      1:33
    • TIP #64 Eliminating Duplicate Values from a Data List

      1:32
    • TIP #65 Monitoring the Value in a Worksheet using Watch Window Tool

      1:46
    • TIP #66 Filling non adjacent Cells with the Current Entry

      1:16
    • TIP #67 Highlighting Blank Cells and Sorting Columns with Them

      2:49
    • TIP #68 Making the Rows Columns and the Columns Rows

      1:15
    • TIP #69 Filling Random Values into Every Cell in a Selection

      1:41
    • TIP 75 How to calculate the number of Days between two Date values

      0:57
    • TIP 76 How to look up Data without using VLOOKUP Function

      2:23
    • TIP #71 How to Enter a Series of Dates using Auto Fill Options

      1:43
    • TIP #70 How to use COUNTIF and Data Validation to Prevent Duplications

      2:26
    • TIP #72 The AutoSum Magic

      1:51
    • TIP 77 Using the new in Excel 2013 Function PDURATION to calculate time

      1:21
    • TIP 78 How to Round values with various ways

      0:07
    • TIP #73 How to Enter the Current Date or Time

      1:27
    • TIP 74 Finding related formulas easy

      1:59
    • TIP 79 Calculating Running Totals

      0:07
    • TIP 80 Using Named Ranges in Formulas

      1:30
    • TIP 81 Displaying the Formula Text

      0:07
    • TIP 82 Defining a name that refers to a constant

      0:07
    • TIP #83 Displaying All Worksheet Formulas in a Second

      1:00
    • TIP #84 Using TRIM Function to Get Rid of Unwanted Spaces

      1:39
    • TIP #85 How to Calculate a Person's Age

      1:43
    • TIP #86 How to Convert Values between Measurement Systems

      1:48
    • TIP #87 Locking and Hiding Formula Cells

      2:16
    • TIP 88 Create a table using keyboard shortcuts

      1:07
    • TIP 89 Adding a unique identification number in your table

      1:11
    • TIP 90 Formatting Data as Table with Table Styles

      1:22
    • TIP 91 Using the table reference to create a formula

      1:00
    • TIP 92 Create a recommended PivotTable quickly

      0:55
    • TIP 93 How to create separate worksheets from PivotTable using Filters Area

      1:21
    • TIP 94 Let Excel decide which chart is ideal for your data

      0:57
    • TIP 95 How to move or resize a Chart using special keys

      2:21
    • TIP 96 Create mini charts using Sparklines

      2:55
    • TIP 97 Linking Chart Titles with Cell Content

      2:27
    • TIP 98 How to make all the Charts exactly the same size

      1:14
    • TIP 99 How to deal with missing data for a Chart

      1:22
    • TIP 100 Creating simple Column and Pie Charts

      1:30

About This Class

If you’ve ever thought to yourself, “There has to be a better way to do this,” while using Excel, then know you're probably right. With over 100 HD Lectures + Excel Templates, I’m going to teach you the best 100 time-saving tips and tricks in Excel to make Excel more efficient than you ever imagined.

I created this Class to help Excel users avoid common spreadsheet stumbling blocks and reveal ways to maximize the power of Excel. I started with no knowledge of Excel and when I started to use it on a daily basis, I said to myself, “There has to be a better way to do this.” In this class, I compile all my notes and my knowledge and I want to teach you how to improve your skills in short order.

Are you ready to fire up your skills and become a super-efficient Excel user?

12 of 13 students recommendSee All

Excellent. I wrote down many, many pages of helpful tips. Andreas sets a quick pace and jam packs the material with valuable information. There are a couple of chapters that are only 7 seconds with nothing but the introductory graphics, not sure about those, it'd be even better if those were fixed. Thanks, Andreas!!
Learned so many hidden hacks that didn't know in Excel! Great class!
I use Excel many years. However many of these hacks where unknown to me. Learned new great tips. Thanks !

191

Students

1

Project

Andreas Exadaktylos

Teacher | Expert Computer Scientist | Entrepreneur

LinkedIn: https://www.linkedin.com/in/andreasexadaktylos

Hi, I am Andreas and I'm a teacher. I really love learning and teaching whenever i can.

I have over 16 years of experience in teaching as an instructor. I have my own computer learning school, called Futurekids, from 2001 to now. I am the founder of Mellon Training, an online video tutorials learning school.

I have a Masters Degree in Computer Science and a Degree in Electronic Engineering.

I always wanted to create my own business. Being your own boss is an incredibly liberating experience but difficult as well.

I have a passion for software products that make people's lives easier. I love to create websites and optimizing them with Search Engine optimization techniques. I created my online e-shop, called Bite me not jewels, with my wife.

I live in Rodos, a beautiful Greek island. When i am not working, i love being with my family and my two kids. Travel, forex trading and reading books are my favorite hobbies