.MP4, AVC, 1280x720, 30 fps | English, AAC, 2 Ch | 4h 7m | 828 MB
Instructor: Chris Dutton
While the power and time-saving value of PivotTables appeals to anyone who analyzes data in Excel, many users are too intimidated by the feature to add it to their workflow. In this course—the first installment in a two-part series—instructor Chris Dutton breaks down how to use PivotTables, as well as how to add PivotCharts to the mix to summarize your data visually.
Throughout the course, Chris shares practical tips and demonstrations that help you grasp how these tools are used in the real world, as well as how PivotTable values are actually calculated and displayed. Learn how to prepare your raw data for analysis; leverage formatting, sorting, filtering, and grouping options; display values in multiple ways; create PivotCharts; and much more.
.MP4, AVC, 1280x720, 30 fps | English, AAC, 2 Ch | 2h 22m | 605 MB
Instructor: Chris Dutton
Once you grasp the basics of Excel PivotTables, you're ready to see how this powerful data analysis tool can add value in real-world situations. In this course— the final installment in a two-part series—instructor Chris Dutton dives into ten real-world case studies that showcase how PivotTables can be leveraged to explore and analyze data in a variety of situations.
While the previous installment in this series dove into theory and the general ins and outs of PivotTables, this course helps expand your knowledge by looking at practical applications of the tool. Chris covers case studies on San Diego burrito ratings, historical shark attack records, major league baseball statistics, stock market data, and more.
.MP4, AVC, 1280x720, 30 fps | English, AAC, 2 Ch | 3h 50m | 725 MB
Instructor: Curt Frye
Many Excel users aren’t sure how to use PivotTables. In this course, Excel power user Curt Frye shows you how to navigate the complexity of PivotTables while taking advantage of their power. Curt explains how to build PivotTables from single or multiple data sources, pivot and configure a PivotTable, define a default PivotTable layout, and more. He demonstrates ways to summarize your data, add calculated fields, filter your results, and format your layout to make it more readable.
Curt steps you through how to sort and filter PivotTable data, format your PivotTable and, and apply conditional formats. Plus, he goes over how to create PivotCharts to visualize your data, enhance PivotTables with macros, and use the Data Model feature to build PivotTables from related tables.
.MP4, AVC, 1280x720, 30 fps | English, AAC, 2 Ch | 1h 8m | 217 MB
Instructor: Dennis Taylor
Microsoft Excel offers a variety of powerful lookup functions that allow you to easily retrieve information across spreadsheets. In this course, Excel expert Dennis Taylor demystifies some of the most significant lookup functions. Tune in to learn how to use the new XLOOKUP function, which can handle all the capabilities of the widely used VLOOKUP and HLOOKUP functions, in addition to providing more power and flexibility.
Explore uses of the MATCH function and the newer, more robust XMATCH function to match up data, and learn how to extract data using the INDEX function. Discover how to restructure the lists being searched to ensure that you're using each function efficiently, and learn about dynamic array lookup functions like UNIQUE, SORT, SORTBY, and FILTER. Along the way, Dennis shares practical examples that help you grasp how to implement these functions in your workflow.
Last updated 3/2023
Created by ajay parmar
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 31 Lectures ( 22h 12m ) | Size: 11.5 GB
https://www.udemy.com/course/excel-mis-analytics-training-series3/
Advance Filter, Conditional formatting. INDIRECT ,Data Validation , CountIFs,SumIfs,Offset,Charts,Form Controls,Arrays
Published 11/2023
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.84 GB | Duration: 2h 10m
Learn Advanced Excel Formulas and Excel Shortcuts to enhance productivity
.MP4, AVC, 1280x720, 30 fps | English, AAC, 2 Ch | 2h 12m | 373 MB
Instructor: Garrick Chow
This comprehensive course covers the most important things you need to know to create, edit, format, and share PDFs in Adobe Acrobat Pro. Instructor Garrick Chow explains the Portable Document Format (PDF) and compares features in Acrobat Pro with features in Acrobat Standard and Acrobat Reader.
He shows you how to create PDFs using source material from Microsoft Office, images, and scans. Garrick covers how to edit and combine PDFs. He demonstrates how to create fillable forms, gather comments, and review PDFs. Garrick also goes over how to protect PDFs by restricting printing and preventing changes.
.MP4, AVC, 1280x720, 30 fps | English, AAC, 2 Ch | 9h 36m | 8.67 GB
Instructor: Paula Guilfoyle CPA
Learn to create stunning visually effective dashboards that aid quick business decisions, track KPIs and reveal insights
https://www.udemy.com/course/microsoft-publisher-365-beginner/
Published 11/2023
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.60 GB | Duration: 2h 53m
Master the essentials of Publisher 365 and elevate your publishing skills while creating stunning documents with ease.
Language: English (US)
Pick up VBA like a pro, build macros, and become a proficient Excel VBA Programmer in no time!
https://www.udemy.com/course/the-ultimate-excel-vba-course-for-beginners-learn-master-vba-fast/
Language: English (US)
Build Excel worksheet for adjusting adjusting & tax entries, reconciling net income calculated on a book and tax basis
https://www.udemy.com/course/tax-adjusting-entry-year-end-accounting-excel-worksheet/
Language: English (US)
Quantity Surveying, Quantity Takeoff, Estimation, Rate Analysis, Blubeam Revu, Planswift, Costing, Construction Drawings
https://www.udemy.com/course/quantity-surveying-with-rate-analysis-and-take-off-beginners/
Language: English (US)
Optimizing Artificial Intelligence: Practical Strategies to Turn Technology into Profit
https://www.udemy.com/course/monetizing-ai-leveraging-chat-gpt-midjourney-for-success/
Language: Français (France)
Optimisation de l'Intelligence Artificielle : Stratégies Pratiques pour Transformer la Technologie en Profit
https://www.udemy.com/course/monetisation-de-lia-chat-gpt-midjourney-pour-le-succes/
Language:
Basic to Advance Level Microsoft PowerPoint Training Course | A Complete Guide to MS PowerPoint
https://www.udemy.com/course/microsoft-powerpoint-course-zero-to-hero-in-ms-powerpoint/
Language:
Learn the Beginner to Expert Level Microsoft Publisher Training Course | A Complete Guide to Microsoft Publisher
https://www.udemy.com/course/learn-microsoft-publisher-complete-microsoft-publisher/