Last updated 4/2022
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz
Language: English | Size: 3.29 GB | Duration: 14h 43m
Microsoft Certified Master Instructor – Microsoft Excel Functions – VLOOKUP – Sorting – Filtering – Charts – Formatting
What you’ll learn
Learn how to work with data
Learn how to import text data
Learn how to sort and filter data
Learn how to use the advanced filter
Learn how to use vlookup & freeze frames
Learn how to use find & replace to quickly update data
Learn how to convert delimited text into columns
Learn how to remove duplicates & validate data
Learn how to use "what-if" analysis & create forecasts
Learn how to consolidate, group, & sub-total data
Learn all about visually representing data & creating charts
Learn how to include sparklines, combo charts, & trendlines
Learn how to format your worksheets for printing
Learn the different ways of viewing your worksheets
Learn how to include headers & footers in your worksheets
Gain a thorough foundation in using Excel functions
Learn how to use logical functions
Learn how to use text functions
Learn how to use date & time functions
Learn how to use lookup & reference functions
Learn how to use information functions
Acquire skills using conditional formatting & custom views
Receive an entire section covering Google Drive
Requirements
All versions of Microsoft Excel work for this course. The instructor will be using Microsoft Excel 2016.
Description
You can learn Microsoft Excel easily and quickly if it is taught correctly.Developed by a Microsoft Certified Master Instructor, this course is the perfect course when you are ready to progress with your Microsoft Excel skills. Taught by a university professor with over twenty years of experience teaching individuals of all ability levels "how to use" Microsoft Excel, Todd McLeod has designed, refined, and perfected this course to make it easy for you to learn Microsoft Excel.Providing a comprehensive curriculum of 180 video lectures, including 72 hands-on exercises, you will learn all of the following about Microsoft Excel
Learn how to work with dataLearn how to import text dataLearn how to sort and filter dataLearn how to use the advanced filterLearn how to use vlookup & freeze framesLearn how to use find & replace to quickly update dataLearn how to convert delimited text into columnsLearn how to remove duplicates & validate dataLearn how to use "what-if" analysis & create forecastsLearn how to consolidate, group, & sub-total dataLearn all about visually representing data & creating chartsLearn how to include sparklines, combo charts, & trendlinesLearn how to format your worksheets for printingLearn the different ways of viewing your worksheetsLearn how to include headers & footers in your worksheetsGain a thorough foundation in using Excel functionsLearn how to use logical functionsLearn how to use text functionsLearn how to use date & time functionsLearn how to use lookup & reference functionsLearn how to use information functionsAcquire skills using conditional formatting & custom viewsGain insight into using Office365 onlineWork with a comprehensive set of 72 "hands-on exercises"Receive solutions to all of the "hands-on exercises"download all of the Excel project files that are used in the videos.This class is guaranteed to help you progress with your Microsoft Excel skills. Once enrolled, you will have access to this Excel course for the rest of your life. Described as “fun” and “amazing” and “life changing,” Todd McLeod’s Excel training will forever transform the way you work with numbers. Try this course for yourself and see how quickly and easily you too can advance your Microsoft Excel skills.
Overview
Section 1: Introduction
Lecture 1 Welcome
Lecture 2 Course outline
Lecture 3 Course files
Lecture 4 Versions
Section 2: Working With Data
Lecture 5 Acquiring Data
Lecture 6 Importing Text Data
Lecture 7 Sort
Lecture 8 Vlookup
Lecture 9 Freeze frames
Lecture 10 Vlookup & Sort
Lecture 11 Filter
Lecture 12 Advanced Filter
Lecture 13 Find & Replace
Section 3: Exercises – Ninja Level 2
Lecture 14 Hands-On Exercise #1
Lecture 15 Hands-On Exercise #2
Lecture 16 Hands-On Exercise #3
Lecture 17 Hands-On Exercise #4
Lecture 18 Hands-On Exercise #5
Lecture 19 Hands-On Exercise #6
Lecture 20 Hands-On Exercise #7
Lecture 21 Hands-On Exercise #8
Lecture 22 Hands-On Exercise #9
Lecture 23 Hands-On Exercise #10
Section 4: Progressing With Data
Lecture 24 Overview
Lecture 25 Text to Columns
Lecture 26 Flash Fill
Lecture 27 Remove Duplicates
Lecture 28 Data Validation
Lecture 29 Consolidate
Lecture 30 What If – Goal Seek
Lecture 31 What If – Scenario
Lecture 32 What If – Data Table
Lecture 33 Forecasts
Section 5: Exercises – Ninja Level 3
Lecture 34 Hands-On Exercise #1
Lecture 35 Hands-On Exercise #2
Lecture 36 Hands-On Exercise #3
Lecture 37 Hands-On Exercise #4
Lecture 38 Hands-On Exercise #5
Lecture 39 Hands-On Exercise #6
Lecture 40 Hands-On Exercise #7
Lecture 41 Hands-On Exercise #8
Lecture 42 Hands-On Exercise #9
Lecture 43 Hands-On Exercise #10
Section 6: Displaying Data
Lecture 44 Overview
Lecture 45 Group
Lecture 46 Subtotal
Lecture 47 Visually Representing Data
Lecture 48 Chart Creation
Lecture 49 Chart Creation II
Lecture 50 Chart Formatting
Lecture 51 Chart Formatting II
Lecture 52 Chart Sparklines
Lecture 53 Combo Chart
Lecture 54 Chart Trendlines
Section 7: Exercises – Ninja Level 4
Lecture 55 Hands-On Exercise #1
Lecture 56 Hands-On Exercise #2
Lecture 57 Hands-On Exercise #3
Lecture 58 Hands-On Exercise #4
Lecture 59 Hands-On Exercise #5
Section 8: Viewing & Printing
Lecture 60 Split Window
Lecture 61 Multiple Windows
Lecture 62 Helpful Printing Views
Lecture 63 Page Break Adjustments
Lecture 64 Including Layout Items
Lecture 65 Exploring Page Setup
Lecture 66 Adding a Header & Footer
Lecture 67 Printing & Printing To File
Section 9: Exercises – Ninja Level 5
Lecture 68 Hands-On Exercise #1
Lecture 69 Hands-On Exercise #2
Lecture 70 Hands-On Exercise #3
Lecture 71 Hands-On Exercise #4
Lecture 72 Hands-On Exercise #5
Lecture 73 Hands-On Exercise #6
Lecture 74 Hands-On Exercise #7
Lecture 75 Hands-On Exercise #8
Section 10: Functions – Logical
Lecture 76 Overview
Lecture 77 NA
Lecture 78 IFNA
Lecture 79 IF
Lecture 80 IFERROR
Lecture 81 TRUE & FALSE
Lecture 82 NOT
Lecture 83 AND
Lecture 84 OR
Lecture 85 XOR
Section 11: Exercises – Ninja Level 6
Lecture 86 Hands-On Exercise #1
Lecture 87 Hands-On Exercise #2
Lecture 88 Hands-On Exercise #3
Lecture 89 Hands-On Exercise #4
Lecture 90 Hands-On Exercise #5
Lecture 91 Hands-On Exercise #6
Section 12: Functions – Text
Lecture 92 Overview
Lecture 93 Capitalization
Lecture 94 Joining Text
Lecture 95 Replacing Text
Lecture 96 Finding Text
Lecture 97 Text Length
Lecture 98 Text Equality
Lecture 99 Trimming Text
Section 13: Exercises – Ninja Level 7
Lecture 100 Hands-On Exercise #1
Lecture 101 Hands-On Exercise #2
Lecture 102 Hands-On Exercise #3
Lecture 103 Hands-On Exercise #4
Lecture 104 Hands-On Exercise #5
Lecture 105 Hands-On Exercise #6
Lecture 106 Hands-On Exercise #7
Section 14: Functions – Date & Time
Lecture 107 Dates & Times
Lecture 108 Current Date Time
Lecture 109 Created Date Time
Lecture 110 Extracting Date Time
Lecture 111 Finding Durations
Lecture 112 Finding The Future
Section 15: Exercises – Ninja Level 8
Lecture 113 Hands-On Exercise #1
Lecture 114 Hands-On Exercise #2
Lecture 115 Hands-On Exercise #3
Lecture 116 Hands-On Exercise #4
Lecture 117 Hands-On Exercise #5
Lecture 118 Hands-On Exercise #2
Section 16: Functions – Lookup & Reference
Lecture 119 Overview
Lecture 120 VLOOKUP
Lecture 121 HLOOKUP
Lecture 122 INDEX
Lecture 123 MATCH
Lecture 124 CHOOSE
Lecture 125 TRANSPOSE
Lecture 126 ROW(S) COLUMN(S)
Lecture 127 References
Section 17: Exercises – Ninja Level 9
Lecture 128 Hands-On Exercise #1
Lecture 129 Hands-On Exercise #2
Lecture 130 Hands-On Exercise #3
Lecture 131 Hands-On Exercise #4
Section 18: Functions – Information
Lecture 132 INFO
Lecture 133 CELL
Lecture 134 ISEVEN & ISODD
Lecture 135 NA & ISNA
Lecture 136 ISERROR & ISERR
Lecture 137 Checking Contents 1
Lecture 138 Checking Contents 2
Lecture 139 Top 10 Functions
Section 19: Exercises – Ninja Level 10
Lecture 140 Hands-On Exercise #1
Lecture 141 Hands-On Exercise #2
Lecture 142 Hands-On Exercise #3
Lecture 143 Hands-On Exercise #4
Section 20: Full Completion
Lecture 144 Overview
Lecture 145 Custom Views
Lecture 146 Conditional Formatting
Lecture 147 Objects & Equations
Lecture 148 Selection Pane
Lecture 149 Translating
Lecture 150 Proofing
Lecture 151 Insights
Section 21: Exercises – Ninja Level 11
Lecture 152 Hands-On Exercise #1
Lecture 153 Hands-On Exercise #2
Lecture 154 Hands-On Exercise #3
Lecture 155 Hands-On Exercise #4
Lecture 156 Hands-On Exercise #5
Lecture 157 Hands-On Exercise #6
Section 22: Office 365
Lecture 158 Cloud Based Apps
Lecture 159 MS Office vs Office 365
Lecture 160 Functions and Charting
Lecture 161 VLOOKUP
Section 23: Exercises – Ninja Level 12
Lecture 162 Hands-On Exercise #1
Lecture 163 Hands-On Exercise #2
Section 24: Google Drive
Lecture 164 Introduction
Lecture 165 Functions & Charting
Lecture 166 VLOOKUP
Section 25: Exercises – Ninja Level 13
Lecture 167 Hands-On Exercise #1
Lecture 168 Hands-On Exercise #2
Section 26: Good To Know
Lecture 169 Protecting Yourself Online
Lecture 170 Scrolling Sheets
Lecture 171 File Extensions
Lecture 172 Ethnocentricity
Lecture 173 Where We’ve Been
Section 27: Congratulations
Lecture 174 Congratulations
Lecture 175 Bonus lecture
This course is for individuals who already have a basic understanding of Microsoft Excel.
Homepage
https://www.udemy.com/course/excel-courses/
DOWNLOAD FROM RAPIDGATOR.NET
DOWNLOAD FROM RAPIDGATOR.NET
DOWNLOAD FROM RAPIDGATOR.NET
DOWNLOAD FROM RAPIDGATOR.NET
DOWNLOAD FROM UPLOADGIG.COM
DOWNLOAD FROM UPLOADGIG.COM
DOWNLOAD FROM UPLOADGIG.COM
DOWNLOAD FROM UPLOADGIG.COM
DOWNLOAD FROM NITROFLARE.COM
DOWNLOAD FROM NITROFLARE.COM
DOWNLOAD FROM NITROFLARE.COM
DOWNLOAD FROM NITROFLARE.COM