Excel 2013 Fundamentals [2014, ENG]

Обучающие видео » Компьютерные видеоуроки и обучающие интерактивные DVD » Офисные программы Microsoft

Excel 2013 Fundamentals

Год выпуска: 2014
Производитель: Pluralsight
Сайт производителя: http://pluralsight.com/
Автор: Heather Ackmann
Продолжительность: 5h 34m
Тип раздаваемого материала: Видеоклипы
Язык: Английский
Описание: This course covers everything you need to know to get started in Excel 2013. Starting with an overview of how to navigate in Excel using both the mouse and keyboard shortcuts, Heather Ackmann dives into popular topics including writing formulas and expressions, popular functions, sorting and filtering, conditional formatting, PivotTables and PivotCharts, and more.

Этот курс охватывает все, что вам нужно знать, чтобы начать работу в Excel 2013. Начиная с обзора того, как ориентироваться в Excel с использованием как мыши и комбинации клавиш, Хизер Ackmann ныряет в популярных вопросов, включая записи формул и выражений, часто используемых функций, сортировки и фильтрации, условное форматирование, сводных таблиц и сводных диаграмм и многое другое.
[spoiler="Содержание"]
Код:
│ 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
│ 06. The Quick Access Toolbar.mp4
│ 07. The Formula Bar.mp4
│ 08. The Status Bar.mp4
│
├───02. Navigating, Selecting, and Entering Data
│ 01. Introduction.mp4
│ 02. Navigating a Spreadsheet.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
│ 06. Advanced 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
[/spoiler]
Файлы примеров: присутствуют
Формат видео: MP4
[spoiler="audio\video"]
General
Complete name : D:\02. Creating a PivotTable.mp4
Format : MPEG-4
Format profile : Base Media / Version 2
Codec ID : mp42
File size : 30.9 MiB
Duration : 7mn 39s
Overall bit rate mode : Variable
Overall bit rate : 564 Kbps
Encoded date : UTC 2014-02-04 18:17:16
Tagged date : UTC 2014-02-04 18:17:48
Writing application : HandBrake 0.9.8 2012071700

Video
ID : 1
Format : AVC
Format/Info : Advanced Video Codec
Format profile : [email protected]
Format settings, CABAC : No
Format settings, ReFrames : 2 frames
Format settings, GOP : M=1, N=50
Codec ID : avc1
Codec ID/Info : Advanced Video Coding
Duration : 7mn 39s
Duration_FirstFrame : 67ms
Bit rate : 435 Kbps
Width : 1 024 pixels
Height : 768 pixels
Display aspect ratio : 4:3
Frame rate mode : Constant
Frame rate : 15.000 fps
Color space : YUV
Chroma subsampling : 4:2:0
Bit depth : 8 bits
Scan type : Progressive
Bits/(Pixel*Frame) : 0.037
Stream size : 23.8 MiB (77%)
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 18:17:16
Tagged date : UTC 2014-02-04 18:17:47
Color primaries : BT.709
Transfer characteristics : BT.709
Matrix coefficients : BT.709

Audio
ID : 2
Format : AAC
Format/Info : Advanced Audio Codec
Format profile : LC
Codec ID : 40
Duration : 7mn 39s
Bit rate mode : Variable
Bit rate : 127 Kbps
Maximum bit rate : 191 Kbps
Channel count : 2 channels
Channel positions : Front: L R
Sampling rate : 44.1 KHz
Compression mode : Lossy
Stream size : 6.96 MiB (23%)
Language : English
Encoded date : UTC 2014-02-04 18:17:16
Tagged date : UTC 2014-02-04 18:17:47
[/spoiler]
[spoiler="Скриншоты"]

[/spoiler]