Udemy: Complete Excel Bootcamp: Zero to Hero in Excel

Date: March 2022
Author: Jose Portilla

Size: 7.2 GB
Format: MP4

::Katfile::
https://katfile.com/j90o0ujjkmmr
https://katfile.com/0t6acss0fxwe
https://katfile.com/t0xepzau60ry
https://katfile.com/gbbqmfh6nlms

::Uploadydl::
https://uploadydl.com/zt2zhohumr5i
https://uploadydl.com/m8jo7clckz0p
https://uploadydl.com/5foeh4l53ut0
https://uploadydl.com/3j9lkbclmdqh

What you'll learn
Go from Zero to Hero in Excel
Explore the core functions that make you an Excel wizard
Understand List Operations and Logical Functions in Excel
Create functions with Math, Text, and Date operators inside of Excel
Get lifetime access to advanced template spreadsheets and projects
Automate your workflow with efficient Excel tricks
Explore advanced functionality in Excel, such as Pivot Tables and Macros
Learn about Linear Optimization and Solver within Excel


Course content

Introduction
 Welcome to the Course!
 FAQ - Article Lecture
 Housekeeping

Excel Setup and Basics
 Excel Versions
 Excel Interface
 The Workbook
 Anatomy of an Excel Cell

Common Actions in Excel
 Common Actions - Part One
 Common Actions - Part Two
 Common Actions - Part Three
 Common Actions - Exercise Set One
 Common Actions - Exercise Set One - Solutions
 Common Actions - Part Four
 Common Actions - Part Five
 Common Actions - Exercise Set Two
 Common Actions - Exercise Set Two - Solutions
 Common Actions - Part Six
 Common Actions - Part Seven
 Common Actions - Part Eight
 Common Actions - Exercise Set Three
 Common Actions - Exercise Set Three - Solutions

References and Functions
 Cell References - Part One
 Cell References - Part Two
 Common Functions
 References and Functions - Exercise
 References and Functions - Exercise - Solutions

List Operations
 List Operations - Part One
 List Operations - Part Two
 List Operations - Exercise
 List Operations - Exercise - Solutions

Logical Functions
 Logical Functions - Part One
 Logical Functions - Exercise Set One
 Logical Functions - Exercise Set One - Solutions
 Logical Functions Part Two
 Logical Functions - Exercise Set Two
 Logical Functions - Exercise Set Two - Solutions

Lookup Functions in Excel
 Lookup Functions - Part One
 Lookup Functions - Part Two
 Lookup Functions - Exercise
 Lookup Functions - Exercise Solutions

Excel Text Functions
 Text Functions
 Text Functions - Exercise
 Text Functions - Exercise - Solutions

Excel Math Functions
 Math Functions
 Math Functions - Part Two
 Math Functions - Exercise
 Math Functions - Exercise - Solutions

Date Functions in Excel
 Date Functions - Part One
 Date Functions - Part Two
 Date Functions - Exercise
 Date Functions - Exercise Solution