Excel Mastery: From Basics to Advanced Techniques

Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

Dive deep into Excel’s capabilities with our comprehensive course! From essential formulas to advanced data analysis techniques, master spreadsheet skills that will boost your productivity and proficiency. Whether you’re a beginner or seasoned user, unlock the secrets to creating dynamic charts, automating tasks, and organizing data effectively. Join us on this learning journey and gain the confidence to excel in your professional and personal projects.

What Will You Learn?

  • Introduction to Excel: Getting familiar with the interface and basic functions.
  • Formulas and Functions: Mastering SUM, IF, VLOOKUP, and other essential formulas.
  • Data Analysis: Techniques for sorting, filtering, and analyzing data sets.
  • Charts and Graphs: Creating dynamic visual representations of your data.
  • PivotTables: Using PivotTables and PivotCharts to summarize and analyze data.
  • Data Validation and Conditional Formatting: Ensuring data accuracy and highlighting key insights.
  • Automation with Macros: Streamlining tasks with recorded and custom macros.
  • Collaboration and Sharing: Techniques for sharing workbooks and collaborating with others.
  • Advanced Formulas: Exploring advanced functions like INDEX-MATCH, array formulas, and nested IFs.
  • Data Visualization: Creating interactive dashboards and reports for effective communication.

Course Content

Excel Advanced Tutorial – Welcome to MS Excel

  • Accessing Ribbon Commands With The Keyboard (new)
    05:00
  • Activating And Deactivating Interface Options
    05:25
  • Adding Comments To Formulas (new)
    03:41
  • Adding Formulas To Text Boxes (new)
    04:26
  • Adding Hyperlinks To Excel Objects
    04:35
  • Controlling The Quantity Of Worksheets
    03:31
  • Create A Chart With A Single Key
    04:50
  • Create Your Own Fill Handle Lists
    06:57
  • Creating A Table
    03:18
  • Creating And Managing A Pick List
    04:47
  • Creating And Using Custom Views
    05:23
  • Ctrl Keyboard Shortcuts
    09:48
  • Customize The Ribbons And Quick Access Toolbar
    07:13
  • Displaying File Path, File Name And Sheet Name
    05:20
  • Displaying The Formula In Use Formula Text
    04:00
  • Drilling Down Into Pivot Table Data
    04:27
  • Flash Fill In Action – Completing Data Columns
    04:51
  • How To Enter Numbers And Retain The Leading Zero
    04:18
  • Inserting The Date And Time As Static Or Dynamic
    04:14

Excel Shortcut Guides

Advanced Formulas and Functions

Advanced Microsoft Excel

Charts in Detail

Student Ratings & Reviews

No Review Yet
No Review Yet

Smart Learning by Edureja, a part of One Digi Point, is an online platform catering to students, professionals, influencers, and marketers seeking versatile educational opportunities.

Products