| 1. Create a Pivot Chart.mp4 | 31.4 MB | ||
| 1. Create a Pivot Chart.srt | 4.7 KB | ||
| 1. Data entry, Editing and AutoFill.mp4 | 34.7 MB | ||
| 1. Data entry, Editing and AutoFill.srt | 6.2 KB | ||
| 1. Display and highlight formulas.mp4 | 38.3 MB | ||
| 1. Display and highlight formulas.srt | 6.5 KB | ||
| 1. Font styles and effects.mp4 | 75.6 MB | ||
| 1. Font styles and effects.srt | 9.8 KB | ||
| 1. Highlighting cells by applying a rule.mp4 | 54.5 MB | ||
| 1. Highlighting cells by applying a rule.srt | 11.2 KB | ||
| 1. How to Create Charts in Excel.mp4 | 69.1 MB | ||
| 1. How to Create Charts in Excel.srt | 11.9 KB | ||
| 1. Introduction.mp4 | 6.2 MB | ||
| 1. Introduction.srt | 1 KB | ||
| 1. Subtotals and Grand Totals.mp4 | 33.7 MB | ||
| 1. Subtotals and Grand Totals.srt | 5.3 KB | ||
| 1. What is Excel used for.mp4 | 31.4 MB | ||
| 1. What is Excel used for.srt | 5.5 KB | ||
| 1. Working with Simple formulas.mp4 | 58.8 MB | ||
| 1. Working with Simple formulas.srt | 11.1 KB | ||
| 1.1 Data source_Pivot.xlsx | 31.2 KB | ||
| 10. Filtering with search.mp4 | 13.4 MB | ||
| 10. Filtering with search.srt | 2.3 KB | ||
| 10. Use IFS for multiple conditions.mp4 | 87.2 MB | ||
| 10. Use IFS for multiple conditions.srt | 21.8 KB | ||
| 11. COUNTIF, AVERAGEIF, SUMIF.mp4 | 64.7 MB | ||
| 11. COUNTIF, AVERAGEIF, SUMIF.srt | 14 KB | ||
| 11. Filtering using Slicers.mp4 | 36.1 MB | ||
| 11. Filtering using Slicers.srt | 6.8 KB | ||
| 12. Formatting the slicers.mp4 | 28.5 MB | ||
| 12. Formatting the slicers.srt | 5.5 KB | ||
| 13. More on filtering your data.mp4 | 43.7 MB | ||
| 13. More on filtering your data.srt | 8.2 KB | ||
| 14. Clearing and re-applying filters.mp4 | 43.7 MB | ||
| 14. Clearing and re-applying filters.srt | 8.2 KB | ||
| 15. Filtering the PivotTable with a Timeline.mp4 | 28.9 MB | ||
| 15. Filtering the PivotTable with a Timeline.srt | 5 KB | ||
| 16. Changing the style of the PivotTable.mp4 | 39.3 MB | ||
| 16. Changing the style of the PivotTable.srt | 6.3 KB | ||
| 17. Changing the Layout of the PivotTable.mp4 | 38.4 MB | ||
| 17. Changing the Layout of the PivotTable.srt | 6.8 KB | ||
| 18. Formatting the numbers in the PivotTable.mp4 | 32.7 MB | ||
| 18. Formatting the numbers in the PivotTable.srt | 5.3 KB | ||
| 2. Auditing tools.mp4 | 76.9 MB | ||
| 2. Auditing tools.srt | 13.6 KB | ||
| 2. Borders and color background.mp4 | 51.2 MB | ||
| 2. Borders and color background.srt | 7.6 KB | ||
| 2. Chart Types.mp4 | 113.8 MB | ||
| 2. Chart Types.srt | 17.6 KB | ||
| 2. Create your first PivotTable.mp4 | 109.1 MB | ||
| 2. Create your first PivotTable.srt | 15.3 KB | ||
| 2. Entering Dates and Time.mp4 | 33.9 MB | ||
| 2. Entering Dates and Time.srt | 7.7 KB | ||
| 2. Excel Toolbars and shortcut menues.mp4 | 41 MB | ||
| 2. Excel Toolbars and shortcut menues.srt | 8.3 KB | ||
| 2. Highlight the top values in a PivotTable.mp4 | 43.3 MB | ||
| 2. Highlight the top values in a PivotTable.srt | 7.1 KB | ||
| 2. Operations of the Data field summary.mp4 | 30.2 MB | ||
| 2. Operations of the Data field summary.srt | 4.8 KB | ||
| 2. Pivot a PivotChart.mp4 | 41.9 MB | ||
| 2. Pivot a PivotChart.srt | 7.1 KB | ||
| 2. Using the SUM() function.mp4 | 46.3 MB | ||
| 2. Using the SUM() function.srt | 8 KB | ||
| 3. Adding more than one data field.mp4 | 24.9 MB | ||
| 3. Adding more than one data field.srt | 4.2 KB | ||
| 3. Adjusting row height and column width.mp4 | 42.3 MB | ||
| 3. Adjusting row height and column width.srt | 9.2 KB | ||
| 3. Configure your PivotTable.mp4 | 51.1 MB | ||
| 3. Configure your PivotTable.srt | 9.5 KB | ||
| 3. Exploring Excel Ideas.mp4 | 33.6 MB | ||
| 3. Exploring Excel Ideas.srt | 4.8 KB | ||
| 3. Filter a PivotChart.mp4 | 27.2 MB | ||
| 3. Filter a PivotChart.srt | 5.4 KB | ||
| 3. Formatting cells using data bars.mp4 | 36.5 MB | ||
| 3. Formatting cells using data bars.srt | 8.2 KB | ||
| 3. Use entire rowcolumn reference.mp4 | 57.3 MB | ||
| 3. Use entire rowcolumn reference.srt | 12.1 KB | ||
| 3. Using MIN() and MAX() Functions.mp4 | 24 MB | ||
| 3. Using MIN() and MAX() Functions.srt | 3.6 KB | ||
| 3. Workbooks and Worksheets.mp4 | 29.7 MB | ||
| 3. Workbooks and Worksheets.srt | 6.7 KB | ||
| 4. Change formulas to values and update values with formulas.mp4 | 80.1 MB | ||
| 4. Change formulas to values and update values with formulas.srt | 14.9 KB | ||
| 4. Create a PivotTable from external data source.mp4 | 14.7 MB | ||
| 4. Create a PivotTable from external data source.srt | 2.9 KB | ||
| 4. Format a PivotChart.mp4 | 23.5 MB | ||
| 4. Format a PivotChart.srt | 4.1 KB | ||
| 4. Formatting cells using colour scale.mp4 | 42.2 MB | ||
| 4. Formatting cells using colour scale.srt | 10.5 KB | ||
| 4. How to look for Help on Excel - Using Excel Help.mp4 | 21.7 MB | ||
| 4. How to look for Help on Excel - Using Excel Help.srt | 4.3 KB | ||
| 4. Insert, Hide, Delete a column or a row.mp4 | 57.9 MB | ||
| 4. Insert, Hide, Delete a column or a row.srt | 8 KB | ||
| 4. Managing Dates in PivotTables.mp4 | 29.8 MB | ||
| 4. Managing Dates in PivotTables.srt | 4.5 KB | ||
| 4. Using the AVERAGE() function.mp4 | 40.4 MB | ||
| 4. Using the AVERAGE() function.srt | 5.9 KB | ||
| 5. Change a PivotChart typelayout.mp4 | 22.2 MB | ||
| 5. Change a PivotChart typelayout.srt | 4.5 KB | ||
| 5. Creating Calculated Fields.mp4 | 29.4 MB | ||
| 5. Creating Calculated Fields.srt | 5.3 KB | ||
| 5. Debugging formulas with the F9 key.mp4 | 28.2 MB | ||
| 5. Debugging formulas with the F9 key.srt | 6.5 KB | ||
| 5. Formatting cells using icon sets.mp4 | 43.9 MB | ||
| 5. Formatting cells using icon sets.srt | 9.1 KB | ||
| 5. Manage PivotTables.mp4 | 46.2 MB | ||
| 5. Manage PivotTables.srt | 7.4 KB | ||
| 5. Move, Copy and Insert Data.mp4 | 66.4 MB | ||
| 5. Move, Copy and Insert Data.srt | 10.2 KB | ||
| 6. Add a trendline to a PivotChart.mp4 | 23.2 MB | ||
| 6. Add a trendline to a PivotChart.srt | 4.8 KB | ||
| 6. Drilling down the data.mp4 | 43.6 MB | ||
| 6. Drilling down the data.srt | 5.6 KB | ||
| 6. Edit a conditional formatting rule.mp4 | 20.2 MB | ||
| 6. Edit a conditional formatting rule.srt | 3.9 KB | ||
| 6. Find and Replace.mp4 | 60.5 MB | ||
| 6. Find and Replace.srt | 8.9 KB | ||
| 6. Improve readability with cells and range names.mp4 | 36.9 MB | ||
| 6. Improve readability with cells and range names.srt | 6.8 KB | ||
| 7. IF logical test and the use of relational operators.mp4 | 60.5 MB | ||
| 7. IF logical test and the use of relational operators.srt | 13.6 KB | ||
| 7. Multiple formatting.mp4 | 51.9 MB | ||
| 7. Multiple formatting.srt | 11.1 KB | ||
| 7. Sorting the data.mp4 | 16.9 MB | ||
| 7. Sorting the data.srt | 3.4 KB | ||
| 8. Filtering the data.mp4 | 20.9 MB | ||
| 8. Filtering the data.srt | 3.8 KB | ||
| 8. Nested IF statement.mp4 | 45.5 MB | ||
| 8. Nested IF statement.srt | 12.8 KB | ||
| 9. Compound logical tests with AND, OR.mp4 | 64.7 MB | ||
| 9. Compound logical tests with AND, OR.srt | 16.4 KB | ||
| 9. Filter by rules.mp4 | 30.3 MB | ||
| 9. Filter by rules.srt | 4.7 KB | ||
| Bonus Resources.txt | 409.6 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ▲ 136 total files | |||
Microsoft Excel _ MS Excel Basics & Excel PivotTables (2022)
https://DevCourseWeb.com
Last updated 12/2022
Duration: 7h 2m | Video: .MP4, 1280x720 30 fps | Audio: AAC, 48 kHz, 2ch | Size: 2.76 GB
Genre: eLearning | Language: English[Auto]
Become the master of Excel Pivot Tables | MS Excel | 2022 course
What you'll learn
Learn about PivotTable and use it for analysis
Learn Excel by doing using practical examples
Learn how to perform basic calculations
Be familiar with the most powerful tools and techniques
Requirements
Basic understanding of Formulas using Excel will be helpful, but not a must
Description
Hello!
This part of My Microsoft Excel series of courses focuses on the PivotTable part. PivotTables are very powerful tools inside MS Excel allows us to analyse huge datasets in a very efficient and short time.
This course will help the learners to improve their skills and be familiar with Microsoft Excel. Now a days, Microsoft Excel is one of the most important and used program world wide.
What makes me qualified to teach you?
My name is Mozn and I've been a professional instructor for over a decade. Plus I'm the founder of Mezan Institute and the Author of a published book. I break down complex topics into an easy understandable messages, and help learners to absorbe the study material in an easy and engaging way. My courses are continuously receiving 5-star reviews like these from Microsoft Excel from Zero to Hero, 2020
***** I realise after this quick and easy course that I new few parts of the excel but I am realy greathfull that Iadd few more when soon as I finsh this course. - Diana
***** Simple quick into to excel. Please add some more lectures similar to this :). - Geraldine
***** Yes, a good match, I do this every day, however, manually, but now I understand formulas much better, and it is less time consuming. - Dianne
What is this Excel course about?
In this guide to Microsoft Excel course, you'll not only learn all of the principles of Microsoft Excel, but also how to understand and become a star in your field.
This course will cover Beginners, Intermediate and Advanced levels of Excel, including
The basics of MS Excel
The powerful tool of PivotTables
Creating and Managing PivotTables
Learn from someone who is currently working in the industry, who knows the most current teaching techniques.
By the end of this course, your confidence as Data analyst using Excel will soar. You'll have a thorough understanding of how to use Excel in a business or personal environment.
Go ahead and click the enroll button, and I'll see you in lesson 1!
I wish you an enjoyable journey with us.
Shukran! Mozn
Who this course is for
Anyone interested in learning Microsoft Excel
Anyone need to save time and create automatic and dynamic reports
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 2 GB | freecoursewb | 19 hours | 0 | 0 | |
| 2.2 GB | freecoursewb | 1 week | 25 | 9 | |
|
Udemy - Microsoft Power BI for Excel Users - Turn Data into Insights Posted by
freecoursewb in Other
|
2.6 GB | freecoursewb | 1 week | 1 | 11 |
| 999.5 MB | freecoursewb | 1 week | 0 | 0 | |
|
Udemy - Microsoft Excel - The Smart Path to Advanced Nested Functions Posted by
freecoursewb in Other
|
1.9 GB | freecoursewb | 1 week | 2 | 56 |
All Comments