• Excel Start Screen The Ribbon (Customization and Developer Tabs)
• Tabs, Groups, Commands, Dialog Box Launcher ,Quick Access Toolbar
• File Tab (Backstage View),Excel Options, Views and Zooming, Keyboard Shortcuts
• Workbook Windows, Document Inspector, File Formats, Compatibility and Versions

• Using auto formatting option for worksheets
• Using conditional formatting option for rows, columns and cells
• Protecting and un-protecting worksheets
• Using slicers with table
• Cells Formatting, create and modify table

• Naming Cells and Ranges
• Use Excel Names, Create a Dynamic Named Range
• Use a Named Excel Table, Dynamic Named Range Based on Formula

• Relative Reference, Absolute Reference
• Using cell references with multiple worksheets

• Highlighting Cells Rules
• Top/Bottom Rules
• Data Bars, Icon Sets, Color Scales
• Editing Standard Formatting Rules
• Using Formulas in Conditional Formatting

• Creating Pivot tables
• Formatting and customizing Pivot tables
• Using advanced options of Pivot tables
• Pivot charts, Creating Slicers
• Viewing Subtotal under Pivot
• Consolidating data from multiple sheets and files using Pivot tables
• Importing Pivot Table Data
• Calculated Fields in Pivot Tables
• Creating Custom Pivot Tables Styles

• Filtering data for selected view (AutoFilter)
• Using advanced filter options

• Sorting table
• Using multiple-level sorting
• Using custom sorting

• Creating subtotals
• Multiple-level subtotals
• Outlining and Grouping Data

• Exploring Scenarios
• Goal Seek and Data Tables
• Using Solver

• VlookUP with Exact Match, Approximate Match
• HlookUP with Exact Match, Approximate Match
• Nested VlookUP with Exact Match
• VlookUP with Tables, Dynamic Ranges
• Nested VlookUP with Exact Match
• Using VLookUP to consolidate Data from Multiple Sheets

• Consolidating data from multiple sheets and files
• Using data consolidation feature to consolidate data
• command on multiple ranges to calculate sums, averages, products, minimum and maximum values

• Text to Columns
• Flash Fill
• Remove Duplicates

• Specifying a valid range of values for a cell
• Specifying a list of valid values for a cell
• Specifying custom validations based on formula for a cell
• drop Down list, prevent duplicates entries, product Codes, Reject invalid dates

• Using Charts, Formatting Charts, Using 3D Graphs
• Trend lines, Error Bars, Using Bar and Line Chart together
• Using Secondary Axis in Graphs
• Sharing Charts with PowerPoint / MS Word, Dynamically
• (Data Modified in Excel, Chart would automatically get updated)

• Creating Sparkline
• Editing Sparkline

• DATE, TIME, DATEVALUE, TIMEVALUE
• Now, Today, Hour, Minute Second
• Day, month, year, weeknum, weekday
• EDATE, EOMONTH, WORKDAY, WORKDAY.INTL, DAYS, DAYS360
• NETWORKDAYS, NETWORKDAYS.INTL, YEARFRAC
• PMT function, Dollar Function, CUMIPMT function

• And, False, IF, If error
• Ifna, Ifs, not, or

• Using Error Functions
• Using Logical Functions
• Using Array Formulas
• Using Rounding Functions

• average, median, mode, large, max, min
• percentile, quartile, rank, small
• average if, averageifs, count, correl

• CLEAN, trim, lower, proper, upper, concatenate
• Left, right, mid, right, rept, text
• Len, find, search, exact, t, char, code, replace, substitute

• Starting the Visual Basic Editor
• Using the Project Explorer
• Using the Properties Window
• Creating, Importing and Exporting Modules
• Explore Recorded Macros

• Creating Sub and Function Procedures
• Declare and Use Variables
• Displaying Message to the User
• Getting Input from the User

• Creating a Custom Form
• Adding Form Controls
• Creating Event Procedures

There are no specific prerequisites for this course. Basic familiarity with Microsoft Excel and a keen interest in mastering advanced Excel functions and data analysis techniques are beneficial.

Our course equips you with advanced Excel skills such as complex formulae, data analysis, visualization, and automation. These skills are highly sought-after in finance, accounting, MIS, and other sectors, enhancing your career prospects and job readiness.

The course is taught by experienced professionals with extensive knowledge of Excel and practical industry experience. They provide hands-on training and valuable insights into using Excel effectively in real-world scenarios.

You will receive comprehensive course materials, including presentations, practice exercises, and case studies. Additionally, you'll have lifetime access to updated course content and resources to support continuous learning.

Yes, the course includes practical sessions where you'll apply your skills to real-world data sets and scenarios. This hands-on experience is crucial for reinforcing learning and gaining confidence in using Excel for professional tasks.

Yes, upon successful completion of the course and projects, you will receive a professional certification from Hrishi Computer Education. This certification validates your skills and enhances your credibility in the job market.

Yes, we provide job placement assistance to help you secure career opportunities after completing the course. This includes internship opportunities, interview preparation, and guidance in job applications within the Excel domain.

You can enroll in the course by visiting our website Hrishi Computer Education and filling out the enrollment form. For further assistance, you can contact our admissions team directly.