Learning Microsoft Excel | Overview of Microsoft Excel (cells, range, sheets, workbooks, etc.)
Overview of Microsoft Excel (cells, range, sheets, workbooks, etc.)
Excel Functions
Excel Charts
Functions are predefined formulas in Excel. They eliminate laborious manual entry of formulas while giving them human-friendly names.
SUM - sum values from multiple cells, or you can also input values directly into the function
COUNT - count of numeric values in a cell
AVERAGE - average of numeric values
DATE - It returns a valid date (date serial number) as per Excel’s time format by using the day, month, and year specified
LEFT - It extracts specific characters from a cell/string starting from the left (start)
RIGHT - It extracts specific characters from a string starting from the right (last)
IF - IF function (tests a condition) returns a value when the specific condition is TRUE and returns another value if that condition is FALSE.
NOW - It returns the current date and time (using your system’s settings) in the cell where you insert it.
VLOOKUP - It looks up a value in a column and can return that value or a value from the corresponding columns using the same row number.
INDEX - The INDEX function below returns a specific value in a one-dimensional range
MATCH - The MATCH function returns the position of a value in a given range
Create a chart in Excel
Change Chart Type in Excel
Switch Row/Column in Excel
Legend Position in Excel
Data Labels in Excel
#excel #microsoftexcel #exceltutorial #excelbeginners
Видео Learning Microsoft Excel | Overview of Microsoft Excel (cells, range, sheets, workbooks, etc.) канала CareerHaven
Excel Functions
Excel Charts
Functions are predefined formulas in Excel. They eliminate laborious manual entry of formulas while giving them human-friendly names.
SUM - sum values from multiple cells, or you can also input values directly into the function
COUNT - count of numeric values in a cell
AVERAGE - average of numeric values
DATE - It returns a valid date (date serial number) as per Excel’s time format by using the day, month, and year specified
LEFT - It extracts specific characters from a cell/string starting from the left (start)
RIGHT - It extracts specific characters from a string starting from the right (last)
IF - IF function (tests a condition) returns a value when the specific condition is TRUE and returns another value if that condition is FALSE.
NOW - It returns the current date and time (using your system’s settings) in the cell where you insert it.
VLOOKUP - It looks up a value in a column and can return that value or a value from the corresponding columns using the same row number.
INDEX - The INDEX function below returns a specific value in a one-dimensional range
MATCH - The MATCH function returns the position of a value in a given range
Create a chart in Excel
Change Chart Type in Excel
Switch Row/Column in Excel
Legend Position in Excel
Data Labels in Excel
#excel #microsoftexcel #exceltutorial #excelbeginners
Видео Learning Microsoft Excel | Overview of Microsoft Excel (cells, range, sheets, workbooks, etc.) канала CareerHaven
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![How to land your dream job | Interview prep hacks](https://i.ytimg.com/vi/gNvIaYDR0do/default.jpg)
![How to get into TECH with ease](https://i.ytimg.com/vi/rdEk3E5Z_w0/default.jpg)
!["Mastering the Art of Interviews: Unlocking the Secrets to Ace Your Next One!"](https://i.ytimg.com/vi/YRcScv0uHko/default.jpg)
![Welcome to Careerhaven | What we do at Careerhaven](https://i.ytimg.com/vi/5EDb6Vo4bhc/default.jpg)
![PowerBI](https://i.ytimg.com/vi/rm3UqtrY070/default.jpg)
![Business Analysis bootcamp at Careerhaven Consulting Inc](https://i.ytimg.com/vi/69gkRRLUqy0/default.jpg)
![Moving to Canada for Nigerians | Traveling abroad for Nigerians | Live video chat](https://i.ytimg.com/vi/iVt8d3bVBEU/default.jpg)
![Data Analysis bootcamp at Careerhaven | Become a Data Analyst](https://i.ytimg.com/vi/AnILQ2IkJa8/default.jpg)
![Welcome](https://i.ytimg.com/vi/MycYSJ5bV6Q/default.jpg)
![Microsoft PowerBI | PowerQuery | Data cleaning](https://i.ytimg.com/vi/d-E7WsfeJ-g/default.jpg)
![Creating Visualizations in PowerBI | Dashboards in PowerBI | 3+ hrs of learning how to create report](https://i.ytimg.com/vi/VB786e4zlNA/default.jpg)
![Dogecoin going crazy](https://i.ytimg.com/vi/2B5L-RXA8Tc/default.jpg)
![Learning Microsoft Excel Part 3 | Creating Dashboard with Excel](https://i.ytimg.com/vi/5CEJiTgpUs0/default.jpg)
![Looking to hire | We have experienced professionals in our Eco-system](https://i.ytimg.com/vi/qe4T57-a6zU/default.jpg)
![Moving to Dubai; Good or Bad](https://i.ytimg.com/vi/P1BtbHwtGmA/default.jpg)
![Learning Microsoft Excel Part 2 | Pivot Table](https://i.ytimg.com/vi/gh3DrMCO50M/default.jpg)
![Canada nature and sounds: Relaxing music and soft rain sounds; relaxing piano music ; rain sounds](https://i.ytimg.com/vi/p1InDXN_dQQ/default.jpg)
![Project Management](https://i.ytimg.com/vi/XZb9VENlQ-4/default.jpg)
![Project Management bootcamp | Become a Project Manager](https://i.ytimg.com/vi/1CIoGdnEeuk/default.jpg)
![Agile/Scrum Training | Become a Scrum Master](https://i.ytimg.com/vi/4GWs75-Y6Vk/default.jpg)