~Get Your Files Here !/01 Getting Started/001 A brief introduction to the course.mp485.53MB
~Get Your Files Here !/02 Create Worksheets and Workbooks/001 Create blank and populated workbooks.mp4164MB
~Get Your Files Here !/02 Create Worksheets and Workbooks/002 Add worksheets to workbooks; move or copy worksheets; import data from text file.mp4110.3MB
~Get Your Files Here !/03 Navigate worksheets and workbooks/001 Search for data within a workbook.mp482.03MB
~Get Your Files Here !/03 Navigate worksheets and workbooks/002 Navigate to a named cell, range, or workbook element.mp446.98MB
~Get Your Files Here !/03 Navigate worksheets and workbooks/003 Link to internal and external locations and files.mp4114.98MB
~Get Your Files Here !/04 Manage worksheets and workbooks/001 Manage worksheet attributes.mp461.64MB
~Get Your Files Here !/04 Manage worksheets and workbooks/002 Change the appearance of workbook content; modify page setup; insert headers and.mp4133.93MB
~Get Your Files Here !/05 Customize options and views for worksheets and workbooks/001 Hide and unhide worksheet contents.mp464.89MB
~Get Your Files Here !/05 Customize options and views for worksheets and workbooks/002 Customize the Quick Access Toolbar (QAT).mp472.67MB
~Get Your Files Here !/05 Customize options and views for worksheets and workbooks/003 Modify the display of worksheets.mp4172.29MB
~Get Your Files Here !/05 Customize options and views for worksheets and workbooks/009 Hide_Unhide_Conlents_L1.mp431.08MB
~Get Your Files Here !/06 Configure worksheets and workbooks for distribution/001 Print all or part of a workbook.mp4101.83MB
~Get Your Files Here !/06 Configure worksheets and workbooks for distribution/002 Set print scaling; print sheet elements.mp4109.3MB
~Get Your Files Here !/06 Configure worksheets and workbooks for distribution/012 PrintAllOrPartOfWB_L1.mp451.83MB
~Get Your Files Here !/07 Manage data cells and ranges/001 Create data; reuse data; replace data.mp4372.25MB
~Get Your Files Here !/07 Manage data cells and ranges/002 Format cells and ranges.mp4114.55MB
~Get Your Files Here !/07 Manage data cells and ranges/003 Apply cell formats and styles; apply number formats.mp467.84MB
~Get Your Files Here !/07 Manage data cells and ranges/004 Summarize and organize data.mp4118.39MB
~Get Your Files Here !/07 Manage data cells and ranges/005 Insert Sparklines; outline data and insert subtotals.mp4106.45MB
~Get Your Files Here !/08 Create and manage tables/001 One_ Create and manage tables; manage table styles and options; filter and sort.mp4229.67MB
~Get Your Files Here !/09 Perform operations with formulas and functions/001 Summarize data by using functions.mp4122.05MB
~Get Your Files Here !/09 Perform operations with formulas and functions/002 Perform conditional operations by using functions.mp4225.41MB
~Get Your Files Here !/09 Perform operations with formulas and functions/003 Format and modify text by using functions.mp489.22MB
~Get Your Files Here !/10 Create charts and objects/001 Create charts and objects.mp479.24MB
~Get Your Files Here !/10 Create charts and objects/002 Format charts.mp4108.13MB
~Get Your Files Here !/10 Create charts and objects/003 Insert and format objects.mp4142.66MB