# Beginner's Excel Certificate Course

### Price: 1499.00 Offer Price 399.00 (Inclusive of GST)

#### Course Curriculum

• Introduction
• Opening First Excel worksheet, Intoduction of Every Element on Sheet and Defining Range
• Navigation, Data Entry, Formatting and Basic Calculation
• Copying Formulas, Relative and Absolute Referencing
• Comprehensive Practice of Relative and Absolute Referencing
• Referencing Further Practice
• Quick Revision, Explaining Ribbon and Excel Shortcuts
• Backstage of Excel ie. File Tab and Introducing the Operational Shortcuts
• Customizing the Ribbon Intro to Formula Tab
• TRUE, FALSE, IF, AND, OR Function
• IF Function Together with AND, OR Function
• Nested if Function
• Autosum Functions and Mathematical Exercises
• Paste Special Function
• Paste Link, Transpose, Insert,Delete and Format Cells Function
• Linking Data Between the Sheets and its Benefit
• Conditional Formatting
• Count Function
• Rank Function, Minimum, MAX, Large and Small Function
• Sumif, SumIFS
• CountIF, AverageIf Function
• Mround, Ceiling, Floor
• Rounddown, RoundUp Functions
• Integer and Trunc Functions
• Trim and Proper Function
• Find and Search Function
• Upper, Lower and Proper Function
• AND FUNCTION
• Concatenate Function
• Repeat and Substitute Function
• Substitute Function Practice
• Substitute and Repeat Function
• Replace Function
• Date and Time Function Introduction
• Customise Your Own Date Format
• Today Function and Addition, Substraction to Dates
• EDATE Function
• EOM Function
• Introduction to Chart and Different Ways of Inserting a Chart
• Introducing all the Chart Elements and Formatting Each Element
• Improving your Chart by Using Various Charts Layouts, Colors and Designs
• Data Series Editing, Saving a Template and Other Basic Chart Details
• When to Use Which Chart Type-an Intro and Winding up Session
• VLOOKUP Function
• MATCH and HLOOKUP Function
• Tell me what do You Want Option in Excel
• Protecting, Freeze Panes,Show and Customize the Ribbon
• Table Making, Designng, Sort and Filter in Table Mode and with the Use of Slicer Option
• AutoCorrect function for Short Hand Wriring, Automatic Decimal Entry and Various Miscellaneous Points in FILE Tab

CA Agrika is a qualified Chartered Accountant and holds experience in the Investment Banking Domain. Besides the technical professional background she has due inclination towards spiritual development and conducts programs on mind fullness, meditation and personal growth. She imparts lectures for professional examination and conducts several certification programs. Her easy way to learn mnemonic style and smart revision strategy has helped her student's crack tough professional exam.

#### Terms and Conditions:

• Total Length of Videos: 8.28 Hrs
• Expiry: 3 months 30 hours of viewing whichever is earlier from the date of registration.
• Videos are meant for web viewing only and cannot be downloaded. Videos are available in Full Screen viewing
• Course/Subject purchased once cannot be cancelled.