Contents for Advanced Excel Workshop

1.  Contents for Advanced Excel Workshop

• Workshop Title: Advanced Excel & AI Tools: Full-day Session
• Format: Available Offline and Online.
• Objective: Equip participants with advanced Excel skills.
• Duration: Full-day immersion with hands-on exercises.
• Flexibility: Choose between offline or online participation.

          This workshop provides a focused, full-day exploration of Advanced Excel & AI Tools 

features for enhanced spreadsheet proficiency

• Content Highlights:

Advanced Excel Contents [Two Days Workshop]

    Go Back on All Workshop Page

SL No	Name	Categories	Description
1	Flash Fill	Fill	Fills data based on recognized patterns, saving time on repetitive tasks.
2	Paste Special	Paste	Pastes data in specific formats for more control over the operation.
3	Power of Clip Board	Copy & Paste	Stores multiple copied items for easy pasting.
4	Goal Seek	Optimization	Finds input values to achieve desired results in formulas.
5	CTRL Enter Function	Go to Special	Fills selected cells with the same data or formula quickly.
6	Filter by Slicer	Visualization	Visual tool for filtering data in PivotTables or Excel tables.
7	Conditional Formatting	Highlighting	Applies formatting based on cell values or conditions.
8	Pivot Table key features	Data summarization	Summarizes and analyzes large data sets interactively.
9	Power Query	Data transformation	Transforms, cleans, and loads data from various sources.
10	Macro recording	Automation	Records actions to automate repetitive tasks.
11	Sort By Colour	Categorization	Sorts data based on cell, font, or conditional formatting color.
12	Data from Image to Text	Text recognition	Converts text from images to editable text using OCR.
13	Analyze Data in Pivot table	Data Analysis	Analyzes data sets, creates trends, and performs calculations in Pivot Tables.
14	PPT by Artificial Intelligence	AI-powered PPT	AI tools that generate PowerPoint presentations from inputs.
15	PPT by Office 365 Version	Office 365 PPT	Enhanced PowerPoint features with AI design suggestions and collaboration tools.
16	Create Index - VBA	Indexing	Automates index creation in documents using VBA.
17	Short Keys	Keyboard Shortcut	Quick keyboard shortcuts for tasks.
18	Object Alignment	Alignment	Aligning objects for consistency.
19	Transpose Function	Transpose	Switching rows and columns in data.
20	Check Box Locking	Selection	Preventing changes to checkbox status.
21	Sequence Function	Ordering	Creating a sequence of numbers/data.
22	Dynamic Screenshot	Capture	Capturing real-time screen images.
23	IF & IFS	Logical	Evaluates conditions and returns the first TRUE result.
24	IFERROR	Logical	Returns a custom value if an error occurs; otherwise, returns the formula result.
25	IFNA	Logical	Returns a custom value if #N/A, otherwise returns the original value.
26	SWITCH	Logical	Evaluates an expression against a list of values and returns a corresponding result.
27	LEN	Text	Returns the length of a text string.
28	TRIM	Text	Removes extra spaces from text.
29	CONCAT, TEXT JOIN	Text	Joins multiple text strings together (replaces CONCATENATE in Office 365).
30	TEXT	Text	Formats numbers as text.
31	VLOOKUP	Lookup & Reference	Searches for a value in the first column and returns a corresponding value.
32	HLOOKUP	Lookup & Reference	Searches for a value in the first row and returns a corresponding value.
33	XLOOKUP	Lookup & Reference	Searches a range for a value and returns a corresponding result.
34	FILTER	Lookup & Reference	Returns filtered results based on conditions.
35	SORTBY	Lookup & Reference	Sorts a range based on another range’s values.
36	SUMIF	Mathematical	Adds numbers based on a condition.
37	SUMIFS	Mathematical	Adds numbers based on multiple conditions.
38	ABS	Mathematical	Returns the absolute value of a number.
39	MOD	Mathematical	Returns the remainder of a division.
40	YEARFRAC	Date & Time	Returns the difference between two dates in years.
41	COUNTA	Statistical	Counts the number of non-empty values in a range.
42	COUNTIF	Statistical	Counts values based on a condition.
43	COUNTIFS	Statistical	Counts values based on multiple conditions.
44	RANK	Statistical	Returns the rank of a value in a dataset.
45	100 Prints in a click	Print out	Returns the most frequently occurring number in a dataset.

Thank you