100 Powerful Excel Tips with Microsoft Excel 2016 Premium class

Andreas Exadaktylos, Teacher | Expert Computer Scientist | Entrepreneur

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

      2:40
    • 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?

10 of 11 students recommendSee All

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 !
So many useful - time savers Excel tips and hacks. Great class and clear instructions!

139

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