Microsoft Excel _ MS Excel Basics & Excel PivotTables (2021)
Microsoft Excel _ MS Excel Basics & Excel PivotTables (2021)
WEBRip | English | MP4 | 1280 x 720 | AVC ~811 Kbps | 30 fps
AAC | 128 Kbps | 44.1 KHz | 2 channels | Subs: English (.srt) | ~2 hours | 862 MB
AAC | 128 Kbps | 44.1 KHz | 2 channels | Subs: English (.srt) | ~2 hours | 862 MB
Genre: eLearning Video / Office Productivity, Microsoft, Excel
Become the master of Excel Pivot Tables | MS Excel | 2021 courseWhat you'll learn
Learn about PivotTable and use it for analysis
Learn Excel by doing using practical examples
Learn how to perform basic calculations
Requirements
Basic understanding of Formulas using Excel will be helpful, but not a must
Description
Hello!
This part of My Microsoft Excel series of courses focuses on the PivotTable part. PivotTables are very powerful tools inside MS Excel allows us to analyse huge datasets in a very efficient and short time.
This course will help the learners to improve their skills and be familiar with Microsoft Excel. Now a days, Microsoft Excel is one of the most important and used program world wide.
What makes me qualified to teach you?
My name is Mozn and I've been a professional instructor for over a decade. Plus I'm the founder of Mezan Institute and the Author of a published book. I break down complex topics into an easy understandable messages, and help learners to absorbe the study material in an easy and engaging way. My courses are continuously receiving 5-star reviews like these from Microsoft Excel from Zero to Hero, 2020:
***** I realise after this quick and easy course that I new few parts of the excel but I am realy greathfull that Iadd few more when soon as I finsh this course. - Diana
***** Simple quick into to excel. Please add some more lectures similar to this :). - Geraldine
***** Yes, a good match, I do this every day, however, manually, but now I understand formulas much better, and it is less time consuming. - Dianne
What is this Excel course about?
In this guide to Microsoft Excel course, you'll not only learn all of the principles of Microsoft Excel, but also how to understand and become a star in your field.
This course will cover Beginners, Intermediate and Advanced levels of Excel, including:
The basics of MS Excel
The powerful tool of PivotTables
Creating and Managing PivotTables
Learn from someone who is currently working in the industry, who knows the most current teaching techniques.
By the end of this course, your confidence as Data analyst using Excel will soar. You'll have a thorough understanding of how to use Excel in a business or personal environment.
Go ahead and click the enroll button, and I'll see you in lesson 1!
I wish you an enjoyable journey with us.
Shukran! Mozn
Who this course is for:
Anyone interested in learning Microsoft Excel
Anyone need to save time and create automatic and dynamic reports
also You can find my other useful: Excel-posts
General
Complete name : 1. Working with Simple formulas.mp4
Format : MPEG-4
Format profile : Base Media
Codec ID : isom (isom/iso2/avc1/mp41)
File size : 58.8 MiB
Duration : 8 min 40 s
Overall bit rate : 949 kb/s
Writing application : Lavf58.12.100
IsTruncated : Yes
Video
ID : 1
Format : AVC
Format/Info : Advanced Video Codec
Format profile : Main@L3.1
Format settings : CABAC / 4 Ref Frames
Format settings, CABAC : Yes
Format settings, RefFrames : 4 frames
Format settings, GOP : M=4, N=60
Codec ID : avc1
Codec ID/Info : Advanced Video Coding
Duration : 8 min 40 s
Bit rate : 811 kb/s
Nominal bit rate : 3 000 kb/s
Width : 1 280 pixels
Height : 720 pixels
Display aspect ratio : 16:9
Frame rate mode : Constant
Frame rate : 30.000 FPS
Color space : YUV
Chroma subsampling : 4:2:0
Bit depth : 8 bits
Scan type : Progressive
Bits/(Pixel*Frame) : 0.029
Stream size : 50.3 MiB (86%)
Writing library : x264 core 148
Encoding settings : cabac=1 / ref=3 / 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=1 / 8x8dct=0 / cqm=0 / deadzone=21,11 / fast_pskip=1 / chroma_qp_offset=-2 / threads=22 / lookahead_threads=3 / 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=60 / keyint_min=6 / scenecut=0 / intra_refresh=0 / rc_lookahead=60 / rc=cbr / mbtree=1 / bitrate=3000 / ratetol=1.0 / qcomp=0.60 / qpmin=0 / qpmax=69 / qpstep=4 / vbv_maxrate=3000 / vbv_bufsize=6000 / nal_hrd=none / filler=0 / ip_ratio=1.40 / aq=1:1.00
Audio
ID : 2
Format : AAC
Format/Info : Advanced Audio Codec
Format profile : LC
Codec ID : mp4a-40-2
Duration : 8 min 40 s
Bit rate mode : Constant
Bit rate : 128 kb/s
Channel(s) : 2 channels
Channel positions : Front: L R
Sampling rate : 44.1 kHz
Frame rate : 43.066 FPS (1024 SPF)
Compression mode : Lossy
Stream size : 7.94 MiB (13%)
Default : Yes
Alternate group : 1
Complete name : 1. Working with Simple formulas.mp4
Format : MPEG-4
Format profile : Base Media
Codec ID : isom (isom/iso2/avc1/mp41)
File size : 58.8 MiB
Duration : 8 min 40 s
Overall bit rate : 949 kb/s
Writing application : Lavf58.12.100
IsTruncated : Yes
Video
ID : 1
Format : AVC
Format/Info : Advanced Video Codec
Format profile : Main@L3.1
Format settings : CABAC / 4 Ref Frames
Format settings, CABAC : Yes
Format settings, RefFrames : 4 frames
Format settings, GOP : M=4, N=60
Codec ID : avc1
Codec ID/Info : Advanced Video Coding
Duration : 8 min 40 s
Bit rate : 811 kb/s
Nominal bit rate : 3 000 kb/s
Width : 1 280 pixels
Height : 720 pixels
Display aspect ratio : 16:9
Frame rate mode : Constant
Frame rate : 30.000 FPS
Color space : YUV
Chroma subsampling : 4:2:0
Bit depth : 8 bits
Scan type : Progressive
Bits/(Pixel*Frame) : 0.029
Stream size : 50.3 MiB (86%)
Writing library : x264 core 148
Encoding settings : cabac=1 / ref=3 / 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=1 / 8x8dct=0 / cqm=0 / deadzone=21,11 / fast_pskip=1 / chroma_qp_offset=-2 / threads=22 / lookahead_threads=3 / 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=60 / keyint_min=6 / scenecut=0 / intra_refresh=0 / rc_lookahead=60 / rc=cbr / mbtree=1 / bitrate=3000 / ratetol=1.0 / qcomp=0.60 / qpmin=0 / qpmax=69 / qpstep=4 / vbv_maxrate=3000 / vbv_bufsize=6000 / nal_hrd=none / filler=0 / ip_ratio=1.40 / aq=1:1.00
Audio
ID : 2
Format : AAC
Format/Info : Advanced Audio Codec
Format profile : LC
Codec ID : mp4a-40-2
Duration : 8 min 40 s
Bit rate mode : Constant
Bit rate : 128 kb/s
Channel(s) : 2 channels
Channel positions : Front: L R
Sampling rate : 44.1 kHz
Frame rate : 43.066 FPS (1024 SPF)
Compression mode : Lossy
Stream size : 7.94 MiB (13%)
Default : Yes
Alternate group : 1
Screenshots
Microsoft Excel _ MS Excel Basics & Excel PivotTables (2021)
Microsoft Excel _ MS Excel Basics & Excel PivotTables (2021)
Microsoft Excel _ MS Excel Basics & Excel PivotTables (2021)
Microsoft Excel _ MS Excel Basics & Excel PivotTables (2021)
Exclusive eLearning Videos ParRus-blog ← add to bookmarks
Microsoft Excel _ MS Excel Basics & Excel PivotTables (2021)
