Microsoft Excel Mastery + Complete Formulas & Functions
Video: .mp4 (1280x720, 30 fps(r)) | Audio: aac, 44100 Hz, 2ch | Size: 3.15 GB
Genre: eLearning Video | Duration: 20 lectures (5 hour, 14 mins) | Language: English
Become a Master in Data Analytics using Excel
What you'll learn
Gain Microsoft Excel Mastery for Data Analysis
Navigate, Format and Manage Data in Excel's Workbook and Worksheets
Understand the use of basic Formulas and Functions
Advanced Formulas and Functions
Conditional Analysis and Mathematical Operations
Financial and Statistical Analysis
Use of all Matching and Lookup Formulas
Make Excel's Formulas Error-free
Requirements
The course was created with Microsoft Excel 2019, however, it was carefully created to work in Excel 2010, 2013, 2016 and 2017. So, a basic understanding of Excel will do.
Description
This course aims to provide the student with the requisite knowledge to master Microsoft Excel for data analysis in all areas. Thus, you will be able to enter and edit worksheet data, perform basic worksheet operations, format the worksheets, and even customize the Excel's user interface.
The course provides great insight into using Excel for performing mathematical operations, manipulating texts, working with dates and time, using matching and lookup formulas, performing conditional, financial, and statistical analysis. You will learn how to use advanced formulas and functions for working with the above operations and also make your work in Excel error-free.
Who this course is for:
Beginners and Intermediate Users of Excel
Students who wish to master Microsoft Excel for data analysis
Download link:
Só visivel para registados e com resposta ao tópico.Only visible to registered and with a reply to the topic.Links are Interchangeable - No Password - Single Extraction