Advanced MS Excel

Creating Spreadsheets and Editing Features:
Master the basics of spreadsheet creation.
Learn essential editing features to optimize your workflow.

Working with Formulas, Dropdown Lists, and Check Boxes:
Efficiently use formulas to automate calculations.
Add dropdown lists and checkboxes to enhance data entry.

Tables, Charts, and Conditional Formatting:
Organize data using tables and visualize it with charts.
Apply conditional formatting to highlight important data.

Filters, Data Sorting, Data Validation, and Goal Seek:
Utilize filters and data sorting to manage large datasets.
Implement data validation techniques for accurate data entry.
Use Goal Seek to find desired results through iterative calculations.

Pivot Tables:
Create and customize Pivot Tables for powerful data summarization and analysis.

Basic Aggregations:
SUM, SUMIFS, COUNTIFS: Aggregate data with precision.
AVERAGE, MAX, MIN: Calculate averages and extremes.
COUNT, COUNTA: Count numeric and non-numeric data.
ROUND, ROUNDUP, ROUNDDOWN: Adjust numerical precision.

Introduction to Cell Referencing:
Understand Cell Referencing using $.
Learn Absolute, Relative, and Hybrid Referencing for dynamic formulas.
Discover the Benefits of Cell Referencing.

Text Functions:
Manipulate text with functions like UPPER, LOWER, PROPER.
Clean and analyze text using TRIM, LEN, LEFT, RIGHT, MID.
Combine and search text with CONCATENATE, CONCAT, TEXTJOIN, SEARCH, FIND.
Replace and substitute text with SUBSTITUTE, REPLACE.

Date Functions:
Work with dates using functions like TODAY, DAY, MONTH, YEAR, DATE.
Utilize WEEKDAY, WEEKNUM, DATEVALUE, EDATE, EOMONTH for advanced date calculations.
Calculate business days and differences with NETWORKDAYS.INTL, WORKDAY.INTL, DATEDIF, DAYS.

Time Functions:
Manage time with NOW, HOUR, MINUTE, SECOND, TIME, TIMEVALUE.

Formatting:
Apply Date and Time Formatting using both custom formatting and formulas.

IF Function:
Implement conditional logic with IF statements, including single and multiple conditions.
Use IF with AND(), IF with OR() for complex scenarios.

Excel Functions:
Explore advanced functions like ABS, CEILING.MATH, FLOOR.MATH, FORMULATEXT, LARGE, SMALL, PERCENTILE, QUARTILE.

VLOOKUP Function:
Master the VLOOKUP function, including handling format issues and errors.
Enhance lookups with MATCH Function and approximate matches.

HLOOKUP Function:
Learn the essentials of HLOOKUP for horizontal lookups.

XLOOKUP Function:
Utilize the XLOOKUP function for modern and versatile lookups.

Pivot Tables:
Create Pivot Tables with proper headers and summarize data using various functions.
Group data by dates, ranges, and text fields for detailed analysis.
Filter data with SLICER and customize value summaries.

New Array Functions:
Leverage new Excel array functions like UNIQUE, SORT, SORTBY, FILTER, SEQUENCE for dynamic data manipulation.

Charts:
Create and edit a variety of Charts.
Enhance charts with graphics and link titles for improved presentation.