# Pluralsight - Excel 2013 Fundamentals (2014)

excel-2013-fundamentals.zip

├───01. Introduction to Excel 2013
│ 01. Introduction.mp4
│ 02. Creating a New Workbook.mp4
│ 03. Opening an Existing Workbook.mp4
│ 04. Signing into Excel 2013.mp4
│ 05. The Ribbon.mp4
│ 07. The Formula Bar.mp4
│ 08. The Status Bar.mp4

├───02. Navigating, Selecting, and Entering Data
│ 01. Introduction.mp4
│ 03. Selecting and Entering Data.mp4
│ 04. AutoFill.mp4
│ 05. FlashFill.mp4
│ 06. Saving.mp4

├───03. Working with Rows, Columns, and Worksheets
│ 01. Introduction.mp4
│ 02. Inserting and Deleting Rows and Columns.mp4
│ 03. Hiding and Unhiding Rows and Columns.mp4
│ 04. Adding, Renaming, and Coloring Worksheets.mp4
│ 05. Moving and Deleting Worksheets.mp4
│ 06. Viewing Multiple Worksheets or Workbooks.mp4

├───04. Introduction to Formulas
│ 01. Introduction.mp4
│ 02. Excel Math.mp4
│ 03. Creating a Simple Formula.mp4
│ 04. Relative, Absolute, and Named References.mp4
│ 05. Named References.mp4

├───05. Introduction to Functions and 3D Formulas
│ 01. Introduction.mp4
│ 02. Excel Functions.mp4
│ 03. Sum, Average, and Count.mp4
│ 04. Introduction to 3D Formulas.mp4

├───06. Sorting and Filtering Data
│ 01. Introduction.mp4
│ 02. Quick Sort and Custom Sort.mp4
│ 03. Creating Subtotals.mp4
│ 04. AutoFilter.mp4
│ 05. Custom Filters.mp4

├───07. Introduction to Formatting
│ 01. Formatting Basics.mp4
│ 02. Working with Alignment.mp4
│ 03. Number Formats.mp4
│ 04. Date and Times.mp4
│ 05. Conditional Formatting.mp4

├───08. Introduction to Charts
│ 01. Introduction.mp4
│ 02. Chart Types.mp4
│ 03. Creating a Chart.mp4
│ 04. Chart Elements.mp4
│ 05. Chart Filters.mp4
│ 06. Change the Chart Type.mp4
│ 07. Sparklines and Data Bars.mp4

├───09. Introduction to PivotTables and PivotCharts
│ 01. Introduction.mp4
│ 02. Creating a PivotTable.mp4
│ 03. Formatting a PivotTable.mp4
│ 04. Creating a Calculated Field.mp4
│ 05. Slicers.mp4
│ 06. Creating a PivotChart.mp4

├───10. Introduction to Printing
│ 01. Introduction.mp4
│ 02. Print Views and Page Breaks.mp4
│ 03. Print Scaling.mp4
│ 04. Print Settings.mp4
│ 05. Adding Print Titles and Gridlines.mp4

└───11. Conclusion
01. Conclusion.mp4
Format : MPEG-4
Format profile : Base Media / Version 2
Codec ID : mp42
File size : 15.1 MiB
Duration : 4mn 19s
Overall bit rate : 488 Kbps
Encoded date : UTC 2014-02-04 05:41:24
Tagged date : UTC 2014-02-04 05:41:42
Writing application : HandBrake 0.9.8 2012071700
Video #1
ID : 1
Format : AVC
Format profile : Baseline@L3.1
Format settings, CABAC : No
Format settings, ReFrames : 2 frames
Codec ID : avc1
Codec ID/Info : Advanced Video Coding
Duration : 4mn 19s
Bit rate mode : Variable
Bit rate : 361 Kbps
Width : 1 024 pixels
Height : 768 pixels
Display aspect ratio : 4:3
Frame rate mode : Variable
Frame rate : 15.000 fps
Minimum frame rate : 7.500 fps
Maximum frame rate : 15.000 fps
Resolution : 24 bits
Colorimetry : 4:2:0
Scan type : Progressive
Bits/(Pixel*Frame) : 0.031
Stream size : 11.2 MiB (74%)
Writing library : x264 core 120
Encoding settings : cabac=0 / ref=2 / deblock=1:0:0 / analyse=0x1:0x111 / me=umh / subme=6 / psy=1 / psy_rd=1.00:0.00 / mixed_ref=1 / me_range=16 / chroma_me=1 / trellis=0 / 8x8dct=0 / cqm=0 / deadzone=21,11 / fast_pskip=1 / chroma_qp_offset=-2 / threads=12 / sliced_threads=0 / nr=0 / decimate=1 / interlaced=0 / bluray_compat=0 / constrained_intra=0 / bframes=0 / weightp=0 / keyint=50 / keyint_min=15 / scenecut=40 / intra_refresh=0 / rc_lookahead=40 / rc=crf / mbtree=1 / crf=20.0 / qcomp=0.60 / qpmin=3 / qpmax=69 / qpstep=4 / ip_ratio=1.40 / aq=1:1.00
Encoded date : UTC 2014-02-04 05:41:24
Tagged date : UTC 2014-02-04 05:41:42
colour_primaries : BT.709-5, BT.1361, IEC 61966-2-4, SMPTE RP177
transfer_characteristics : BT.709-5, BT.1361
matrix_coefficients : BT.709-5, BT.1361, IEC 61966-2-4 709, SMPTE RP177
Audio #2
ID : 2
Format : AAC
Format version : Version 4
Format profile : LC
Format settings, SBR : No
Codec ID : 40
Duration : 4mn 19s
Bit rate mode : Variable
Bit rate : 125 Kbps
Maximum bit rate : 164 Kbps
Channel(s) : 2 channels
Channel positions : L R
Sampling rate : 44.1 KHz
Resolution : 16 bits
Stream size : 3.85 MiB (26%)
Language : English
Encoded date : UTC 2014-02-04 05:41:24
Tagged date : UTC 2014-02-04 05:41:42