Become an Excel expert! From basic spreadsheets to advanced data analysis, automation, and dashboards.
Sub Category
- Microsoft
{inAds}
Objectives
- Overview of Microsoft Excel Interface
- Workbook and Worksheet Management
- Basic Formatting Techniques
- Saving and Printing Workbooks
- Basic Formulas (SUM, AVERAGE, MIN, MAX)
- Relative, Absolute, and Mixed References
- Logical Functions (IF, AND, OR, NOT)
- Text Functions (LEFT, RIGHT, MID, CONCATENATE, TEXTJOIN)
- Date and Time Functions (TODAY, NOW, DATEDIF, EOMONTH)
- Sorting and Filtering Data
- Data Validation and Drop-Down Lists
- Conditional Formatting
- Using Slicers and Timelines
- Subtotals and Grouping Data
- Descriptive Statistics with Data Analysis Toolpak
- Scenario Manager, Goal Seek, and Data Tables
- Creating and Formatting Charts (Column, Line, Pie, Bar, Area)
- Advanced Charts (Combo Charts, Sparklines, Waterfall)
- Lookup Functions (VLOOKUP, HLOOKUP, INDEX, MATCH, XLOOKUP)
- Array Formulas and Dynamic Arrays (SEQUENCE, FILTER, SORT)
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)