Udemy – Microsoft Excel – Advanced Excel Formulas & Functions 2020-3

Description

Microsoft Excel - Advanced Excel Formulas & Functions Excel video tutorial with formulas and functions from Udemy site. This course will give you an in-depth understanding of advanced Excel formulas and functions that transform you from a basic application to a powerful and dynamic analysis tool. While most Excel courses simply focus on each of the formulas, the instructor uses manuals and examples designed to show why these formulas are useful and how they can be used in different ways. Kurd, teaches the course.

Microsoft Excel Course Features - Advanced Excel Formulas & Functions

Learn to write powerful and dynamic formulas

Automate, simplify complete changes to your workflow with Excel

Build formulas to analyze dates, text fields, values, and arrays

Easy creation of dynamic tools and excel dashboards for filtering, displaying and analyzing data

Elaborate and unique tips, tools and case studies that you can not find in any course

Advanced Excel Formulas course specifications:

Duration: 08:05:19

English language

Number of lessons: 105 lessons

Movie format: AVC 1280 720

Audio: AAC 48KHz 2ch

Instructor: Chris Dutton

Advanced Excel Formulas course topics

Course content 105 lectures 08:05:19

Getting Started 4 lectures 07:25

Excel Formulas 101 12 lectures 01:21:38

Conditional Statements & Logical Operators 8 lectures 30:56

Common Excel Statistical Functions 11 lectures 01:01:21

Lookup & Reference Functions 20 lectures 01:48:35

Text Functions 10 lectures 35:26

Date & Time Functions 11 lectures 48:24

Formula-Based Formatting 7 lectures 24:34

Array Formulas 15 lectures 50:11

Extra Bonus Functions 5 lectures 35:22

Wrapping Up 2 lectures 01:25

Prerequisite

Microsoft Excel 2007 – 2019 or Office 365 (Some features may not be available in earlier versions)

Experience with formulas is recommended, but not required (we’ll review some of the fundamentals)

Installation

After Extract with the required Player.

English subtitle

Quality: 720p

Changes:

Version 2020/3 Compared to 2018/12, 6 lessons and about 1.5 hours have been added.