Rating 4.12 out of 5 (8 ratings in Udemy)
What you'll learn- Use Microsoft Excel to make calculations
- Understand ranges in Excel
- Use formulas in Excel
- Work with relative and absolute references
- Understand functions in Excel
- Understand highlighting and how to work with it
DescriptionMicrosoft Excel is a very useful tool that is widely used for many purposes including calculations, data analysis, data visualizations, creating tables and organizing data and records. This course teaches …
Rating 4.12 out of 5 (8 ratings in Udemy)
What you'll learn- Use Microsoft Excel to make calculations
- Understand ranges in Excel
- Use formulas in Excel
- Work with relative and absolute references
- Understand functions in Excel
- Understand highlighting and how to work with it
DescriptionMicrosoft Excel is a very useful tool that is widely used for many purposes including calculations, data analysis, data visualizations, creating tables and organizing data and records. This course teaches students the basics of Microsoft Excel. In this course we will navigate through excel rows and columns; we will see what is a cell and a cell address. Next we will talk about ranges and how to define them. After that, we will introduce formulas and how to use them. Next, we will learn about relative and absolute references and their usage with operators. then, we will introduce the most commonly used functions in excel such as the sum function, the average function, the Min and Max functions, and some useful string functions such as Left, Right, and Concatenate. finally, we will learn some highlighting tools in excel that saves much time and effort such as highlighting a complete column, a table, a complete worksheet, specific data such as text, numbers, and formulas. Also you will learn how to highlight blank cells and fill them with data, and how to highlight several sheets. You will have the opportunity to practice on what you have learned through quizzes which I recommend that you try to solve to enforce the skills you learned. Have fun learning!!