{"id":534,"date":"2026-10-31T08:59:53","date_gmt":"2026-10-31T08:59:53","guid":{"rendered":"https:\/\/hricha.myamrozinstitute.com\/?page_id=534"},"modified":"2026-11-02T03:16:36","modified_gmt":"2026-11-02T03:16:36","slug":"advance-excel","status":"publish","type":"page","link":"https:\/\/hricha.myamrozinstitute.com\/?page_id=534","title":{"rendered":"Advance Excel"},"content":{"rendered":"\t\t
\n\t\t\t\t
\n \t\t\t

MS Excel Syllabus<\/strong><\/h2>\n\t\t\n<\/div>\n
\n \t\t\t

1. Introduction to MS Excel<\/strong><\/h3>\n\t\t\n<\/div>\n
\n \t\t\t

          Overview of Excel Interface
          Workbook, Worksheet, Rows, and Columns
          Navigating and Selecting Cells
          Basic Data Entry and Editing<\/p>\n\t\t\n<\/div>\n

\n \t\t\t

2. Basic Excel Operations<\/strong><\/h2>\n\t\t\n<\/div>\n
\n \t\t\t

         Formatting Cells (Font, Color, Borders, Alignment)
         Merging and Wrapping Text
         Inserting and Deleting Rows, Columns, and Cells
         Copying, Cutting, and Pasting Data<\/p>\n\t\t\n<\/div>\n

\n \t\t\t

3. Formulas and Functions<\/strong><\/h2>\n\t\t\n<\/div>\n
\n \t\t\t

        Basic Arithmetic Formulas (+, -, *, \/)
        Common Functions: SUM, AVERAGE, MIN, MAX ETC.
        Logical Functions: IF, AND, OR, NOT, TRUE, FALSE ETC.
        Lookup & Reference Functions: VLOOKUP, HLOOKUP, XLOOKUP, INDEX, MATCH, OFFSET, TRANSPOSE, ROW, ROWS ETC.
        Text Functions: CONCATENATE, LEFT, RIGHT, LEN, TRIM, UPPER, LOWER, PROPER, REPT, UNICHAR, CLEAN, CHAR ETC.
        Date & Time Functions: TODAY, NOW, DATE, YEAR, MONTH, NETWORKINGDAYS, NETWORKINGDAYS.INTL ETC.    
        Maths & Trig: SUBTOTAL, SUMPRODUCT, PRODUCT, POWER, SQRT, RAND, RANDBETWEEN, MODE ETC.<\/p>\n\t\t\n<\/div>\n

\n \t\t\t

4. Data Management and Analysis<\/strong><\/h2>\n\t\t\n<\/div>\n
\n \t\t\t

       Sorting and Filtering Data
       Data Validation and Drop-Down Lists
       Conditional Formatting
       Removing Duplicates
       Flash Fill & AutoFill<\/p>\n\t\t\n<\/div>\n

\n \t\t\t

5. Charts and Graphs<\/strong><\/h2>\n\t\t\n<\/div>\n
\n \t\t\t

       Creating Bar, Line, Pie, and Column Charts
       Customizing Charts (Titles, Labels, Legends)
       Data Series and Trendlines<\/p>\n\t\t\n<\/div>\n

\n \t\t\t

6. Pivot Tables and Pivot Charts<\/strong><\/h2>\n\t\t\n<\/div>\n
\n \t\t\t

       Creating and Customizing Pivot Tables
       Analyzing Data with Pivot Charts
       Using Slicers and Timelines<\/p>\n\t\t\n<\/div>\n

\n \t\t\t

7. Advanced Excel Functions<\/strong><\/h2>\n\t\t\n<\/div>\n
\n \t\t\t

       Nested Functions
       Array Formulas
       Text-to-Columns and Flash Fill
       What-If Analysis (Goal Seek, Data Tables, Solver)<\/p>\n\t\t\n<\/div>\n

\n \t\t\t

8. Data Protection and Security<\/strong><\/h2>\n\t\t\n<\/div>\n
\n \t\t\t

       Protecting Worksheets and Workbooks
       Password Protection
       Cell Locking and Sheet Encryption<\/p>\n\t\t\n<\/div>\n

\n \t\t\t

9. Automation with Macros & VBA (Advanced Level)<\/strong><\/h2>\n\t\t\n<\/div>\n
\n \t\t\t

       Introduction to Macros
       Recording and Running Macros
       Basics of VBA (Visual Basic for Applications)<\/p>\n\t\t\n<\/div>\n

\n \t\t\t

10. Collaboration and Sharing<\/strong><\/h2>\n\t\t\n<\/div>\n
\n \t\t\t

       Track Changes and Comments
       Sharing Workbooks Online
       Using Excel with OneDrive and Google Sheets

This syllabus covers beginner to advanced levels and is suitable for students, professionals, and business users.<\/p>\n\t\t\n<\/div>\n\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"

MS Excel Syllabus 1. Introduction to MS Excel           Overview of Excel Interface          Workbook, Worksheet, Rows, and Columns          Navigating and Selecting Cells          Basic Data Entry and Editing 2. Basic Excel Operations          Formatting Cells (Font, Color, […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-534","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/hricha.myamrozinstitute.com\/index.php?rest_route=\/wp\/v2\/pages\/534","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hricha.myamrozinstitute.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/hricha.myamrozinstitute.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/hricha.myamrozinstitute.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hricha.myamrozinstitute.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=534"}],"version-history":[{"count":34,"href":"https:\/\/hricha.myamrozinstitute.com\/index.php?rest_route=\/wp\/v2\/pages\/534\/revisions"}],"predecessor-version":[{"id":568,"href":"https:\/\/hricha.myamrozinstitute.com\/index.php?rest_route=\/wp\/v2\/pages\/534\/revisions\/568"}],"wp:attachment":[{"href":"https:\/\/hricha.myamrozinstitute.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=534"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}