100 Powerful Excel Tips with Microsoft Excel 2016
Andreas Exadaktylos, Teacher | Expert Computer Scientist | Entrepreneur
-
-
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?
Students
Project
-
- --
- 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.
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...