Master Excel from the basics to advanced tools — learn formulas, functions, charts, and data analysis step by step.
Sub Category
- Microsoft
{inAds}
Objectives
- Overview of Excel's Interface
- Understanding Ribbons, Tabs, and Menus
- Navigating Excel
- Using Cells, Rows, and Columns
- Understanding The Excel Grid System
- Entering and Editing Data
- Copying, Cutting, and Pasting Data
- Font Styles, Colors, and Cell Alignment
- Applying Borders and Shading
- Performing Basic Calculations (SUM, AVERAGE)
- Using AutoFill and Flash Fill
- Sorting and Filtering Data
- Grouping and Ungrouping Worksheets
- Logical Functions (IF, AND, OR)
- Lookup and Reference Functions (VLOOKUP, HLOOKUP, XLOOKUP)
- Working With TODAY, NOW, and DATE Functions
- Using LEFT, RIGHT, MID, CONCAT, and TEXT
- Visualizing Data with Pivot Charts
- Creating Dropdown Lists
- Using Goal Seek, Data Tables, and Scenario Manager
- Column, Line, and Pie Charts
- Customizing Chart Elements and more
Pre Requisites
- You only need access to Microsoft Excel (Office 365, 2019, 2021 or recommended) and a computer.
- No microsoft excel experience needed
FAQ
- Q. How long do I have access to the course materials?
- A. You can view and review the lecture materials indefinitely, like an on-demand channel.
- Q. Can I take my courses with me wherever I go?
- A. Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
{inAds}
Coupon Code(s)