Learn Excel from beginner to expert — master formulas, functions, data analysis, and dashboards step by step.
Sub Category
- Microsoft
{inAds}
Objectives
- Introduction to Microsoft Excel
- Ribbon, Tabs, and Toolbars
- Quick Access Toolbar and Status Bar
- Workbook vs. Worksheet
- Text, Numbers, Dates, and Formulas
- Alignment, Font Styles, and Borders
- Highlighting Cells Based on Rules
- Using cell references (relative vs. absolute)
- IF, AND, OR
- Creating and Formatting Tables
- Sorting and Filtering Data
- VLOOKUP, HLOOKUP, XLOOKUP
- CONCATENATE, TEXTJOIN
- LEFT, RIGHT, MID, LEN, FIND
- Using IFERROR and ISERROR
- Creating and Customizing PivotTables
- Grouping and Filtering Data
- Calculated Fields and Items
- Interactive data filtering
- Importing and Transforming Data
- Merging and Appending Queries
- 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)