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

189,000 تومان

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

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

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

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