Excel Tips & Shortcuts: 100+ Powerful Hacks for Beginners

Focused View

Andreas Exadaktylos

4:05:50

10 View

1 - Introduction to the Course

1 - Introduction.mp4

01:48

2 - PROJECT-FILES.zip

2 - Excel Interface Tips

3 - Customizing the Ribbon.mp4

02:39

4 - Undo Redo and Repeat.mp4

02:41

5 - Customizing the Quick Access Toolbar.mp4

02:25

6 - Using Keyboard to Access Ribbon.mp4

01:25

7 - Inserting Deleting Hiding Columns and Rows.mp4

02:57

Files.zip

3 - Excel Workbook Tips

9 - Applying Document Themes in a Workbook.mp4

01:29

10 - Saving Excel as a Readonly Webpage File.mp4

01:47

11 - Navigate between Workbooks Quickly.mp4

02:18

12 - Zooming In and Out Quickly.mp4

01:59

13 - 4 Ways To Protect Excel Workbooks Worksheets And Cells.mp4

07:58

Files.zip

4 - Excel Worksheets Tips

15 - Print a 2page Worksheet on 1 page.mp4

01:48

16 - Navigate between Worksheets Quickly.mp4

02:20

17 - Copying and Moving Worksheets in Various Ways.mp4

01:46

18 - Entering Data to Multiple Worksheets at a Time.mp4

02:13

19 - How to Set the Number of Worksheets.mp4

01:27

20 - Learning Different Techniques for Navigating within a Given Worksheet.mp4

02:22

21 - How to Create and Save Custom Views of a Worksheet.mp4

02:54

22 - Hiding Scrollbars in a Worksheet.mp4

01:27

23 - Create a Hyperlink to Other Worksheets.mp4

02:44

24 - How to Prevent Someone from Unhiding a Worksheet Very Hidden Property.mp4

02:53

Files.zip

5 - Excel Formatting Tips

26 - Format Painter Tips.mp4

02:14

27 - Input Messages.mp4

02:31

28 - Format Numbers using Keystroke Shortcuts.mp4

01:34

29 - Modify or Create a Cell Style.mp4

02:51

30 - Copy and paste visible cells only not hidden cells.mp4

03:53

31 - Add Text to a Number.mp4

01:48

32 - Enter a Line Break into One of Your Cells Data.mp4

03:26

33 - Using Wrap Text and Shrink Cell Tools to Have the Size of the Cells.mp4

02:23

34 - Creating a Conditional Format based on a Value.mp4

02:51

35 - Changing Values without Formulas.mp4

02:11

36 - Duplicate Records and How to Get Rid of These.mp4

01:37

37 - Creating Bulleted List.mp4

02:37

38 - Insert a Watermark.mp4

02:08

39 - Creating a Custom List.mp4

03:02

40 - Solving the Problem with Leading Zero.mp4

01:56

41 - Blocking a User from Interacting Outside a Specific Range.mp4

02:10

42 - Hide the Status Bar using VBA.mp4

02:04

43 - Highlight Formula Cells using Conditional Formatting.mp4

02:17

44 - Making Your Comments Stand Out.mp4

02:15

45 - How to Color Rows using Conditional Formatting Alternate Row Shading.mp4

02:36

Files.zip

6 - Excel Productivity Tips

47 - How to Display a Print Preview using Keyboard Shortcuts.mp4

01:16

48 - Set a Specific Print Area.mp4

01:17

49 - Shrink your Pivot Data Pivot Table Grouping Tool.mp4

02:31

50 - The Paste Special Feature.mp4

02:33

51 - Using Fill Handle to Enter Sequences of Values.mp4

02:18

52 - Use FlashFill to Fill Values in a Range Rapidly.mp4

01:50

53 - Select Data using Various Keystroke Shortcuts.mp4

02:14

54 - Entering Data Quickly and Efficiently.mp4

03:04

55 - Filling nonadjacent Cells with the Current Entry.mp4

02:06

