Last updated 12/2020
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz
Language: English | Size: 4.71 GB | Duration: 13h 1m
Master pivot tables, formulas, macros, vba, data analysis and learn how to land your first job as an Excel expert!
What you’ll learn
Learn to master Excel from A-Z
How to become a professional Data Analyst
How to be a better, faster, stronger Excel user
How to land your first job as an Excel Expert
How to save hours of time and boost your productivity in Excel
How to find a value with VLOOKUP, HLOOKUP, INDEX, MATCH
How to use math, statistical, logic and text functions
How to use VBA and Macros
How to use VLOOKUP/HLOOKUP in formulas
How to create basic and advanced formulas
Mastering Pivot Tables
Creating Charts from your data
Requirements
basic computer skills
Description
Welcome to the Learn Microsoft Excel from A-Z: Beginner To Expert CourseIn this practical, hands-on course our main objective is to give you the education not just to understand the ins and outs of Microsoft Excel, but also to learn exactly how to master pivot tables, formulas, macros, vba, data analysis, and how to land your first job as an Excel expert!This course will fully prepare you for virtually any Excel related career path, including those that require advanced skills with this software. Once you complete the course, you’ll have access to the full functionality of Excel, and will know how to use all formulas, functions, and capabilities.You’ll also learn about calculating depreciation, calculating interest, and even calculating EMI for loans, all by using Excel functions. The course also features information on INDEX and MATCH functions as well as using the CHOOSE formula, and how to create special charts.Whether you are brand new to the world of Excel, or you have training and knowledge of the software and are looking to improve your skills, this masterclass will take you to the next level. By the time you finish the beginner, intermediate and advanced portions, you too will be an expert in Excel.We understand that theory is important to build a solid foundation, we understand that theory alone isn’t going to get the job done so that’s why this course is packed with practical hands-on examples that you can follow step by step. Even if you already have some experience, or want to learn about the advanced features of Excel, this course is for you!Together we’re going to give you the foundational education that you need to know not just on how to use Excel at an expert level, but also how to get paid for your newly developed skills.The course covers 4 main areas:1: INTRO TO EXCELThis intro section gives you a full introduction to Microsoft Excel, the data analyst industry and marketplace, job opportunities and salaries, and the various Excel-related job roles.Intro to Microsoft ExcelExcel Industry and MarketplaceExcel Job OpportunitiesGetting Started with ExcelExcel Functions2: INTERMEDIATE EXCELThis section gives you a full introduction to the Intermediate Excel functions with hands-on step by step training.Data VisualizationDatasetsDatabasesData ValidationPivotTablesConditional FunctionsLookup FunctionsFormulas, + more!3: EXCEL MACROS & VBAThis section gives you a full introduction to the Excel Macros and VBA with hands-on step by step training.VBA LanguageVBA CodeVBA LoopsMacrosUser Forms4: STARTING AN EXCEL CAREERThis section gives you a full introduction to starting a career as an Excel Programmer with hands-on step by step training.Creating a ResumeFreelancing + Freelance websitesHow To Get Your 1st ClientPersonal BrandingImportance of Having a WebsiteNetworkingBy the end of the course you’ll be a professional Excel programmer and confidently apply for jobs and feel good knowing that you have the skills and knowledge to back it up.
Overview
Section 1: Excel from A-Z Course Introduction
Lecture 1 Excel from A-Z Course Section Overview
Lecture 2 What is Microsoft Excel?
Lecture 3 Who This Course is For
Lecture 4 Microsoft Excel Marketplace
Lecture 5 Microsoft Excel Job Opportunities
Lecture 6 Microsoft Excel Job Types
Section 2: Getting Started with Excel
Lecture 7 Finding & Opening Microsoft Excel
Lecture 8 Excel’s Start Screen
Lecture 9 Explaining the Excel Interface
Lecture 10 Excel Interface Continued
Lecture 11 Excel Workbook vs Excel Worksheet
Lecture 12 Saving & Opening Excel Documents
Lecture 13 Customizing the Excel Quick Access Toolbar
Lecture 14 Customizing the Excel Ribbon
Lecture 15 Excel Shortcut Keys
Section 3: Values, Referencing and Formulas
Lecture 16 Creating Excel Labels
Lecture 17 Entering Numeric Values in Excel
Lecture 18 Formatting Date Values in Excel
Lecture 19 Building Basic Formulas in Excel
Lecture 20 Order of Operations
Lecture 21 Relative vs Absolute Cell References
Section 4: Intro to Excel Functions
Lecture 22 Excel Functions Explained
Lecture 23 The SUM() Function
Lecture 24 The MIN() & MAX() Function
Lecture 25 The AVERAGE() Function
Lecture 26 COUNT() Functions
Section 5: Adjusting Excel Worksheets
Lecture 27 Moving & Copying Data
Lecture 28 Insert & Delete Rows/Columns
Lecture 29 Adjusting the Width & Height of Cells
Lecture 30 Hiding and Unhiding Excel Rows and Columns
Lecture 31 Renaming, Moving & Deleting Excel Worksheets
Lecture 32 Adding Protection to Specific Cells
Lecture 33 Protecting the Structure of a Workbook
Lecture 34 Adding a Workbook Password to Open File
Section 6: Visually Pleasing Cell Formatting
Lecture 35 Formatting Fonts and Cell Background Color
Lecture 36 Adding Cell Borders
Lecture 37 Formatting Data Appropriately
Lecture 38 The Magic behind Excel’s Format Painter
Lecture 39 Creating Styles for Formatting Efficiency
Lecture 40 Merging Cells for a Cleaner Look
Lecture 41 The Power of Conditional Formatting
Section 7: How to Insert Images and Shapes!
Lecture 42 Grab User’s Attention using Illustrations
Lecture 43 Customizing Icons
Lecture 44 Create Compelling Graphics with SmartArt
Section 8: Visualize Data with Charts
Lecture 45 The Commonly used Column Chart
Lecture 46 Changing the Chart Design
Lecture 47 Formatting Elements of a Chart
Lecture 48 Modifying the Data, Type & Location of a Chart
Lecture 49 Little Slice of Pie Charts
Section 9: Excel’s Printing Options
Lecture 50 Print Preview Options
Lecture 51 Excel’s Page Layout View
Lecture 52 Printing a Specific Range of Cells
Lecture 53 Converting Spreadsheets to PDF Files
Section 10: Benefits of Using Excel Templates
Lecture 54 Why Create an Excel Template
Lecture 55 How to Create an Excel Template
Section 11: Working with Excel Datasets
Lecture 56 How to Prepare Data for Analysis
Lecture 57 How to Sort Data in Excel
Lecture 58 Multi-Level Sorting
Lecture 59 Custom Sorting Datasets in Excel
Lecture 60 Applying Filters to Datasets
Lecture 61 Creating Subtotals within a Dataset
Lecture 62 Converting Datasets into Tables
Lecture 63 Finding & Removing Duplicate Values
Section 12: Excel Database Functions
Lecture 64 The SUMIF() Function
Lecture 65 The DSUM() Function
Lecture 66 DSUM() Function Cont.
Lecture 67 The SUBTOTAL() Function
Section 13: Excel Data Validation
Lecture 68 What is Excel Data Validation?
Lecture 69 Creating a Drop Down List with Data Validation
Lecture 70 Different Types of Excel Data Validation
Lecture 71 Adding Custom Alerts to Data Validation
Lecture 72 Creating a Dynamic Drop Down List
Lecture 73 Complex Validation: Dependent Drop Down List!
Section 14: Excel PivotTables
Lecture 74 Creating an Excel Pivot Table
Lecture 75 Modifying Excel PivotTables
Lecture 76 Grouping & Filtering PivotTable Data
Lecture 77 Drilling Down into PivotTable Data
Lecture 78 Creating Pivot Charts & Utilizing Slicers
Section 15: Excel’s PowerPivot Add-In
Lecture 79 What is PowerPivot?
Lecture 80 Activating the Excel PowerPivot Add-In
Lecture 81 Creating Relationships between Data Tables
Lecture 82 Using Data Models to Create PivotTables
Lecture 83 How to Create PowerPivot KPI’s
Section 16: Excel’s Conditional Functions
Lecture 84 Excel’s IF() Function
Lecture 85 IF() Function with AND() Criteria
Lecture 86 IF() Function with OR() Criteria
Lecture 87 Nesting Multiple IF() Functions
Lecture 88 The COUNTIF() Function
Lecture 89 Key Benefits of Named Ranges
Section 17: Excel’s Lookup Functions
Lecture 90 VLOOKUP() Function
Lecture 91 The Beauty of Excel’s IFERROR() Function
Lecture 92 HLOOKUP() Function
Lecture 93 INDEX() Function
Lecture 94 MATCH() Function
Lecture 95 INDEX() and MATCH() Combined
Lecture 96 Two-Way Lookup with INDEX() and MATCH()
Section 18: Text Based Functions in Excel
Lecture 97 LEFT(), RIGHT() and MID() Function
Lecture 98 Extracting Specific Text using LEN() & SEARCH()
Lecture 99 Combining Text with CONCATENATE()
Lecture 100 Quick Tips & Other Text Based Functions
Section 19: Auditing Formulas & Custom Views in Excel
Lecture 101 Tracing Precedents & Dependents in Formulas
Lecture 102 Showing Formulas
Lecture 103 Grouping Data
Lecture 104 3D Referencing in Formulas
Lecture 105 Utilizing the Watch Window in Excel
Lecture 106 How to Freeze Panes in Excel
Section 20: Excel’s “What If?” Tools
Lecture 107 Excel’s Scenario Manager Tool
Lecture 108 Goal Seek in Excel
Lecture 109 Compare Results with Excel Data Tables
Lecture 110 Solver Tool
Section 21: Welcome to Excel VBA!
Lecture 111 The Power Behind Excel VBA
Lecture 112 A Look Inside the Visual Basic Editor (VBE)
Lecture 113 Recording a Macro
Lecture 114 Saving & Opening a Macro-Enabled Workbook
Section 22: The VBA Language
Lecture 115 Modules and Procedures
Lecture 116 Objects, Methods and Properties
Lecture 117 Excel VBA Variables
Section 23: Writing VBA Code
Lecture 118 Referencing a Range
Lecture 119 InputBox & MsgBox
Lecture 120 Using Variables in VBA Code
Lecture 121 If Then Else Statement
Lecture 122 Worksheet Functions inside VBA
Lecture 123 Creating User Defined Functions
Lecture 124 User Defined Functions within VBA Scripts
Section 24: Important VBA Tools and Logic
Lecture 125 Find Last Row of Data
Lecture 126 Find Last Column of Data
Lecture 127 With Statement
Lecture 128 Debugging & Error Handling
Lecture 129 Debugging & Error Handling Cont.
Section 25: Excel VBA Loops
Lecture 130 For Next Loop
Lecture 131 Do Until Loop
Lecture 132 For Each Loop
Section 26: Triggering Macros
Lecture 133 Assigning Macros to Shapes
Lecture 134 Form Controls vs ActiveX Controls
Lecture 135 Worksheet Events
Lecture 136 Workbook Events
Lecture 137 Fun with VBA Events!
Section 27: Excel User Forms
Lecture 138 Creating an Excel UserForm
Lecture 139 Adding Controls to UserForms
Lecture 140 How to Show an UserForm
Lecture 141 Passing TextBox Values to Desired Cells
Lecture 142 Passing Option Buttons to Desired Cells
Lecture 143 UserForm ComboBoxes
Lecture 144 Clearing Values from UserForm Controls
Lecture 145 How to Close an UserForm
Lecture 146 UserForms and Protected Sheets
Section 28: Starting a Career in Excel
Lecture 147 Creating an Excel Resume
Lecture 148 Getting Started with Freelancing
Lecture 149 How to Become an Excel Freelancer
Lecture 150 Top Freelance Websites
Lecture 151 How to Get Your First Client
Lecture 152 Personal Branding
Lecture 153 Networking Do’s and Don’ts
Lecture 154 Importance of Having a Website
Students who want to learn and master microsoft excel
Homepage
https://www.udemy.com/course/microsoft-excel-from-a-z/
DOWNLOAD FROM RAPIDGATOR.NET
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 UPLOADGIG.COM
DOWNLOAD FROM NITROFLARE.COM
DOWNLOAD FROM NITROFLARE.COM
DOWNLOAD FROM NITROFLARE.COM
DOWNLOAD FROM NITROFLARE.COM
DOWNLOAD FROM NITROFLARE.COM