Mastering Microsoft Excel 2016 204 Training Tutorial CG | 210774AB3F7BDF9988F39DC875F73ACE4CF5D460

Mastering Microsoft Excel 2016 204 Training Tutorial CG

Name	Mastering Microsoft Excel 2016 [204 Training Tutorial] CG	DOWNLOAD Copy Link
Total Size	1.1 GB
Total Files	204
Hash	210774AB3F7BDF9988F39DC875F73ACE4CF5D460

/02 Getting Acquainted with Excel/
014 The Mini Toolbar.mp4	715.4 KB
006 Scroll Bars.mp4	903.9 KB
009 The Formula Bar.mp4	1.2 MB
005 The File Tab and Backstage View.mp4	1.9 MB
008 Touch Mode.mp4	2.2 MB
012 The Workbook View Buttons.mp4	3.0 MB
003 The Title Bar.mp4	3.1 MB
011 The Status Bar.mp4	3.2 MB
015 Keyboard Shortcuts.mp4	3.3 MB
001 About Excel.mp4	3.3 MB
002 The Excel Environment.mp4	3.6 MB
004 The Ribbon.mp4	4.3 MB
010 The Workbook Window.mp4	4.6 MB
013 The Zoom Slider.mp4	4.6 MB
007 The Quick Access Toolbar.mp4	5.6 MB
/27 Creating Charts In Excel/
007 Switching Column and Row Data.mp4	860.1 KB
008 Choosing a Chart Layout.mp4	1.1 MB
010 Changing Color Schemes.mp4	1.4 MB
012 Deleting Charts.mp4	1.5 MB
011 Printing Charts.mp4	1.6 MB
005 Changing the Chart Type.mp4	1.8 MB
009 Choosing a Chart Style.mp4	1.9 MB
003 Adding Chart Elements.mp4	4.4 MB
004 Moving and Resizing Charts.mp4	5.8 MB
002 Selecting Charts and Chart Elements.mp4	6.7 MB
001 Creating Charts.mp4	8.9 MB
006 Changing the Data Range.mp4	13.2 MB
/08 Formatting Worksheets/
003 Clearing All Formatting from Cells.mp4	943.7 KB
004 Copying All Formatting from Cells to Another Area.mp4	1.9 MB
001 Formatting Cells.mp4	7.6 MB
002 The Format Cells Dialog Box.mp4	17.4 MB
/05 Creating Formulas/
007 Formula AutoCorrect.mp4	991.5 KB
008 AutoCalculate.mp4	1.7 MB
006 Editing a Range.mp4	2.2 MB
002 Simple Formula Syntax.mp4	2.9 MB
001 Ranged Formula Syntax.mp4	3.0 MB
009 Function Compatibility.mp4	4.0 MB
004 Using AutoSum.mp4	4.3 MB
005 Inserting Functions.mp4	7.9 MB
003 Writing Formulas.mp4	8.4 MB
/03 File Management/
010 Hiding and Unhiding Workbook Windows.mp4	1.1 MB
003 Closing Workbooks.mp4	1.3 MB
012 Switching Open Workbooks.mp4	1.4 MB
001 Creating New Workbooks.mp4	1.4 MB
013 Switching to Full Screen View.mp4	2.0 MB
006 Opening a Workbook in a New Window.mp4	2.1 MB
005 Recovering Unsaved Workbooks.mp4	2.5 MB
009 Split Panes.mp4	3.1 MB
011 Comparing Open Workbooks.mp4	3.5 MB
007 Arranging Open Workbook Windows.mp4	5.1 MB
002 Saving Workbooks.mp4	5.5 MB
008 Freeze Panes.mp4	6.0 MB
014 Working with Excel File Formats.mp4	7.6 MB
004 Opening Workbooks.mp4	8.5 MB
/21 Tables/
004 Deleting Records and Fields.mp4	1.1 MB
003 Inserting Records and Fields.mp4	1.5 MB
002 Adding and Editing Records.mp4	2.3 MB
001 Creating a Table.mp4	9.4 MB
/32 Power View/
004 Using Undo and Redo in Power View.mp4	1.1 MB
006 Creating Multiples in a Chart.mp4	1.8 MB
008 Cross-Filtering Visualizations.mp4	2.5 MB
003 Changing the Layout of Report Visualizations.mp4	2.5 MB
005 Formatting the Power View Sheet.mp4	5.4 MB
002 Adding Report Visualizations.mp4	6.3 MB
007 Filtering Power View Using the Filter Area.mp4	12.8 MB
001 Starting Power View.mp4	14.9 MB
/14 Named Ranges/
003 Moving to a Named Range.mp4	1.2 MB
006 Deleting Named Ranges.mp4	1.7 MB
002 Creating Names from Headings.mp4	2.3 MB
005 Naming 3D Ranges.mp4	3.5 MB
004 Using Named Ranges in Formulas.mp4	4.3 MB
001 Naming Ranges.mp4	6.7 MB
/04 Data Entry/
005 Pick from Drop-Down List.mp4	1.3 MB
004 AutoComplete.mp4	1.6 MB
008 Ranged Data Entry.mp4	1.7 MB
002 Entering Text into Cells.mp4	3.6 MB
001 Selecting Cells.mp4	3.8 MB
003 Entering Numbers into Cells.mp4	4.7 MB
009 Using AutoFill.mp4	6.0 MB
006 Flash Fill.mp4	6.9 MB
007 Selecting Ranges.mp4	8.3 MB
/28 Formatting Charts in Excel/
015 Naming Charts.mp4	1.4 MB
005 Formatting a Chart Title.mp4	2.4 MB
010 Formatting a Legend.mp4	2.6 MB
011 Formatting Drop and High-Low Lines.mp4	2.7 MB
013 Formatting UpDown Bars.mp4	2.8 MB
009 Formatting Gridlines.mp4	2.8 MB
006 Formatting Data Labels.mp4	3.0 MB
008 Formatting Error Bars.mp4	3.0 MB
007 Formatting a Data Table.mp4	3.2 MB
003 Formatting Axes.mp4	3.2 MB
017 Applying WordArt Styles.mp4	3.2 MB
002 Inserting Objects into a Chart.mp4	3.4 MB
012 Formatting Trendlines.mp4	3.4 MB
001 Formatting Chart Objects.mp4	3.6 MB
004 Formatting Axis Titles.mp4	3.6 MB
016 Applying Shape Styles.mp4	3.9 MB
014 Formatting the Chart and Plot Areas.mp4	4.7 MB
018 Saving Custom Chart Templates.mp4	6.5 MB
/18 Auditing Worksheets/
003 Tracing Errors.mp4	1.6 MB
001 Auditing Worksheets.mp4	2.7 MB
005 Using the Watch Window.mp4	4.2 MB
002 Tracing Precedent and Dependent Cells.mp4	6.7 MB
004 Error Checking.mp4	9.0 MB
006 Cell Validation.mp4	17.2 MB
/15 Conditional Formatting and Cell Styles/
002 Finding Cells with Conditional Formatting.mp4	1.6 MB
003 Clearing Conditional Formatting.mp4	1.9 MB
004 Using Table and Cell Styles.mp4	4.6 MB
001 Conditional Formatting.mp4	11.6 MB
/10 Setting Worksheet Layout/
002 Using the Page Layout View.mp4	1.8 MB
003 Opening the Page Setup Dialog Box.mp4	2.0 MB
005 Setting Margins.mp4	2.1 MB
001 Using Page Break Preview.mp4	3.1 MB
004 Page Settings.mp4	4.1 MB
006 Creating Headers and Footers.mp4	9.4 MB
007 Sheet Settings.mp4	9.7 MB
/37 Instruction Manuals/
002 Intermediate Excel Manual.pdf	2.0 MB
001 Introductory Excel Manual.pdf	2.0 MB
003 Advanced Excel Manual.pdf	2.8 MB
/06 Copying Pasting Formulas/
005 The Redo Button.mp4	2.1 MB
003 AutoFilling Cells.mp4	2.4 MB
004 The Undo Button.mp4	2.5 MB
002 Cutting, Copying, and Pasting Data.mp4	9.2 MB
001 Relative References and Absolute References.mp4	9.5 MB
/09 Worksheet Tools/
004 Renaming Worksheets.mp4	2.2 MB
001 Inserting and Deleting Worksheets.mp4	2.2 MB
002 Selecting Multiple Worksheets.mp4	2.8 MB
003 Navigating Worksheets.mp4	3.0 MB
005 Coloring Worksheet Tabs.mp4	3.4 MB
006 Copying or Moving Worksheets.mp4	4.6 MB
/30 PivotTables and PivotCharts/
007 Formatting PivotCharts.mp4	2.2 MB
005 Changing Calculated Value Fields.mp4	5.0 MB
008 Setting PivotTable Options.mp4	5.1 MB
003 Creating a PivotChart.mp4	6.7 MB
006 Formatting PivotTables.mp4	7.0 MB
004 Manipulating a PivotTable or PivotChart.mp4	8.1 MB
009 Sorting and Filtering Using Field Headers.mp4	8.7 MB
002 Manually Creating a PivotTable.mp4	9.5 MB
001 Creating Recommended PivotTables.mp4	15.4 MB
/35 Making Macros/
002 Running and Deleting Recorded Macros.mp4	2.3 MB
003 The Personal Macro Workbook.mp4	4.5 MB
001 Recording Macros.mp4	5.7 MB
/34 Security Features/
003 Workbook Protection.mp4	2.6 MB
002 Worksheet Protection.mp4	4.9 MB
004 Password Protecting Excel Files.mp4	5.0 MB
001 Unlocking Cells.mp4	8.0 MB
/17 Sharing Workbooks/
001 About Sharing Workbooks.mp4	2.6 MB
005 Reviewing Changes.mp4	3.6 MB
004 Highlighting Changes.mp4	6.0 MB
002 Simplified Workbook Sharing in Excel 2016.mp4	7.1 MB
007 Compare and Merge Workbooks.mp4	7.5 MB
003 Traditional Workbook Sharing.mp4	9.8 MB
006 Using Comments.mp4	12.9 MB
/33 Slicers and Timelines/
004 Modifying Timelines.mp4	2.7 MB
002 Modifying Slicers.mp4	4.4 MB
003 Inserting and Deleting Timelines.mp4	5.1 MB
001 Inserting and Deleting Slicers.mp4	7.8 MB
/31 Power Pivot/
007 Power Pivot PivotTables and PivotCharts.mp4	2.7 MB
002 Managing the Data Model.mp4	5.1 MB
003 Calculated Columns.mp4	6.2 MB
001 Starting Power Pivot.mp4	7.4 MB
006 Creating and Managing Perspectives.mp4	8.9 MB
005 Creating KPIs.mp4	9.2 MB
004 Measures.mp4	10.8 MB
/07 Columns Rows/
001 Selecting Columns and Rows.mp4	2.7 MB
003 Hiding and Unhiding Columns and Rows.mp4	3.1 MB
002 Adjusting Column Width and Row Height.mp4	5.0 MB
004 Inserting and Deleting Columns and Rows.mp4	8.5 MB
/13 3D Formulas/
003 Creating 3D Range References.mp4	3.3 MB
001 Creating 3D Formulas.mp4	3.7 MB
002 3D Formula Syntax.mp4	4.2 MB
/23 Filtering Data/
007 Copying Filter Results to a New Location.mp4	3.5 MB
002 Using the Top 10 AutoFilter.mp4	3.9 MB
001 Using AutoFilters.mp4	5.2 MB
003 Applying a Custom AutoFilter.mp4	8.5 MB
008 Using Database Functions.mp4	8.6 MB
004 Creating Advanced Filters.mp4	9.7 MB
005 Applying Multiple Criteria.mp4	10.0 MB
006 Using Complex Criteria.mp4	10.4 MB
/19 Outlining Worksheets/
001 Using Outlines.mp4	3.5 MB
002 Applying and Removing Outlines.mp4	3.6 MB
/12 Helping Yourself/
002 The Tell Me Bar- 2016 Only.mp4	4.3 MB
003 Smart Lookup and Insights- 2016 Only.mp4	5.6 MB
001 Using Excel Help.mp4	10.7 MB
/24 What-If Analysis and Forecasts/
003 Using Goal Seek.mp4	4.6 MB
001 Using Data Tables.mp4	8.4 MB
004 Forecast Sheets- 2016 Only.mp4	12.9 MB
002 Using Scenario Manager.mp4	17.7 MB
/29 Data Models/
001 Creating a Data Model from External Relational Data.mp4	6.1 MB
004 Managing a Data Model.mp4	9.3 MB
002 Creating a Data Model from Excel Tables.mp4	10.1 MB
003 Relating Tables in a Data Model.mp4	10.9 MB
/16 Paste Special/
002 Pasting Linked Formulas.mp4	6.3 MB
001 Using Paste Special.mp4	14.6 MB
/22 Sorting Data/
001 Sorting Data.mp4	6.4 MB
002 Custom Sort Orders.mp4	10.3 MB
/26 Sparklines/
001 Inserting and Deleting Sparklines.mp4	6.6 MB
002 Modifying Sparklines.mp4	6.6 MB
/36 Conclusion/
001 Course Conclusion.mp4	6.8 MB
/01 Course Introduction/
001 Course Introduction.mp4	7.1 MB
/11 Printing Worksheets/
001 Previewing and Printing Worksheets.mp4	8.4 MB
/25 Table-Related Functions/
001 The Hlookup and Vlookup Functions.mp4	10.4 MB
002 Using the IF, AND, and OR Functions.mp4	14.5 MB
/20 Consolidating Worksheets/
001 Consolidating Data.mp4	17.0 MB
Total files 204