Basic/Advanced Excel

Basic understanding of entering data into cells, columns, and rows.

Changing font styles, sizes, and colors.Adjusting cell alignment and applying basic formatting.

Using basic formulas such as SUM, AVERAGE, COUNT, and simple arithmetic operations.Understanding cell references (absolute and relative).

Sorting data alphabetically or numerically.Applying filters to organize and analyze data.

Creating simple charts like bar charts, line charts, and pie charts.

Using functions like IF, VLOOKUP, and HLOOKUP.Understanding the basics of logical functions.

Adjusting page layout settings. Printing worksheets and workbooks.

Applying data validation rules to ensure data accuracy.

Inserting, deleting, and renaming worksheets. Basic navigation between worksheets.

Understanding the difference between relative, absolute, and mixed cell references.

Working with advanced functions like INDEX, MATCH, OFFSET, and array formulas. Mastering nested functions.

Creating PivotTables for data analysis and summarization. Using PivotTable features like grouping, calculated fields, and slicers.

Creating dynamic and interactive charts. Using advanced chart features such as trendlines and dual-axis charts.

Using tools like Data Tables, Scenario Manager, and Solver for advanced data analysis and decision-making.

Applying advanced conditional formatting rules. Using formulas for conditional formatting.

Importing and transforming data using Power Query. Building data models and performing advanced analysis with Power Pivot.

Automating repetitive tasks with macros.

Consolidating data from multiple worksheets or workbooks. Conducting advanced data analysis using statistical functions.

Using custom formulas for data validation. Implementing drop-down lists and dependent validation.

Creating and using dynamic named ranges for flexible data references.