Download app Download App
tag
Favourite 0
Your cart is empty
Keep shopping  right

    Advance Excel Training

    This Master’s Program covers all of Excel´s must-know features which include the Excel Ribbon, Formatting, Formulas & Functions, Excel Tables, Charts, Pivot Tables, Condi...

    ₹ 15001

    ₹ 17000

    12% off

    SHARE
    Baroda Institute of Technology
    ₹15001  ₹ 17000  

    12% off

     
    Buy Now
    This includes following
    •  65 Hours
    •  Completion certificate : Yes
    •  Language : Hinglish 
    This Master’s Program covers all of Excel´s must-know features which include the Excel Ribbon, Formatting, Formulas & Functions, Excel Tables, Charts, Pivot Tables, Conditional Formatting, Macros, VBA (Visual Basic for Applications), Data Validation. During this course, you will build a foundation of working with Excel, Excel Macros and VBA. This foundation will be built as you engage and participate in project-based Excel Macro/VBA exercises, detailed throughout the lectures within this course. Each of the projects will build upon one another, introducing a new concept each time, starting with the basic building blocks of automating any task within Excel and ending with a fully customized Excel VBA project that will automate a series of Excel tasks.VBA stands for Visual Basic for Applications, an event-driven programming language from Microsoft. It is now predominantly used with Microsoft Office applications such as MSExcel, MS-Word and MS-Access.

        Live Class Practical Oriented Training

        Timely Doubt Resolution

        Dedicated Student Success Mentor

        Certification & Job Assistance

        Free Access to Workshop & Webinar

        No Cost EMI Option

        Build a solid understanding on the basics of Microsoft Excel. Writing formulas and performing calculations

        SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, TRANSPOSE functions. Inserting headers and footers, and adjusting margins

        Color code data that meet certain criteria with Conditional Formatting. Save time applying formatting to other cells wit...

        Create different variations of charts and graphs that can be used to represent real life scenarios. Manipulate data to g...

        Analyze & sort/filter data to create powerful & captivating pivot tables. Implement formulas, functions & calculations t...

        Create different variations of charts and graphs that can be used to represent real life scenarios. Manipulate data to g...

       Lecture 1: Introduction to Spreadsheets

       Lecture 2: Formulas & Functions

       Lecture 3: Charts

       Lecture 4: Formatting

       Lecture 5: Pivot Tables

       Lecture 6: Data Tables

       Lecture 7: Excel Functions

       Lecture 8: Statistical Functions

       Lecture 9: Managing Multiple Worksheets

       Lecture 10: Importing Data From External Sources

       Lecture 11: Templates, Themes, And Styles 

    •   Lecture 1: Introduction to Spreadsheets
Live Lecture 
·      Introduction To Spreadsheets

·      Creating Formulas, Auto Fill

·      Formatting

·    Practical Exercise
    •   Lecture 2: Formulas & Functions
Live Lecture 
·      Basic Formulas

·      Inserting Basic Math & Statistics Functions

·      Using Date Functions

·      Logical Functions - IF Function

·      Lookup Function-Vlookup() & Hlookup()

·      Financial Functions

·      Range Names

·      Practical Exercise
    •   Lecture 3: Charts
Live Lecture 
·      Chart Creation Basics

·      Chart Elements

·      Chart Design And Sparklines

·      Practical Exercise
    •   Lecture 4: Formatting
Live Lecture 
·      Large Datasets- Freezing & Printing

·      Excel Table With Manipulation And Aggregation

·      Conditional Formatting

·      Practical Exercise
    •   Lecture 5: Pivot Tables
Live Lecture 
·      Subtotals And Outlines

·      Pivot table With Options

·      Pivot table Design And Pivot charts

·      Practical Exercise
    •   Lecture 6: Data Tables
Live Lecture 
·      One- And Two-Variable Data Tables

·      Goal Seek And Scenario Manager

·      Solver

·      Practical Exercise
    •   Lecture 7: Excel Functions
