Infinite Skills - Microsoft Excel - Charts In Detail Training Video
English | MP4 | 1280x720 | AVC 114 Kbps 15.000 fps | AAC 64.0 Kbps 44.1 khz | 3.25 hours | 550 MB
Genre: Video Training
English | MP4 | 1280x720 | AVC 114 Kbps 15.000 fps | AAC 64.0 Kbps 44.1 khz | 3.25 hours | 550 MB
Genre: Video Training
In this Microsoft Excel – Charts in Detail training course, expert author Guy Vaccaro takes you beyond the basics of Excel, diving into detail about creating and using charts within this powerful spreadsheet program. This course is designed for users that already have a basic working knowledge of Excel.
You will start by learning the basics of Excel charts, such as how to create them quickly and why the right chart type matters. From there, you will learn about the tools within the design and format tabs, including the different chart layout styles and colors, adding and manipulating shapes, and managing data labels. Guy will show you special chart types and properly explain scatter charts. This training video will teach you about chart data and how to create charts from multiple data sources. Finally, Guy will teach you how to print your chart and copy and link it to other Office applications.
By the completion of this video based training course, you will be fully versed in creating and using Excel charts. Working files are included, allowing you to follow along with the author throughout the lessons.
01. Welcome
02. Chart Basics
03. The Design Tab
04. The Format Tab
05. Special Chart Types
06. Chart Data
07. Printing And Sharing Charts
08. The End
General
Complete name : 0101.mp4
Format : MPEG-4
Format profile : Base Media / Version 2
Codec ID : mp42
File size : 7.66 MiB
Duration : 5mn 51s
Overall bit rate : 183 Kbps
Encoded date : UTC 2013-10-02 11:30:23
Tagged date : UTC 2013-10-02 15:30:27
Writing application : Sorenson Squeeze
Comment : Encoded by
Video
ID : 2
Format : AVC
Format/Info : Advanced Video Codec
Format profile : Main@L3.1
Format settings, CABAC : Yes
Format settings, ReFrames : 4 frames
Codec ID : avc1
Codec ID/Info : Advanced Video Coding
Duration : 5mn 51s
Bit rate mode : Variable
Bit rate : 114 Kbps
Nominal bit rate : 500 Kbps
Width : 1 280 pixels
Height : 720 pixels
Display aspect ratio : 16:9
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.008
Stream size : 4.77 MiB (62%)
Writing library : x264 core 129
Encoding settings : cabac=1 / ref=3 / deblock=1:0:0 / analyse=0x1:0x111 / me=hex / subme=7 / psy=1 / psy_rd=1.00:0.00 / mixed_ref=1 / me_range=16 / chroma_me=1 / trellis=1 / 8x8dct=0 / cqm=0 / deadzone=21,11 / fast_pskip=1 / chroma_qp_offset=-2 / threads=6 / lookahead_threads=1 / sliced_threads=0 / nr=0 / decimate=1 / interlaced=0 / bluray_compat=0 / constrained_intra=0 / bframes=3 / b_pyramid=2 / b_adapt=1 / b_bias=0 / direct=1 / weightb=1 / open_gop=0 / weightp=2 / keyint=150 / keyint_min=15 / scenecut=50 / intra_refresh=0 / rc_lookahead=40 / rc=2pass / mbtree=1 / bitrate=500 / ratetol=100.0 / qcomp=0.60 / qpmin=0 / qpmax=69 / qpstep=4 / cplxblur=20.0 / qblur=0.5 / ip_ratio=1.40 / aq=1:1.00
Encoded date : UTC 2013-10-02 11:30:23
Tagged date : UTC 2013-10-02 11:30:23
Audio
ID : 1
Format : AAC
Format/Info : Advanced Audio Codec
Format profile : LC
Codec ID : 40
Duration : 5mn 51s
Bit rate mode : Constant
Bit rate : 64.0 Kbps
Channel(s) : 1 channel
Channel positions : Front: C
Sampling rate : 44.1 KHz
Compression mode : Lossy
Stream size : 2.68 MiB (35%)
Encoded date : UTC 2013-10-02 11:30:23
Tagged date : UTC 2013-10-02 11:30:23
Complete name : 0101.mp4
Format : MPEG-4
Format profile : Base Media / Version 2
Codec ID : mp42
File size : 7.66 MiB
Duration : 5mn 51s
Overall bit rate : 183 Kbps
Encoded date : UTC 2013-10-02 11:30:23
Tagged date : UTC 2013-10-02 15:30:27
Writing application : Sorenson Squeeze
Comment : Encoded by
Video
ID : 2
Format : AVC
Format/Info : Advanced Video Codec
Format profile : Main@L3.1
Format settings, CABAC : Yes
Format settings, ReFrames : 4 frames
Codec ID : avc1
Codec ID/Info : Advanced Video Coding
Duration : 5mn 51s
Bit rate mode : Variable
Bit rate : 114 Kbps
Nominal bit rate : 500 Kbps
Width : 1 280 pixels
Height : 720 pixels
Display aspect ratio : 16:9
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.008
Stream size : 4.77 MiB (62%)
Writing library : x264 core 129
Encoding settings : cabac=1 / ref=3 / deblock=1:0:0 / analyse=0x1:0x111 / me=hex / subme=7 / psy=1 / psy_rd=1.00:0.00 / mixed_ref=1 / me_range=16 / chroma_me=1 / trellis=1 / 8x8dct=0 / cqm=0 / deadzone=21,11 / fast_pskip=1 / chroma_qp_offset=-2 / threads=6 / lookahead_threads=1 / sliced_threads=0 / nr=0 / decimate=1 / interlaced=0 / bluray_compat=0 / constrained_intra=0 / bframes=3 / b_pyramid=2 / b_adapt=1 / b_bias=0 / direct=1 / weightb=1 / open_gop=0 / weightp=2 / keyint=150 / keyint_min=15 / scenecut=50 / intra_refresh=0 / rc_lookahead=40 / rc=2pass / mbtree=1 / bitrate=500 / ratetol=100.0 / qcomp=0.60 / qpmin=0 / qpmax=69 / qpstep=4 / cplxblur=20.0 / qblur=0.5 / ip_ratio=1.40 / aq=1:1.00
Encoded date : UTC 2013-10-02 11:30:23
Tagged date : UTC 2013-10-02 11:30:23
Audio
ID : 1
Format : AAC
Format/Info : Advanced Audio Codec
Format profile : LC
Codec ID : 40
Duration : 5mn 51s
Bit rate mode : Constant
Bit rate : 64.0 Kbps
Channel(s) : 1 channel
Channel positions : Front: C
Sampling rate : 44.1 KHz
Compression mode : Lossy
Stream size : 2.68 MiB (35%)
Encoded date : UTC 2013-10-02 11:30:23
Tagged date : UTC 2013-10-02 11:30:23
Screenshots