Master Excel's data analysis and visualization tools: formulas, functions, charts, and graphs.
Sub Category
- Microsoft
{inAds}
Objectives
- Introduction to Excel Functions and Their Syntax
- Understanding the Basics of Formulas
- Working with Cell References: Relative, Absolute, and Mixed
- Basic Arithmetic Operations in Excel
- Text Functions: CONCATENATE, LEFT, RIGHT, MID
- Logical Functions: IF, AND, OR, NOT
- Date and Time Functions: TODAY, NOW, DATEDIF
- Lookup Functions: VLOOKUP, HLOOKUP, XLOOKUP
- Combining Functions in a Single Formula
- Working with Array Formulas
- Advanced Text Manipulation Functions: TRIM, LEN, SUBSTITUTE
- Using Conditional Functions: SUMIF, COUNTIF, AVERAGEIF
- Statistical Functions: AVERAGE, MEDIAN, MODE, STDEV
- Error Handling Functions: IFERROR, ISERROR
- Creating Basic Charts: Column, Line, Pie
- Customizing Chart Elements: Titles, Labels, and Legends
- Introduction to Sparklines for Data Trends
- Creating Combo Charts for Comparative Analysis
- Advanced Graphical Elements: Data Bars, Color Scales, Icon Sets
- Using Macros to Automate Chart Creation
- Introduction to VBA for Custom Chart Functions
Pre Requisites
- No prior Excel expertise is required, though a basic familiarity with the interface is helpful.
- Microsoft Excel installed on your computer (Excel 2013, 2016, 2019, 2021, or Office 365 recommended).
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)