56 - Using Pick from Dropdown List and Enter Data Quickly.mp4

01:23

57 - Copying and Moving Data with Various Ways.mp4

01:46

58 - Freeze Titles and Split Screens.mp4

02:34

59 - Create a Data Entry Form.mp4

02:22

60 - Using AutoCorrect to Enter Data Fast.mp4

01:33

61 - Highlighting Blank Cells and Sorting Columns with Them.mp4

02:54

Files.zip

7 - Excel Formulas Tips

7 - Excel Formulas Tips.zip

63 - Converting Formulas to Values Easily.mp4

01:33

64 - The AutoSum Magic.mp4

02:00

65 - Enter the Current Date or Time using NOW Function.mp4

01:21

66 - Displaying All Worksheet Formulas in a Second.mp4

01:27

67 - Meet the new FILTER function.mp4

03:55

68 - Generate Random Decimal Numbers between 0 and 1 with RAND Function.mp4

01:10

69 - Add Comments Inside Formulas using N Function.mp4

01:35

70 - Finding Related Formulas Easy.mp4

01:59

71 - Using TRIM Function to Get Rid of Unwanted Spaces.mp4

02:01

72 - Convert Values between Measurement Systems using CONVERT Function.mp4

01:43

73 - Combine LEFT and FIND Functions.mp4

05:20

74 - Filling Random Values into Cell Selection using RANDBETWEEN Function.mp4

01:46

75 - Identifying and Fixing Error inside of an Excel Formula Error Checking.mp4

02:00

76 - Using the PDURATION Function to Calculate Time.mp4

01:37

77 - Round Values with Various Ways using ROUND Function.mp4

02:42

78 - Using Named Ranges in Formulas.mp4

03:26

79 - Calculate a Persons Age using DATEDIF.mp4

01:52

80 - Locking and Hiding Formula Cells.mp4

02:40

81 - NEW 2024 Convert Birth Date to an Age using Power Query or YEARFRAC Function.mp4

05:04

82 - Use COUNTIF and Data Validation to Prevent Duplications.mp4

02:39

8 - Excel Tables Pivot Tables Tips

84 - Create Table Formatting Data as Table with Table Styles.mp4

02:20

85 - Using the Structure Reference to Create a Formula.mp4

01:56

86 - Create Separate Worksheets from PivotTable using Filters Area.mp4

01:20

Files.zip

9 - Excel Visualization Tips

9 - Excel Visualization Tips.zip

88 - Creating a CHART with Keyboard Shortcuts.mp4

01:41

89 - Make all the Charts Exactly the Same Size.mp4

01:16

90 - How to Move or Resize a Chart using Special Keys.mp4

02:27

91 - Create Mini Charts using Sparklines.mp4

03:10

92 - Linking Chart Titles with Cell Content.mp4

02:25

93 - How to Deal with Missing Data for a Chart.mp4

01:28

10 - Excel Analysis Tips

10 - Excel Analysis Tips.zip

95 - Using STATUS BAR to Get a Quick Summary of your Data Excel Footer.mp4

01:38

96 - Using QUICK ANALYSIS Tool to find Information about Your Data.mp4

01:55

97 - Calculating RUNNING TOTALS.mp4

01:30

98 - Analyze an Active Workbook using the INQUIRE ADDIN.mp4

02:41

99 - AUTO OUTLINE Presenting Information in a More Compact Way using Group Tool.mp4

01:36

100 - WATCH WINDOW TOOL Monitoring the Value in a Worksheet.mp4

01:58

101 - Forecasting Scenarios with SCENARIO MANAGER.mp4

03:22

102 - Getting Data from a PDF FILE.mp4

01:34

103 - Applying GOAL SEEK to Find a Target.mp4

02:14

104 - CONDITIONAL FORMATTING Compare Two Lists of Items and Identify Differences.mp4

02:56

11 - Bonus Section

107 - Excel 2019 Useful keyboard Shortcuts and Tips.mp4

09:32

