Excel Tips & Shortcuts: 100+ Powerful Hacks for Beginners

سرفصل های دوره

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

1 - Introduction to the Course

1 - Introduction

2 - PROJECT-FILES.zip

2 - Excel Interface Tips

3 - Customizing the Ribbon

4 - Undo Redo and Repeat

5 - Customizing the Quick Access Toolbar

6 - Using Keyboard to Access Ribbon

7 - Inserting Deleting Hiding Columns and Rows

Files.zip

3 - Excel Workbook Tips

9 - Applying Document Themes in a Workbook

10 - Saving Excel as a Readonly Webpage File

11 - Navigate between Workbooks Quickly

12 - Zooming In and Out Quickly

13 - 4 Ways To Protect Excel Workbooks Worksheets And Cells

Files.zip

4 - Excel Worksheets Tips

15 - Print a 2page Worksheet on 1 page

16 - Navigate between Worksheets Quickly

17 - Copying and Moving Worksheets in Various Ways

18 - Entering Data to Multiple Worksheets at a Time

19 - How to Set the Number of Worksheets

20 - Learning Different Techniques for Navigating within a Given Worksheet

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

22 - Hiding Scrollbars in a Worksheet

23 - Create a Hyperlink to Other Worksheets

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

Files.zip

5 - Excel Formatting Tips

26 - Format Painter Tips

27 - Input Messages

28 - Format Numbers using Keystroke Shortcuts

29 - Modify or Create a Cell Style

30 - Copy and paste visible cells only not hidden cells

31 - Add Text to a Number

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

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

34 - Creating a Conditional Format based on a Value

35 - Changing Values without Formulas

36 - Duplicate Records and How to Get Rid of These

37 - Creating Bulleted List

38 - Insert a Watermark

39 - Creating a Custom List

40 - Solving the Problem with Leading Zero

41 - Blocking a User from Interacting Outside a Specific Range

42 - Hide the Status Bar using VBA

43 - Highlight Formula Cells using Conditional Formatting

44 - Making Your Comments Stand Out

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

Files.zip

6 - Excel Productivity Tips

47 - How to Display a Print Preview using Keyboard Shortcuts

48 - Set a Specific Print Area

49 - Shrink your Pivot Data Pivot Table Grouping Tool

50 - The Paste Special Feature

51 - Using Fill Handle to Enter Sequences of Values

52 - Use FlashFill to Fill Values in a Range Rapidly

53 - Select Data using Various Keystroke Shortcuts

54 - Entering Data Quickly and Efficiently

55 - Filling nonadjacent Cells with the Current Entry

56 - Using Pick from Dropdown List and Enter Data Quickly

57 - Copying and Moving Data with Various Ways

58 - Freeze Titles and Split Screens

59 - Create a Data Entry Form

60 - Using AutoCorrect to Enter Data Fast

61 - Highlighting Blank Cells and Sorting Columns with Them

Files.zip

7 - Excel Formulas Tips

7 - Excel Formulas Tips.zip

63 - Converting Formulas to Values Easily

64 - The AutoSum Magic

65 - Enter the Current Date or Time using NOW Function

66 - Displaying All Worksheet Formulas in a Second

67 - Meet the new FILTER function

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

69 - Add Comments Inside Formulas using N Function

70 - Finding Related Formulas Easy

71 - Using TRIM Function to Get Rid of Unwanted Spaces

72 - Convert Values between Measurement Systems using CONVERT Function

73 - Combine LEFT and FIND Functions

74 - Filling Random Values into Cell Selection using RANDBETWEEN Function

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

76 - Using the PDURATION Function to Calculate Time

77 - Round Values with Various Ways using ROUND Function

78 - Using Named Ranges in Formulas

79 - Calculate a Persons Age using DATEDIF

80 - Locking and Hiding Formula Cells

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

82 - Use COUNTIF and Data Validation to Prevent Duplications

8 - Excel Tables Pivot Tables Tips

84 - Create Table Formatting Data as Table with Table Styles

85 - Using the Structure Reference to Create a Formula

86 - Create Separate Worksheets from PivotTable using Filters Area

Files.zip

9 - Excel Visualization Tips

9 - Excel Visualization Tips.zip

88 - Creating a CHART with Keyboard Shortcuts

89 - Make all the Charts Exactly the Same Size

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

91 - Create Mini Charts using Sparklines

92 - Linking Chart Titles with Cell Content

93 - How to Deal with Missing Data for a Chart

10 - Excel Analysis Tips

10 - Excel Analysis Tips.zip

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

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

97 - Calculating RUNNING TOTALS

98 - Analyze an Active Workbook using the INQUIRE ADDIN

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

100 - WATCH WINDOW TOOL Monitoring the Value in a Worksheet

101 - Forecasting Scenarios with SCENARIO MANAGER

102 - Getting Data from a PDF FILE

103 - Applying GOAL SEEK to Find a Target

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

11 - Bonus Section

107 - Excel 2019 Useful keyboard Shortcuts and Tips

108 - Excel 2019 Tutorial for Beginners

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

Files.zip

45,900 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy