Mastering Advanced Excel

Take your Excel skills to the next level!

Instructor: Er. Shakshi Verma

Language: Hinglish

Validity Period: 365 days

₹2999 79% OFF

₹625

Available on website | android

Description
Course Content
How to Use

Description:

Mastering Advanced Excel is a comprehensive course that dives deep into the advanced functionalities and features of Excel. From complex formulas and macros to data analysis and visualization techniques, this course equips you with the skills to become an Excel power user.

Key Highlights:

Advanced Excel formulas
Macro automation
Data analysis techniques

What you will learn:

Advanced Formulas
Learn how to use array formulas, lookup functions, and other advanced formula techniques.
Macro Automation
Discover how to automate repetitive tasks and streamline your workflow using VBA macros.
Data Analysis
Master data analysis techniques such as pivot tables, data validation, and advanced charting.

Reviews

Load More Reviews

Other Courses


	Introduction to Advanced Excel
		Various Selection Technique
		Shortcut keys
		Introduction
		Introduction
		References
	Customizing Excel
	Using Basic Functions
		Reference (Absolute , Mixed and Relative )
		Practical overview
		using functions-Sum, Average, Max, Min, Count, Counta, Countblank etc.
	Formatting
		Currency Format
		Format Painter
		Formatting Dates
		Formatting cells with Number Formats, Font Formats, Alignments, Borders etc..
		practical overview
	Mathematical functions
		ABS, INT, SUM, SUMPRODUCT, MIN, MAX, AVERAGE, EVEN, ODD,ISEVEN, ISODD, ROUND, ROUNDUP, ROUNDDOWN, AVERAGEIF, AVERAGEIFS, POWER, TRUNC, SUMSQ, RANDBETWEEN.
		SUMIF, SUMIFS, COUNTIF, COUNTIFS
		Practical overview with multiple example
	Database Functions
		DSUM, DMAX, DMIN,DAVERAGE,DCOUNT etc.
		Practical overview
	Text Functions
		TEXT FUNCTIONS ( UPPER, LOWER, PROPER, LEFT, RIGHT, MID, FIND,SEARCH, TRIM, LEN ,CODE, CHAR, TEXT )
		CONCATENATE, CONCAT, TEXTJOIN with examples
		CHAR, CODE, DOLLAR, EXACT, FIXED etc. TEXT FUNCTIONS
	Date and Time Functions
		TODAY, NOW, DAY, DAYS360, MONTH, DAY, YEAR, DATE, DATEDIF, MINUTE, HOUR, SECOND, TIME, EDATE, EOMONTH, WEEKDAY, NETWORKDAYS, NETWORKDAYS.INTL, WORKDAY, WORKDAY.INTL
		Practical overview
	Logical functions
		IF AND Nested IF WITH MULTIPAL EXAMPLES
		Practical overview with multiple different different types conditions
		Logical LET, IFS,SWITCH and XOR functions
		Switch, LET and IFNA logical function
	Conditional Formatting
		All basic rules
		Creating New Rules
		Managing Created Rules by Various logical functions
		Practical overwiew
	Financial Functions
		PMT, IPMT, PPMT, PV, FV
	Data Validations
	Lookup functions
		LOOKUP, VLOOKUP,HLOOKUP,XLOOKUP
		ROW, ROWS, COLUMN, COLUMNS
		HYPERLINK, TRANSPOSE,CONVERT
		OFFSET, UNIQUE, INDEX,MATCH
		practical overview
	Sort and Filter
		Practical overview
	Page Setup and printing workbook
	Defined Names and Formula Auditing
		Practical overview
	Protecting Excel
		Protection of workbook and Worksheets of Excel
		Unprotect Excel sheet without password
	Concatenate, &(ampersand), Concat, Textjoin.
		Practical overview
	Advance paste tools and techniques
	Pivot table
		Charts (Line chart, Pie chart, Bar chart, Area chart etc.)
		Slicers
	Interactive dashboards
	Types of data base
		Introduction of SCALC and Google Spreadsheet
	Power query
		split column and add column in power query
		group
		Unpivot Data
		Append Query (with multiple sheet)
		Merge Query
	All AI functions of excel
		AI.ASK, AI.TABLE, AI.EXTRACT, AI.FILL, AI.TRANSLATE etc.
	Macros
		Use of relative reference
		Basic Macros
	Automating our basic task by buttons using VBA
	Important Add-ins of excel

You may also be interested in

Mastering Advanced Excel

₹625