• views: 90
• date: 24 May 2024
• posted by: voska89

What you'll learn
Develop Analytical Skills in Data Sorting and Data Filtering
Assess and Audit Formulas used in Microsoft Excel
Develop Pivot Tables and Pivot Charts for Data Analysis
Use Conditional Formatting For Analyzing & Organizing Data
Creating Interactive Dashboards in Excel
Use Formulas with Basic Functions
Master Advanced Functions in Excel
Make Decisions using What If Analysis Tools
Requirements
Basic Computer Navigation Skills
Description
Mastering Microsoft Excel in a unique way of combining different levels of skills. The course is a good foundation for data analysis en-route to skills for Business Intelligence applications. The students will have will guided by steps on how to accomplish a stated objective. At the end of the lecture, there will be some hand-on assignment that the student must attempt to cement the gained knowledge and skills. The training course starts by introducing you to common functionalities of spreadsheet processing which are data sorting, data filtering and then formula auditing. Thereafter, the course presents more data analytical lessons such as pivot tables and pivot charts, interactive excel dashboard with slicers and timelines for interactive data analysis. At the end the course brings the common excel functions and wind up with advanced excel functions. Where there is a video tutorial, the students are encouraged to watch and follow the steps demonstrated in the video. Other topics has bonus tasks, students must make sure they have attempted. In some lessons, there are some challenging tasks which are labelled as 'Diving Deep'. Once a student is able to do and interpret 'diving deep' assignments then definitely the student has reached mastery level for that lesson
Who this course is for
Business Professional; Students and Educators; Employees
Homepage

https://www.udemy.com/course/mastering-microsoft-excel-basics-blended-with-advanced/

   
   
   

Forex Trading

Crypto Trading. 20 USD Bonus after KYC

We need your support!
Make a donation to help us stay online
        
Bitcoin (BTC)
bc1q08g9d22cxkawsjlf8etuek2pc9n2a3hs4cdrld
	
Bitcoin Cash (BCH)
qqvwexzhvgauxq2apgc4j0ewvcak6hh6lsnzmvtkem

Ethereum (ETH)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

Litecoin (LTC)
ltc1qt6g2trfv9tjs4qj68sqc4uf0ukvc9jpnsyt59u

USDT (ERC20)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

USDT (TRC20)
TYdPNrz7v1P9riWBWZ317oBgJueheGjATm

0 1 2 3 4 5

| Print version |

	Information
		Users of GUESTS are not allowed to comment this publication.