Microsoft office 2010 Advance Excel Online Certified Course
Do you have a basic knowledge of excel and want to become an expert in using excel? Well, Your wait is over because we/NIFM brings the best solution in the form of special, easy and unique designed course for you. Get yourself register for our online Advance Level Excel Beginners program and get a perfect command of the different concept of Excel.
NIFM provides you the best Online Courses that help you to upgrade your level from beginner to an Expert. Microsoft office 2010 Advance Excel online Course for Beginners Specially designed in the simple and step by step manner to enhance your knowledge, Skills, and Expertise in all elements of Excel. You can learn through our online Advance Excel course with the example that involves charts design, excel formula, data analysis, and data sorting with the help of filters like color, slicer etc.
MS Excel is a highly used software for office work and it requires in the day to day professional life. It is highly necessary for an office worker to learn the Advance level excel for their personal as well as professional work. NIFM Online MS Excel advance level course delivers the combination of basic, intermediate and advanced level knowledge about the tools required for the development of Excel worksheet.
This course is designed under the guidance of our highly educated, experienced and professional faculty to deliver the best instruction that will help you to improve your understanding and knowledge to transform you from beginner to the professional.
Online Advance Excel certified Course detail Chapters in a stepwise manner to get the result you want in the matter of time. This course includes the detailed chapters of advanced level functionalities, Centering the Worksheet Data, Data validation, Detailed number of excel formula and Excels productive tips.
Why Choose This Advanced Excel Course?
Step-by-step online learning with Hindi instruction.
Covers over 80+ detailed functions from beginner to advanced level.
Learn from industry expert faculty – Ms. Veenika Singh.
Lifetime valid NIFM Certification after completion.
Includes interactive examples, tricks, and productivity shortcuts.
Perfect for students, accountants, analysts, and corporate professionals.
What You’ll Learn in This Course?
This course offers an in-depth, hands-on understanding of Excel tools and techniques:
NIFM Advance Excel Course provides you the complete detail explanation of all command like-
Array,
Conditional Formatting,
Convert Function,
Countif,
Sumif,
Averageif Function,
Match Function,
Mode Function
Vlookup Function
And many more.....
with the help pre-recorded video.
Course Requirements
Computer, Laptop, ipad, tab or mobile phone required with broadband or 4G internet.
Who is this Course for?
Working Professionals
Accountants
Finance Executives
Data Analysts
MIS Executives
Students
Entrepreneurs
Business Owners
Trainers
HR Professionals
Admin Staff
Freelancers
Course Outline
Chapter 1 : Applying Range Names to Formula
Learn how to simplify your complex Excel formulas by assigning range names. This chapter teaches how to define, manage, and apply range names to streamline your data references, making formulas easier to understand and maintain. Perfect for those who want to enhance their productivity and accuracy in spreadsheet management.
1 Videos Available
Chapter 2 : Array
Understand the power of array formulas in Excel. This chapter explains how to perform multiple calculations on data sets efficiently using arrays. You’ll learn practical examples for financial modeling, data analysis, and automation, helping you become faster and more accurate in managing complex data structures.
1 Videos Available
Chapter 3 : Autofill and Custom List
Master the Autofill feature and create your own custom lists to save time in repetitive data entry. This chapter demonstrates how to quickly fill cells with patterns, dates, or formulas and how to create personalized sequences, making your workflow more efficient and error-free.
1 Videos Available
Chapter 4 : Autosum Row and Column Reference
This chapter helps you automate data calculations by using the Autosum function effectively. You’ll learn how to apply it to rows and columns, reference ranges properly, and use shortcuts to calculate totals instantly—ideal for financial and statistical data handling.
1 Videos Available
Chapter 5 : Centering the Worksheet Data
Learn how to make your worksheets more visually appealing by centering data both horizontally and vertically. This chapter covers layout settings, alignment tools, and formatting best practices to ensure your reports look professional and are easy to read.
1 Videos Available
Chapter 6 : Changing Label Orientation
Discover how to rotate and align labels in Excel to enhance data presentation. This chapter walks you through text direction, angle adjustments, and formatting tricks that make your charts and tables more readable and impactful during presentations or reporting.
1 Videos Available
Chapter 7 : Changing Worksheet in One Go
Save time by learning to modify multiple worksheets simultaneously. This chapter teaches grouping techniques and commands to apply formatting, data entry, or formula changes across multiple sheets in one go, helping you work faster and more efficiently.
1 Videos Available
Chapter 8 : Column Label Change in Number Label
Learn how to switch between column labels (letters) and number labels for better data referencing. This chapter covers Excel options that allow you to customize how you view and navigate your worksheets—ideal for large-scale data analysis and reporting.
1 Videos Available
Chapter 9 : Comment Shape
Comments are vital for collaboration. This chapter teaches how to customize, format, and reshape comment boxes to make your notes visually clear and professional. Enhance your teamwork and feedback presentation with advanced comment formatting skills.
1 Videos Available
Chapter 10 : Concatenate
Master the Concatenate function to combine text, numbers, and cell data into a single string. This chapter focuses on text management techniques that make your reports, invoices, and dashboards more dynamic and readable, helping you automate text-based data handling.
1 Videos Available
Chapter 11 : Conditional formating
Learn how to visually highlight important data with Conditional Formatting. This chapter teaches how to use color scales, icons, and data bars to emphasize trends, errors, and outliers. You’ll master the skill of making your spreadsheets visually appealing and easier to interpret for data-driven decision-making.
1 Videos Available
Chapter 12 : Conditional Formatting with Mod Function
Dive deeper into advanced Conditional Formatting using the MOD function. This chapter helps you create customized formatting rules that automatically color alternate rows or highlight periodic data patterns, improving readability and analysis of large data sets effectively.
1 Videos Available
Chapter 13 : Controlling Display of the Scrollbar
Discover how to customize the Excel workspace by managing the display of scrollbars. Learn to hide or show horizontal and vertical scrollbars to optimize visibility while working with large datasets, ensuring better control and cleaner presentation of your worksheets.
1 Videos Available
Chapter 14 : Convert Function
Master the Convert Function in Excel to seamlessly switch between measurement units—like meters to feet or grams to ounces. This chapter makes it simple to handle technical or scientific data, ensuring accuracy and saving time when performing unit conversions.
1 Videos Available
Chapter 15 : Copy Numbers Only
Learn how to copy numeric data without affecting formulas or formatting. This chapter explains special paste options that allow you to extract and replicate pure numerical values, making your data transfer tasks faster and cleaner, especially in reports and summaries.
1 Videos Available
Chapter 16 : Countblank Counta
Understand the difference between COUNTBLANK and COUNTA functions to manage incomplete datasets. This chapter helps you identify missing or non-empty cells easily, improving your data accuracy, analytics, and overall reporting efficiency in Excel.
1 Videos Available
Chapter 17 : Countif, Sumif and Averageif Function
Gain in-depth knowledge of the COUNTIF, SUMIF, and AVERAGEIF functions. This chapter teaches you how to calculate conditional totals, counts, and averages based on specific criteria, enhancing your analytical skills for sales reports, performance data, and trend analysis.
2 Videos Available
Chapter 18 : Create Bar Graph
Learn how to visualize your data using professional bar graphs. This chapter covers step-by-step creation, customization, and formatting of bar charts to effectively represent comparisons and trends—making your data easy to understand and presentation-ready.
1 Videos Available
Chapter 19 : Create Button
Explore interactive Excel design by learning how to create and assign functions to buttons. This chapter teaches how to use Form Controls and Macros to automate repetitive tasks, making your Excel sheets more dynamic and user-friendly.
1 Videos Available
Chapter 20 : Creating Combo Box
Understand the process of adding and configuring Combo Boxes for data input control. This chapter shows how to create drop-down lists that simplify data entry, prevent errors, and enhance interactivity within dashboards and reports.
1 Videos Available
Chapter 21 : Cycle Font Color
In this chapter, you’ll learn how to automatically change and cycle through font colors in Excel to make your data visually engaging. It’s an excellent way to highlight key information dynamically, improving the readability and presentation of dashboards and reports.
1 Videos Available
Chapter 22 : Data Validation
Master the art of controlling data entry in Excel using Data Validation. This chapter teaches how to create rules, drop-down lists, and error messages to ensure accuracy and consistency in your spreadsheets. It’s an essential tool for maintaining clean and reliable data.
1 Videos Available
Chapter 23 : Deleting Graphics When Deleting Rows
Learn how Excel handles graphics and objects when rows or columns are deleted. This chapter focuses on managing embedded images, shapes, and charts efficiently so that your layouts remain consistent and your reports stay organized even after modifications.
1 Videos Available
Chapter 24 : Dependent Dropdown List
Explore how to create dependent drop-down lists in Excel for smarter data entry. This chapter helps you link multiple lists—like selecting a category and then showing related sub-options—making forms, databases, and dashboards more interactive and professional.
1 Videos Available
Chapter 25 : Entered Values are Divided by 100
Understand how to use Excel’s built-in options and formulas to automatically divide entered values by 100. This feature is particularly useful when dealing with percentages, currency formats, and scaling large datasets for better accuracy and reporting.
1 Videos Available
Chapter 26 : Enterkey Behaviour
Learn how to customize the Enter key’s behavior in Excel to improve workflow efficiency. This chapter covers how to control cell navigation direction—down, right, left, or up—making data entry faster and smoother for repetitive tasks.
1 Videos Available
Chapter 27 : Find Search and Mid function
This chapter introduces you to FIND, SEARCH, and MID functions—essential text functions in Excel. You’ll learn how to locate and extract specific characters or words from text strings, ideal for cleaning data, formatting text, or processing bulk information.
1 Videos Available
Chapter 28 : Formula Copy
Understand how to copy and replicate formulas effectively without breaking cell references. This chapter teaches absolute and relative referencing techniques, helping you ensure formula accuracy across multiple worksheets and large data ranges.
1 Videos Available
Chapter 29 : Gride Line Color and Formula Bar Off and On
Learn how to customize Excel’s interface by changing gridline colors and toggling the formula bar. This chapter helps you improve your worksheet visibility and design, especially when preparing professional reports or presentation sheets.
1 Videos Available
Chapter 30 : Hide Graphics
In this chapter, you’ll explore how to hide or show graphics, images, and shapes within a worksheet. Perfect for maintaining a clean workspace while editing or printing reports, this feature enhances your control over Excel’s visual layout.
1 Videos Available
Chapter 31 : Hiding Error On Printout
Learn how to prevent error messages like #DIV/0 or #VALUE! from appearing when printing your Excel sheets. This chapter helps you use error-handling formulas and print settings to maintain clean, professional-looking reports without distractions.
1 Videos Available
Chapter 32 : Hlookup Function
Understand how to use the HLOOKUP function to search for data horizontally across rows. This chapter teaches syntax, parameters, and practical examples to retrieve accurate information efficiently, a must-know for data analysts and financial professionals.
1 Videos Available
Chapter 33 : Hyperlink
Discover how to create and manage hyperlinks in Excel that connect to websites, documents, and specific cells. This chapter focuses on improving navigation and creating interactive reports, dashboards, and presentations seamlessly.
1 Videos Available
Chapter 34 : If, OR, AND Function
Master logical functions in Excel—IF, OR, and AND—to automate data decisions. You’ll learn to create smart formulas that evaluate conditions and return meaningful results, perfect for reporting, filtering, and advanced data analysis.
1 Videos Available
Chapter 35 : Index Function
This chapter explains the INDEX function, which retrieves data from specific rows and columns within a range. You’ll learn how it works alone and in combination with MATCH for efficient and flexible lookups.
1 Videos Available
Chapter 36 : Information Function
Explore the Information Functions in Excel, such as ISERROR, ISBLANK, and ISTEXT. Learn to identify cell types and data formats, improving your formula reliability and accuracy when processing large datasets.
1 Videos Available
Chapter 37 : Insert and Edit Data Multiple Worksheet
Learn how to work across multiple worksheets simultaneously. This chapter demonstrates techniques for inserting, editing, and managing data efficiently in complex Excel workbooks, ideal for project tracking and financial analysis.
1 Videos Available
Chapter 38 : Insert Sheets
Discover how to add and organize new worksheets effectively. You’ll learn shortcut methods, renaming techniques, and sheet management strategies to keep your workbook structured and easy to navigate.
1 Videos Available
Chapter 39 : Insert Total Row
This chapter focuses on adding a Total Row to your tables for quick calculations like SUM, AVERAGE, and COUNT. Learn how to summarize data dynamically and generate instant results for analysis.
1 Videos Available
Chapter 40 : Insert Watermark
Add a professional touch to your reports by inserting custom watermarks in Excel. This chapter guides you through text and image watermark creation for branding, security, and document styling purposes.
1 Videos Available
Chapter 41 : Large and Small Function
Learn how to use LARGE and SMALL functions to identify top or bottom values in datasets. Perfect for ranking, sales performance, or exam score analysis, this feature makes comparative reporting effortless.
1 Videos Available
Chapter 42 : Left and Right Function
Learn how to use LARGE and SMALL functions to identify top or bottom values in datasets. Perfect for ranking, sales performance, or exam score analysis, this feature makes comparative reporting effortless.
1 Videos Available
Chapter 43 : Lookup Formula
Understand how to use Excel’s LOOKUP formula for searching data within one-row or one-column ranges. This chapter builds a foundation for mastering VLOOKUP and HLOOKUP functions effectively.
1 Videos Available
Chapter 44 : Macro Function
Learn to automate repetitive tasks using Excel Macros. This chapter introduces you to recording, editing, and running Macros to save time, improve productivity, and enhance data accuracy.
1 Videos Available
Chapter 45 : Manipulating Objects
Explore how to manage and format objects such as charts, shapes, and buttons. This chapter enhances your visual presentation skills while maintaining structured and professional workbook layouts.
1 Videos Available
Chapter 46 : Match and Index Function
Combine MATCH and INDEX functions for powerful data lookups. This chapter helps you replace VLOOKUP limitations and perform flexible data retrieval with precision.
1 Videos Available
Chapter 47 : Match Function
Learn to use the MATCH function to locate the position of a specific item in a range. This function becomes essential when creating dynamic formulas and database-style Excel sheets.
1 Videos Available
Chapter 48 : Mod Function
Understand how to use the MOD function for remainder calculations. This chapter explores creative uses of MOD in formatting, numbering, and data categorization for professional reports.
1 Videos Available
Chapter 49 : More Text Function
This chapter explores additional text manipulation functions like LEN, TRIM, and SUBSTITUTE. Learn how to clean, structure, and format text data for analysis or reporting.
1 Videos Available
Chapter 50 : Nested If
Master Nested IF statements to evaluate multiple conditions in one formula. You’ll learn how to simplify complex logic for accurate data categorization and decision-making.
1 Videos Available
Chapter 51 : Open a Copy of Workbook
Discover how to open and manage multiple copies of a workbook for testing or review purposes. Ideal for working on parallel versions without affecting original data.
1 Videos Available
Chapter 52 : Pivot Table
Learn how to summarize and analyze large datasets using Pivot Tables. This chapter covers creating, formatting, and customizing Pivot Reports for insightful data presentation.
1 Videos Available
Chapter 53 : Print Comment In Excel
Learn how to print comments alongside your worksheets. This feature is ideal for sharing notes and collaboration details when printing professional reports.
1 Videos Available
Chapter 54 : Print Gridlines and Headings
Understand how to include or exclude gridlines and headings in printouts. This chapter helps create clean and readable hard copies of your data sheets.
1 Videos Available
Chapter 55 : Printing a Draft of Worksheet
Learn how to print draft versions of your worksheet for review. Save ink and time while checking layout and structure before final printing.
1 Videos Available
Chapter 56 : Printing a Portion of Worksheet
This chapter teaches how to print specific areas of a worksheet by setting print areas and ranges. Ideal for reports requiring selective data output.
1 Videos Available
Chapter 57 : Printing Rows Conditionally
Discover how to print specific rows based on conditions. This chapter helps automate selective printouts using logical functions and filters.
1 Videos Available
Chapter 58 : Printing Without Opening Workbooks
Learn a time-saving method to print Excel workbooks directly without opening them. Perfect for batch printing multiple files in professional settings.
1 Videos Available
Chapter 59 : Print Page Number at the Bottom of Each
Add page numbers automatically to your Excel reports for professional documentation. This chapter walks you through footer customization and numbering techniques.
1 Videos Available
Chapter 60 : Print Several Worksheet on Single Page
Combine multiple sheets into one print layout. Learn to manage compact reports, summaries, and combined data outputs efficiently.
1 Videos Available
Chapter 61 : Proper, Upper and Lower Function
Learn to change text case automatically using PROPER, UPPER, and LOWER functions. Perfect for maintaining consistent data formatting in large text datasets.
1 Videos Available
Chapter 62 : Quickly Copy Formula
Learn to change text case automatically using PROPER, UPPER, and LOWER functions. Perfect for maintaining consistent data formatting in large text datasets.
1 Videos Available
Chapter 63 : Quickly Insert Current Date and Time
Discover shortcuts and functions like NOW() and TODAY() to auto-insert timestamps. Ideal for reports, invoices, and time-sensitive entries.
1 Videos Available
Chapter 64 : Quickly Transpose
Learn to switch rows into columns and vice versa with Excel’s Transpose feature. This skill is crucial for reorganizing data for presentation or analysis.
1 Videos Available
Chapter 65 : Rank Function
Master the RANK function to determine positional value among datasets. It’s ideal for grading systems, sales ranking, and performance analytics.
1 Videos Available
Chapter 66 : Replace and Substitute Function
This chapter teaches how to modify text efficiently using REPLACE and SUBSTITUTE. Clean and reformat large text datasets without manual effort.
1 Videos Available
Chapter 67 : Search Box
Learn how to create a search box using Excel’s formulas and features. Enhance interactivity in dashboards and reports for user-friendly navigation.
1 Videos Available
Chapter 68 : Selecting Group of Cells
Understand efficient methods to select large or specific groups of cells. Learn shortcuts that improve speed while formatting or entering data.
1 Videos Available
Chapter 69 : Selecting Ranges with Keyboard
Master keyboard shortcuts to select data ranges quickly. This chapter improves productivity and makes data handling faster.
1 Videos Available
Chapter 70 : Share Workbook
Learn how to collaborate on Excel workbooks with multiple users simultaneously. This chapter teaches sharing permissions, track changes, and data merging.
1 Videos Available
Chapter 71 : Shortcut to Viewing Formulas
Discover quick ways to view and review all formulas in a worksheet at once. This helps in auditing and debugging data effectively.
1 Videos Available
Chapter 72 : Spelling Check
This chapter explains Excel’s spelling check tool to correct errors in your sheets. Ensure professionalism and accuracy in all written data.
1 Videos Available
Chapter 73 : Split Column Data
Learn how to split text in a single column into multiple columns using the Text to Columns feature. Ideal for cleaning imported or combined data.
1 Videos Available
Chapter 74 : Switch Between Workbooks
Discover fast ways to navigate between multiple open Excel files. Learn shortcuts that enhance multitasking and workflow efficiency.
1 Videos Available
Chapter 75 : Text Convert Number
Learn how to convert text-based numbers into actual numerical values for calculations. This chapter ensures formula compatibility and accurate analysis.
1 Videos Available
Chapter 76 : Text Function
Understand the TEXT function to format numbers, dates, and values into readable text. It’s vital for creating customized report layouts.
1 Videos Available
Chapter 77 : Transpose Function
This chapter expands on transposing data dynamically using formulas. Learn how to manage data orientation with precision.
1 Videos Available
Chapter 78 : Trick to Changed Predefined Group Name
Discover how to modify and rename default groups in Excel’s ribbon. This customization enhances your workspace for quicker access to tools.
1 Videos Available
Chapter 79 : Trick to Create Own New Tab
Learn how to create your custom tab in Excel’s ribbon for personalized tool access. Perfect for professionals who use specific commands frequently.
1 Videos Available
Chapter 80 : Trick to Insert Picture Comment
Learn how to create your custom tab in Excel’s ribbon for personalized tool access. Perfect for professionals who use specific commands frequently.
1 Videos Available
Chapter 81 : Trick to Open Specific Workbooks
Automate workbook opening upon Excel launch. This chapter covers VBA or settings customization for streamlined workflow.
1 Videos Available
Chapter 82 : Turn Off and On Worksheet and Scrollbar
Learn how to hide or display worksheets and scrollbars for cleaner presentation or restricted access. Ideal for creating protected dashboards.
1 Videos Available
Chapter 83 : Unprotect Spreadsheet
Master techniques to unprotect locked sheets safely with permissions. Learn best practices for maintaining data security and editing control.
1 Videos Available
Chapter 84 : Vlookup Function
This chapter provides an in-depth explanation of VLOOKUP, one of Excel’s most used functions. Learn to fetch data efficiently from large databases with examples.
1 Videos Available
Chapter 85 : Weekday Function
Learn how to use the WEEKDAY function to determine the day of the week for any given date. Useful for scheduling, planning, and business analysis.