[Pluralsight] Excel 2019 Pro [2019, ENG]

Содержание

Formatting 10m 26s Create Custom Number Formats 5m 18s Apply International Currency Formats 2m 34s Display Data in Multiple International Formats 2m 34sWorking with Data 27m 52s Outline Data 3m 57s Insert Subtotals 2m 51s Insert References 4m 24s Reference Data in Another Workbook 3m 12s Reference Data by Using Structured References 3m 19s Consolidate Data 4m 11s Configure Data Validation 5m 54sPower Query 15m 9s Import, Transform, and Connect to Data 8m 49s Combine and Display Data 6m 20sText Functions 8m 6s Format Text by Using RIGHT, LEFT, and MID Functions 3m 14s Format Text by Using UPPER, LOWER, and PROPER Functions 2m 27s Format Text by Using the CONCAT Function 2m 23sLogical and Statistical Functions 33m 22s Perform Logical Operations by Using the IF Function 2m 35s Perform Logical Operations by Using the SUMIF Function 4m 11s Perform Logical Operations by Using the AVERAGEIF Function 3m 58s Perform Statistical Operations by Using the COUNTIF Function 1m 27s Perform Statistical Operations by Using the SUMIFS Function 4m 12s Perform Statistical Operations by Using the AVERAGEIFS Function 3m 1s Perform Statistical Operations by Using the COUNTIFS Function 2m 38s Perform Logical Operations by Using AND, OR, and NOT Functions 4m 2s Perform Logical Operations by Using Nested Functions 7m 14sExpanded Functions 40m 53s Reference the Date and Time by Using the NOW and TODAY Functions 6m 16s Serialize Numbers by Using DATE and TIME Functions 7m 0s Perform What-if Analysis by Using Goal Seek 3m 59s Perform What-if Analysis by Using Scenario Manager 6m 46s Calculate Data by Using Financial Functions: PMT 3m 35s Calculate Data by Using Financial Functions: PPMT & IPMT 8m 53s Calculate Data by Using Financial Functions: FV 4m 21sError Checking 16m 37s Display Formulas 2m 5s Trace Precedence and Dependence 4m 35s Evaluate Formulas 2m 17s Validate Formulas by Using Error Checking Rules 4m 18s Monitor Cells and Formulas by Using the Watch Window 3m 19sConditional Formatting 20m 48s Apply Conditional Formatting 5m 58s Create Custom Conditional Formatting Rules 4m 59s Create Conditional Formatting Rules That Use Formulas 6m 1s Manage Conditional Formatting Rules 3m 47sCharts 44m 44s Insert Sparklines 5m 24s Create a New Chart 3m 27s Add Additional Data Series 4m 21s Switch Between Rows and Columns in Source Data 1m 23s Analyze Data by Using Quick Analysis 3m 29s Resize Charts 2m 4s Move Charts to a Chart Sheet 2m 13s Add and Modify Chart Elements 5m 39s Apply Chart Layouts 2m 26s Apply Chart Styles 3m 34s Add Trendlines to Charts 4m 12s Create Dual-axis Charts 3m 46s Save a Chart as a Template 2m 40sPivot Tables 50m 35s Create Pivot Tables 6m 3s Modify Field Selections and Options 5m 3s Create Slicers 3m 29s Group Pivot Table Data 3m 27s Format Pivot Table Data 3m 10s Add Additional Fields 4m 0s Add Calculated Fields 4m 35s Drill down into PivotTable Details 2m 20s Use Cube Functions to Get Data out of the Excel Data Model 6m 33s Create Pivot Charts 3m 22s Manipulate Options in Existing Pivot Charts 3m 33s Apply Styles to Pivot Charts 2m 14s Drill down into Pivot Chart Details 2m 39sAdvanced Options 9m 23s Display Hidden Ribbon Tabs 5m 4s Configure Formula Calculation Options 4m 18sFinalizing a Workbook 21m 41s Inspect a Workbook for Hidden Properties or Personal Information 3m 48s Inspect a Workbook for Accessibility Issues 3m 16s Inspect a Workbook for Compatibility Issues 3m 6s Restrict Editing 4m 41s Protect Workbook Structure 2m 13s Encrypt a Workbook with a Password 1m 43s Manage Workbook Versions 2m 50sMacros 15m 6s Create a Simple Macro 5m 50s Modify a Simple Macro 2m 23s Save and Enable Macros in a Workbook 2m 19s Copy Macros Between Workbooks 2m 43s Create a Macro Button 1m 50sForm Controls 6m 32s Insert and Configure Form Controls 6m 32s

Скриншоты