108 - Excel 2019 Tutorial for Beginners.mp4

13:36

109 - A bit of lighthearted fun watch this 1992 MS Excel advertisement.mp4

04:00

Files.zip

Description

Master Excel with 100+ Excel Tips and Hacks, from an Excel Best Seller Instructor. 2024 UPDATED

What You'll Learn?

Maximize the power of Excel with 100+ ready-to-use tips Hacks on Excel Interface, Workbooks, Worksheets, Formatting Secrets, Organizing Data etc
Increase your Productivity and be more Efficient than you ever imagined
Accomplish and Master all of your Excel Tasks
Save precious minutes from the very first Tips
Fully understand the Excel Hacks using the Custom-Build Templates that I have in every Lecture
Improve your Excel Skills using the latest version of Excel 2016

Who is this for?

Anybody, from a Novice to an Expert can benefit with this collection of powerful Excel Hacks and Tricks

Ideal for Managers, Entrepreneurs and Students

What You Need to Know?

Microsoft Excel Installed On Your Computer (2013 or 2016 is Preferable)

A willingness to learn new Tips and reinvent your work in Excel

More details

Description
COMPLETELY REDONE ON 2024 WITH NEW VIDEOS!

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 course to help Excel users avoid typical 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 course, 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?
First, youâ€™ll learn my top favorite Excel Hacks that can save you a ton of time.
Then Iâ€™ll show you some tips that will help you to customize your Excel Interface.
Youâ€™re gonna learn several new tips to organize your data, work with formulas or Dates, hack your Charts and Pivot tables, complete lightning your tasks in Workbooks and Worksheets, and a bunch of other cool stuff.
Do you want to enter data into multiple worksheets at a time? No problem. Do you also want to block a user from interacting outside a specific range? Piece of cake. Do you want to get rid of duplicate values in seconds? Easy! These and 97 more tips and hacks can add significant productivity and save money across your organization, too.
The course is entirely project-based and requires no Excel experience. It has been recorded with Excel 2016 and Excel 365 in full HD 1080p.
If you get stuck, donâ€™t worry. I have fast and full support through the discussion board.
And if you donâ€™t like the course, simply return it! There is a 30-day money-back guarantee.
But first, you probably want to know who I am. What real-world experience do I have? My name is Andreas and I have been a teacher for over 20 years. I have a computer learning school and have taught Excel to over 3,000 students. I use Excel daily and because of that, I had to find hacks and tips to increase my productivity and efficiency. So I made this collection of powerful tips. At the end of this course, youâ€™ll accomplish and master all of your spreadsheet tasks at least half the time that you do now.
Thanks for your interest in the course, Iâ€™m really excited to share it with you.
Check out the free previews and Iâ€™ll see you in class.
Who this course is for:
Anybody, from a Novice to an Expert can benefit with this collection of powerful Excel Hacks and Tricks
Ideal for Managers, Entrepreneurs and Students

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Andreas Exadaktylos

Instructor's Courses

Hi, I am Andreas and I'm a Best Selling Teacher. I really love learning and teaching whenever I can.I have a Master's Degree in Computer Science and a Degree in Electronic Engineering. I have over 20 years of experience in teaching as an instructor, especially in Microsoft Excel. 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 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 teach Python Programming, Microsoft Excel and all Microsoft software products for over 20 years. I am a professional Forex Trader for over 5 years. I love to create websites and optimize 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, my two kids and my lovely dog. Travel, forex trading, and reading books are my favorite hobbies.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.

language english
Training sessions 98
duration 4:05:50
English subtitles has
Release Date 2024/05/04

Courses related to Excel

Udemy Microsoft Excel - Excel from Beginner to Advanced + Macro

4:26:46

12/21/2023

Udemy Microsoft Excel for MAC Ultimate Training Course 2024

3:50:38

03/02/2025

Excel Formulas & Functions Basic to Advanced

Udemy

Click Learning

Excel Formulas & Functions Basic to Advanced

2:41:28

12/27/2023