FreeCourseSite com Udemy - Excel Essentials for the Real World Complete Excel Course

1. 01 - Before You Dive In/001 How to Get the Most Out of This Course.mp457.41MB
2. 01 - Before You Dive In/002 Download Course Files.mp43.53MB
3. 02 - Quick Tour of Excel/001 Excel Workbook, Worksheet, Cell Structure.mp455.44MB
4. 02 - Quick Tour of Excel/002 Quick Tour of Excel - Ribbon & Quick Access Toolbar.mp422.15MB
5. 02 - Quick Tour of Excel/003 Customizing the Excel Interface.mp429.59MB
6. 03 - Data Input & Hidden Features to Save Time/001 Overview - Data Input & Hidden Excel Features.mp48.07MB
7. 03 - Data Input & Hidden Features to Save Time/002 Data Entry and Editing Excel Data.mp424.37MB
8. 03 - Data Input & Hidden Features to Save Time/003 Basic Excel Formulas.mp426.19MB
9. 03 - Data Input & Hidden Features to Save Time/004 Text to Speech (Hidden Excel Feature).mp411.77MB
10. 03 - Data Input & Hidden Features to Save Time/005 Correctly Input Dates and Time Stamps in Excel.mp418.61MB
11. 03 - Data Input & Hidden Features to Save Time/006 Use Excel AutoFill To Do Your Work.mp410.34MB
12. 03 - Data Input & Hidden Features to Save Time/007 Excel Flash Fill for Major Time Saving (Become Pro).mp441.68MB
13. 03 - Data Input & Hidden Features to Save Time/008 Custom Lists With AutoFill (Hidden Excel Feature).mp412.07MB
14. 03 - Data Input & Hidden Features to Save Time/009 Inputting & Editing Comments & Notes in Excel.mp440.43MB
15. 03 - Data Input & Hidden Features to Save Time/010 Finding Excel Formulas & Input Cells with ONE Click (Become Pro).mp428.23MB
16. 03 - Data Input & Hidden Features to Save Time/011 Excel Data Validation to Reduce Time Checking Data.mp472.92MB
17. 03 - Data Input & Hidden Features to Save Time/012 Adding Tool Tips (Screen Tips in Excel).mp45.65MB
18. 03 - Data Input & Hidden Features to Save Time/013 Learn to Work with Pictures, Shapes & Other Objects in Excel.mp424.24MB
19. 03 - Data Input & Hidden Features to Save Time/015 Solution Data Manipulation & Preparation in Excel.mp469.56MB
20. 04 - Worksheet Navigation, Copying and Protecting/001 Overview - Worksheet Navigation in Excel.mp44.58MB
21. 04 - Worksheet Navigation, Copying and Protecting/002 Useful Excel Shortcuts for Navigation (Become Pro).mp441.74MB
22. 04 - Worksheet Navigation, Copying and Protecting/003 Copying, Moving & Hiding Worksheets.mp421.31MB
23. 04 - Worksheet Navigation, Copying and Protecting/004 Freeze Panes (Lock Rows, Columns) & Split Screen for Long Excel Reports.mp437.96MB
24. 04 - Worksheet Navigation, Copying and Protecting/005 Hide & Unhide, Insert, Adjust Columns & Rows in Excel.mp461.23MB
25. 04 - Worksheet Navigation, Copying and Protecting/006 Copying and Pasting Data (Hidden Excel Paste Features).mp439.26MB
26. 04 - Worksheet Navigation, Copying and Protecting/007 Protecting Excel Worksheets & Specific Ranges.mp475.22MB
27. 04 - Worksheet Navigation, Copying and Protecting/009 Solution Update & Protect Excel Report.mp439.51MB
28. 05 - Excel Formulas & What to be Aware of/001 Overview - Excel Formulas & What to be Aware of.mp410.96MB
29. 05 - Excel Formulas & What to be Aware of/002 How Excel Calculates - Order of Precedence.mp410.38MB
30. 05 - Excel Formulas & What to be Aware of/003 Simple but Useful Excel Formulas.mp452.44MB
31. 05 - Excel Formulas & What to be Aware of/004 Essential Excel Rule (Don't Skip!).mp48.22MB
32. 05 - Excel Formulas & What to be Aware of/005 Absolute and Relative Cell Referencing in Excel.mp421.2MB
33. 05 - Excel Formulas & What to be Aware of/006 Improve Clarity with Range Names.mp428.11MB
34. 05 - Excel Formulas & What to be Aware of/007 Referencing other Workbooks or Worksheets.mp426.69MB
35. 05 - Excel Formulas & What to be Aware of/008 Circular References & How to Locate Them.mp48.94MB
36. 05 - Excel Formulas & What to be Aware of/009 Combine Values From Two or More Cells to ONE Cell.mp419.16MB
37. 05 - Excel Formulas & What to be Aware of/011 Solution Allocate Yearly Value Based on Percentages.mp426.78MB
38. 06 - Important Excel Functions (Everything you need to become Pro)/001 Overview & Finding Excel Functions from Insert Function.mp422.19MB
39. 06 - Important Excel Functions (Everything you need to become Pro)/003 COUNT, COUNTA, COUNTBLANK.mp415.19MB
40. 06 - Important Excel Functions (Everything you need to become Pro)/004 COUNT based on a Condition (COUNTIFS).mp4100.71MB
41. 06 - Important Excel Functions (Everything you need to become Pro)/005 SUM & AVERAGE Functions in Excel.mp422.54MB
42. 06 - Important Excel Functions (Everything you need to become Pro)/006 SUM by Criteria (SUMIFS, AVERAGEIFS).mp456.28MB
43. 06 - Important Excel Functions (Everything you need to become Pro)/007 MAX & MIN (MAXIFS & MINIFS).mp438.73MB
44. 06 - Important Excel Functions (Everything you need to become Pro)/008 Rounding Values (ROUND, ROUNDUP & ROUNDOWN).mp421.72MB
45. 06 - Important Excel Functions (Everything you need to become Pro)/009 Essential Excel Date Functions.mp442.36MB
46. 06 - Important Excel Functions (Everything you need to become Pro)/010 Time Calculations in Excel - Total Time Worked.mp436.18MB
47. 06 - Important Excel Functions (Everything you need to become Pro)/011 Handling Excel Formula Errors.mp415.22MB
48. 06 - Important Excel Functions (Everything you need to become Pro)/012 IF (Then, Else) Excel Function - Conditional Formulas.mp452.42MB
49. 06 - Important Excel Functions (Everything you need to become Pro)/013 VLOOKUP Function - Lookup Values from Another Place.mp458.82MB
50. 06 - Important Excel Functions (Everything you need to become Pro)/015 Solution How Good Are you with Excel Functions.mp469.61MB
51. 07 - Data Cleaning and Management Sorting, Filtering & Replacing Data/001 Overview - Data Cleaning, Analysis & Management Tools in Excel.mp437.21MB
52. 07 - Data Cleaning and Management Sorting, Filtering & Replacing Data/002 Sort Data (Organize & Create Order) in Excel.mp459.85MB
53. 07 - Data Cleaning and Management Sorting, Filtering & Replacing Data/003 Unsort Data to Revert to Original Order.mp47.86MB
54. 07 - Data Cleaning and Management Sorting, Filtering & Replacing Data/004 Add Subtotals to Sorted Data.mp460.68MB
55. 07 - Data Cleaning and Management Sorting, Filtering & Replacing Data/005 Filter Data to Extract What you Need.mp451.01MB
56. 07 - Data Cleaning and Management Sorting, Filtering & Replacing Data/006 Delete Blank or Empty Rows in Excel.mp427.79MB
57. 07 - Data Cleaning and Management Sorting, Filtering & Replacing Data/007 Fill Empty Cells in One Go (Become Pro).mp438.79MB
58. 07 - Data Cleaning and Management Sorting, Filtering & Replacing Data/008 Remove Duplicates to Get a Unique List in Excel.mp420.66MB
59. 07 - Data Cleaning and Management Sorting, Filtering & Replacing Data/009 Excel Find Feature, Select & Emphasize.mp485.52MB
60. 07 - Data Cleaning and Management Sorting, Filtering & Replacing Data/010 Find and Replace Values & Formatting (Hidden Excel Feature).mp451.97MB
61. 07 - Data Cleaning and Management Sorting, Filtering & Replacing Data/011 Why Excel Tables Can be a Time Saver (Become Pro).mp4103.39MB
62. 07 - Data Cleaning and Management Sorting, Filtering & Replacing Data/013 Solution Data Management Challenge in Excel.mp435MB
63. 07 - Data Cleaning and Management Sorting, Filtering & Replacing Data/015 Special Message - You've Got This!.mp49.95MB
64. 08 - Formatting including Conditional & Number Formatting in Excel/001 Overview - All About Formatting.mp428.2MB
65. 08 - Formatting including Conditional & Number Formatting in Excel/002 Excel Formatting Tips - Alignment, Borders & More.mp423.51MB
66. 08 - Formatting including Conditional & Number Formatting in Excel/003 Better Than Merge (Become Pro).mp412.73MB
67. 08 - Formatting including Conditional & Number Formatting in Excel/004 Justify Text Length (Hidden Excel Feature).mp413.54MB
68. 08 - Formatting including Conditional & Number Formatting in Excel/005 Excel Number Formatting Options (& Special Formatting).mp427.42MB
69. 08 - Formatting including Conditional & Number Formatting in Excel/006 Excel Conditional Formatting (Top Bottom Analysis & More).mp464.2MB
70. 08 - Formatting including Conditional & Number Formatting in Excel/007 Icons & Data Bars with Conditional Formatting in Excel.mp448.77MB
71. 08 - Formatting including Conditional & Number Formatting in Excel/009 Solution Format Excel Report Challenge.mp420.15MB
72. 09 - Printing Excel Files & Saving as PDF/001 Checklist Before Printing.mp410.28MB
73. 09 - Printing Excel Files & Saving as PDF/002 Useful Printing Options in Excel.mp424.2MB
74. 09 - Printing Excel Files & Saving as PDF/003 Adding Page Breaks & Printing Parts of a Sheet.mp422.91MB
75. 09 - Printing Excel Files & Saving as PDF/004 Printing Large Datasets (Make sure you include this!).mp440.17MB
76. 09 - Printing Excel Files & Saving as PDF/005 Header & Footer in Excel (Logo, Page Numbers, etc.).mp436.71MB
77. 09 - Printing Excel Files & Saving as PDF/006 Saving Excel Files PDF & Printing Many Sheets.mp420.34MB
78. 09 - Printing Excel Files & Saving as PDF/008 Solution Prepare Excel Report for Printing.mp424.31MB
79. 10 - Workbook Design Principles/001 Good Spreadsheet Design Principles (with Examples).mp494.68MB
80. 10 - Workbook Design Principles/002 Adding Hyperlinks (Plus a Smart Workaround) in Excel.mp434.44MB
81. 10 - Workbook Design Principles/003 Define Cell Styles & Set Defaults (e.g. for Excel Tables).mp422.53MB
82. 10 - Workbook Design Principles/004 Excel Workbook Theme & Color to Save Time.mp419.31MB
83. 10 - Workbook Design Principles/005 Use Your Own Excel Templates.mp417.47MB
84. 11 - Working With Excel Charts/001 Overview - Create Helpful Excel Charts.mp46.38MB
85. 11 - Working With Excel Charts/002 Excel Chart Basics for a Quick Start.mp497.26MB
86. 11 - Working With Excel Charts/003 Adding More Series to a Chart (Comparison Charts - Method 1).mp428.89MB
87. 11 - Working With Excel Charts/004 Comparison Excel Charts - Actual & Variance (Method 2).mp428.56MB
88. 11 - Working With Excel Charts/005 Combination Charts (Plus a Hidden Excel Feature).mp428.08MB
89. 11 - Working With Excel Charts/006 Dynamic Chart Ranges with Excel Tables.mp47.02MB
90. 11 - Working With Excel Charts/007 Pareto & Histogram Excel Charts.mp429.98MB
91. 11 - Working With Excel Charts/008 Treemap Chart in Excel.mp438.74MB
92. 11 - Working With Excel Charts/009 Sunburst, Pie & Doughnut Excel Charts.mp434.6MB
93. 11 - Working With Excel Charts/010 Sparklines - Mini Excel Charts Inside Cells.mp431.84MB
94. 11 - Working With Excel Charts/012 Solution Treemap for Management Report.mp491.76MB
95. 12 - Quick Insights with Excel Pivot Tables/001 Benefits of Excel Pivot Tables & Starting Checklist.mp44.22MB
96. 12 - Quick Insights with Excel Pivot Tables/002 Inserting a Pivot Table in Excel.mp4115.9MB
97. 12 - Quick Insights with Excel Pivot Tables/003 Why You Should Use Tables as Pivot Source (Become Pro).mp436.54MB
98. 12 - Quick Insights with Excel Pivot Tables/004 Sorting Pivot Data & Analyzing Multiple Items.mp468.23MB
99. 12 - Quick Insights with Excel Pivot Tables/005 Adding Calculations & Multiple Reports with Pivot Tables.mp456.08MB
100. 12 - Quick Insights with Excel Pivot Tables/006 Using Slicers & Timeline (Working with Dates) in Excel.mp447.46MB
101. 12 - Quick Insights with Excel Pivot Tables/007 Creating Pivot Charts.mp443.07MB
102. 12 - Quick Insights with Excel Pivot Tables/008 Pivot Tables or Formulas When to Use What.mp46.24MB
103. 12 - Quick Insights with Excel Pivot Tables/010 Solution Excel Data Analysis with Pivot Tables.mp446.21MB
104. 13 - Introduction to Power Query in Excel/001 Power Query, Power Pivot & Power BI - When to use which.mp461.74MB
105. 13 - Introduction to Power Query in Excel/003 Import Text File with Power Query.mp4113.91MB
106. 13 - Introduction to Power Query in Excel/004 Merge data in Power Query (for Pivot Table).mp430.13MB
107. 13 - Introduction to Power Query in Excel/005 Clean up Messy Excel Data (multiple headers, unpivot etc.).mp4132.74MB
108. 13 - Introduction to Power Query in Excel/007 Solution Data Cleanup with Power Query.mp456.42MB
109. 14 - NEW 365 Excel Functions FILTER, SORT, UNIQUE, XLOOKUP & More/001 Excel Dynamic Arrays & New Functions in Microsoft 365.mp449.9MB
110. 14 - NEW 365 Excel Functions FILTER, SORT, UNIQUE, XLOOKUP & More/003 Excel's New Calculation Engine Spill Error and @(at) sign.mp463.64MB
111. 14 - NEW 365 Excel Functions FILTER, SORT, UNIQUE, XLOOKUP & More/004 Excel UNIQUE Function Get List of Distinct Values.mp467.5MB
112. 14 - NEW 365 Excel Functions FILTER, SORT, UNIQUE, XLOOKUP & More/005 Excel SORT & SORTBY Functions.mp4100.66MB
113. 14 - NEW 365 Excel Functions FILTER, SORT, UNIQUE, XLOOKUP & More/006 Excel FILTER Function Return Multiple Match Results.mp480.48MB
114. 14 - NEW 365 Excel Functions FILTER, SORT, UNIQUE, XLOOKUP & More/007 Excel XLOOKUP Function The New Power Lookup Function.mp452.89MB
115. 14 - NEW 365 Excel Functions FILTER, SORT, UNIQUE, XLOOKUP & More/009 Solution Get Total Salary by Division.mp441.42MB
116. 15 - Next Steps/001 Your Next Steps & More Learning.mp430.65MB