Company: Pluralsight Author: ByBill Kulterman Full Title: Excel 2019 Pro Year: 2019 Language: English Genre: Educational: Spreadsheets Skill Level: Advanced Price: - - Files: MP4 Time: 05:20:36 Video: AVC, 1280 x 720 (1.778) at 15.000 fps, 900 kbps Audio: AAC at 96 Kbps, 2 channels, 48.0 KHz In this course, you’ll learn the most advanced aspects of working with Excel 2019. Explore how to perform all sorts of useful functions, pivot tables, macros, form controls, and much more in this massive deep dive into the world of Excel 2019. Learn the most advanced aspects of Excel 2019. In this course, Excel 2019 Pro, you'll take your knowledge to the ultimate level. First, you'll learn how to format and work with data. Then, you’ll learn about queries, text/logical/statistical and other functions. Finally, you’ll learn conditional formatting, charts, pivot tables, macros, and form controls. When you’re finished with this course, you'll have the skills and knowledge of Excel 2019 needed to format and work with more advanced spreadsheets (and continue your preparation for the Microsoft Office exams). Lessons: 1. Formatting 01. Create Custom Number Formats 02. Apply International Currency Formats 03. Display Data in Multiple International Formats 2. Working with Data 04. Outline Data 05. Insert Subtotals 06. Insert References 07. Reference Data in Another Workbook 08. Reference Data by Using Structured References 09. Consolidate Data 10. Configure Data Validation 3. Power Query 11. Import, Transform, and Connect to Data 12. Combine and Display Data 4. Text Functions 13. Format Text by Using RIGHT, LEFT, and MID Functions 14. Format Text by Using UPPER, LOWER, and PROPER Functions 15. Format Text by Using the CONCAT Function 5. Logical and Statistical Functions 16. Perform Logical Operations by Using the IF Function 17. Perform Logical Operations by Using the SUMIF Function 18. Perform Logical Operations by Using the AVERAGEIF Function 19. Perform Statistical Operations by Using the COUNTIF Function 20. Perform Statistical Operations by Using the SUMIFS Function 21. Perform Statistical Operations by Using the AVERAGEIFS Function 22. Perform Statistical Operations by Using the COUNTIFS Function 23. Perform Logical Operations by Using AND, OR, and NOT Functions 24. Perform Logical Operations by Using Nested Functions 6. Expanded Functions 25. Reference the Date and Time by Using the NOW and TODAY Functions 26. Serialize Numbers by Using DATE and TIME Functions 27. Perform What-if Analysis by Using Goal Seek 28. Perform What-if Analysis by Using Scenario Manager 29. Calculate Data by Using Financial Functions: PMT 30. Calculate Data by Using Financial Functions: PPMT & IPMT 31. Calculate Data by Using Financial Functions: FV 7. Error Checking 32. Display Formulas 33. Trace Precedence and Dependence 34. Evaluate Formulas 35. Validate Formulas by Using Error Checking Rules 36. Monitor Cells and Formulas by Using the Watch Window 8. Conditional Formatting 37. Apply Conditional Formatting 38. Create Custom Conditional Formatting Rules 39. Create Conditional Formatting Rules That Use Formulas 40. Manage Conditional Formatting Rules 9. Charts 41. Insert Sparklines 42. Create a New Chart 43. Add Additional Data Series 44. Switch Between Rows and Columns in Source Data 45. Analyze Data by Using Quick Analysis 46. Resize Charts 47. Move Charts to a Chart Sheet 48. Add and Modify Chart Elements 49. Apply Chart Layouts 50. Apply Chart Styles 51. Add Trendlines to Charts 52. Create Dual-axis Charts 53. Save a Chart as a Template 10. Pivot Tables 54. Create Pivot Tables 55. Modify Field Selections and Options 56. Create Slicers 57. Group Pivot Table Data 58. Format Pivot Table Data 59. Add Additional Fields 60. Add Calculated Fields 61. Drill down into PivotTable Details 62. Use Cube Functions to Get Data out of the Excel Data Model 63. Create Pivot Charts 64. Manipulate Options in Existing Pivot Charts 65. Apply Styles to Pivot Charts 66. Drill down into Pivot Chart Details 11. Advanced Options 67. Display Hidden Ribbon Tabs 68. Configure Formula Calculation Options 12. Finalizing a Workbook 69. Inspect a Workbook for Hidden Properties or Personal Information 70. Inspect a Workbook for Accessibility Issues 71. Inspect a Workbook for Compatibility Issues 72. Restrict Editing 73. Protect Workbook Structure 74. Encrypt a Workbook with a Password 75. Manage Workbook Versions 13. Macros 76. Create a Simple Macro 77. Modify a Simple Macro 78. Save and Enable Macros in a Workbook 79. Copy Macros Between Workbooks 80. Create a Macro Button 14. Form Controls 81. Insert and Configure Form Controls Our members see more. Join us! ------------- Our members see more. Join us!