SigmaWay's Advanced Excel Course

[oaxino]

MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 14 lectures (2h 51m) | Size: 1.8 GB

Teaching intermediate to complex level Excel in an easy to follow way

What you'll learn:
MS- Excel
Pivot Tables
Pivot Charts
VBA
Macros
Lookup Function- Vlookup and Hlookup
Index and Match Function
Advanced MS- Excel with Case based Application

Requirements
Basic Excel Knowledge is Preferable but not Required

Description
Microsoft Excel is a spreadsheet application where we can do graphs, charts, and many other important day to day functions.

But, there are many things in excel which we do not explore.

SigmaWay is here to help you explore the full potential of Microsoft Excel, by teaching you Advanced Excel. Learning the skills of advanced excel can make you stand out in a big crowd.

If you are an employee, researcher, student, or entrepreneur, learning these advanced excel skills will make you a valuable resource in your team. Thinking on these terms, SigmaWay created its Advanced Excel Training, to help everyone unlock the full potential of this common tool and stand out in the crowd.

With Sigmaway's Advanced Excel Training, you will be able to master Core Concepts that will help you solve business problems and help you learn to manage data more efficiently.

The topics covered include.

Advanced Functions and Formulas Like :-

LOOKUP Functions (VLOOKUP/ HLOOKUP)

INDEX and MATCH functions

Excel VBA

Excel Macros

This course is taught through an Industry Case Example, curated to teach students how to:-

Analyze business problems

Understand how data is manipulated and Cleaned

Application of techniques to find insights from data

Visualize Data

Set Up Auto-Updating Features using Macros

And More..

Please take your time and enjoy learning with us @ SigmaWay!!

Who this course is for
Management Consultants
Analysts
Students
Business Students
Professionals
Freshers
Those wanting to Upskill

Download link:

Contenido oculto. Ha de estar registrado, y pulsar el botón "Gracias" para visualizar sus enlaces de descarga.
Si trás registrarse todavía no visualiza el botón de "gracias", pulse la tecla F5, para refrescar la página.