Live Lecture 
·      Nested Logical Function

·      Match And Index Lookup Functions

·      Advance Filtering

·      Database Functions

·      Financial Functions

·      Practical Exercise
    •   Lecture 8: Statistical Functions
Live Lecture 
·      Using Conditional Math & Statistical Functions

·      Calculating Relative Standing With Statistical Functions

·      Descriptive Statistical Functions

·      Practical Exercise
    •   Lecture 9: Managing Multiple Worksheets
Live Lecture 
·      Multiple Worksheets

·      Inserting A 3-D Formula

·      Linking Workbooks

·      Formula Auditing

·      Data Validation

·      Practical Exercise
    •   Lecture 10: Importing Data From External Sources
Live Lecture 
·      Text Manipulation Functions

·      Flash Fill

·      Customizing Excel & Changing Properties

·      Sharing And Merging Workbooks

·      Inserting Comments & Tracking Changes

·      Practical Exercise
    •   Lecture 11: Templates, Themes, And Styles
Live Lecture 
·      Templates, Themes, And Styles

·      Creating And Using A Template

·      Protection-Protecting A Cell, Worksheet,& Workbook

·      Macro In Excel

·      Creating A Sub Procedure & Custom Function

·      Practical Exercise
    Basic Computer Knowledge.
    The course offers a variety of online training options, including: • Live Virtual Classroom Training: Participate in real-time interactive sessions with instructors and peers. • 1:1 Doubt Resolution Sessions: Get personalized assistance and clarification on course-related queries. • Recorded Live Lectures*: Access recorded sessions for review or to catch up on missed classes. • Flexible Schedule: Enjoy the flexibility to learn at your own pace and according to your schedule.
    Live Virtual Classroom Training allows you to attend instructor-led sessions in real-time through an online platform. You can interact with the instructor, ask questions, participate in discussions, and collaborate with fellow learners, simulating the experience of a traditional classroom setting from the comfort of your own space.
    If you miss a live session, you can access recorded lectures* to review the content covered during the session. This allows you to catch up on any missed material at your own pace and ensures that you don't fall behind in your learning journey.
    The course offers a flexible schedule, allowing you to learn at times that suit you best. Whether you have other commitments or prefer to study during specific hours, the course structure accommodates your needs, enabling you to balance your learning with other responsibilities effectively. *Note: Availability of recorded live lectures may vary depending on the course and training provider.
    Education Provider
    profile
    Baroda Institute Of Technology - Training Program

    BIT (Baroda Institute Of Technology) Is A Training And Development Organization Catering To The Learning Requirements Of Candidates Globally Through A Wide Array Of Services. Established In 2002. BIT Strength In The Area Is Signified By The Number Of Its Authorized Training Partnerships. The Organization Conducts Trainings For Microsoft, Cisco , Red Hat , Oracle , EC-Council , Etc. Domains / Specialties Corporate Institutional Boot Camp / Classroom Online – BIT Virtual Academy Skill Development Government BIT’s Vision To Directly Associate Learning With Career Establishment Has Given The Right Set Of Skilled Professionals To The Dynamic Industry. Increased Focus On Readying Candidates For On-the-job Environments Makes It A Highly Preferred Learning Provider. BIT Is Valued For Offering Training That Is At Par With The Latest Market Trends And Also Match The Potential Of Candidates. With More Than A Decade Of Experience In Education And Development, The Organization Continues To Explore Wider Avenues In Order To Provide Learners A Platform Where They Find A Solution For All Their Up- Skilling Needs!

    Graduation
    2002
    Data Sciences

    More Courses by : Baroda Institute of Technology


    Baroda Institute of Technology
    ₹15001  ₹ 17000  

    12% off

     
    Buy Now
    This includes following
    •  65 Hours
    •  Completion certificate : Yes
    •  Language : Hinglish

    More Courses by : Baroda Institute of Technology


    Copyright © 2024 Digital Class World. All Rights Reserved.