Microsoft Excel, create basic formulas
The course sets out to make Learning Microsoft Excel easy. Students will use the power of Excel for Data presentation. Excel Interface: This module will provide an overview of the Excel interface, including the ribbon, cells, worksheets, and workbook. Students will learn how to navigate and customize the Excel interface to suit their needs. Learn to hide and unhide columns, rows and use the zoom function. Learn to customize cells, enter data, Basic Formulas: This module will cover basic Excel formulas, including mathematical formulas, text formulas, and logical formulas. Students will learn how to use formulas to perform calculations and manipulate data in Excel. Charts: This module will cover the basics of creating charts in Excel, including bar charts, line charts, and pie charts. Students will learn how to add chart elements such as Chart titles. You will learn to master more formulas such as Percentage, Absolute cell reference and count. You will learn to use multiple formulas and to do a IF statement. Data Management: This module will cover basic data management in Excel, including sorting and filtering data Students will learn how to organize and manage data in Excel. Those who find Excel intimidating will find the step by step instructions useful.
What you’ll learn
- Learn all about the Microsoft Excel Interface.
- Learn to customize cells, rows and columns.
- Learn to create different types of Formulas.
- Learn to create charts.
- Learn more formulas and charts.
Course Content
- Introduction to Microsoft Excel –> 2 lectures • 1hr 8min.
- Navigating and Customizing Excel –> 2 lectures • 41min.
- Create basic formula –> 2 lectures • 43min.
- Creating Charts –> 2 lectures • 44min.
- More formulas –> 2 lectures • 23min.
- More Charts –> 1 lecture • 24min.
Requirements
The course sets out to make Learning Microsoft Excel easy. Students will use the power of Excel for Data presentation. Excel Interface: This module will provide an overview of the Excel interface, including the ribbon, cells, worksheets, and workbook. Students will learn how to navigate and customize the Excel interface to suit their needs. Learn to hide and unhide columns, rows and use the zoom function. Learn to customize cells, enter data, Basic Formulas: This module will cover basic Excel formulas, including mathematical formulas, text formulas, and logical formulas. Students will learn how to use formulas to perform calculations and manipulate data in Excel. Charts: This module will cover the basics of creating charts in Excel, including bar charts, line charts, and pie charts. Students will learn how to add chart elements such as Chart titles. You will learn to master more formulas such as Percentage, Absolute cell reference and count. You will learn to use multiple formulas and to do a IF statement. Data Management: This module will cover basic data management in Excel, including sorting and filtering data Students will learn how to organize and manage data in Excel. Those who find Excel intimidating will find the step by step instructions useful.