Call nowContact us
  • Advance Excel Full Course


    Advance Excel Full Course, with 250+ formulas, 100+ Assignments, Customized Notes, International Certification from Microsoft (MOS) and Guaranteed Placement.

    Call at +91-72899 89188 or mail at info@aclm.in 

    Rated 4.8 out of 5.0, in India. 40 Hours Training will help you for 40 Years in your work.

    Course Duration: 40 Hrs, Fee: 5,000/=

    Importance of Advance Excel Full Course in our Daily Life

    Advance Excel Full Course has been designed to help out our daily task rapidly. In our daily routines presentation plays a vital role for clear outcomes of any scenarios. The purpose of such customized training is basically for developing a clean and clear dashboard which can be treated as a key utility tool in our daily routines. Our training will help you in developing such dashboard which will make you distinct among all.

    “Turning Motivated Individuals into Office Superstars” is our main concern over all training. The primary focus of making individuals ready at par with the technology makes organization more reliable over their existing members and making their arm more stronger.

    ACLM, Known for the MIS Training institution, successfully completed more than 750 training including corporate as well as individual training.

    ACLM, under this course, also guarantee for the placement of trained candidate(s) as well as groups to esteem organizations like EXL, Accenture, Genpact, IBM, Naukri.com and many more MNCs.

    KEY FEATURES of Advance Excel Full Course
    • 50+ assignments, Custom notes on Advance Excel and its various properties
    • Command on more than 250+ formulas
    • Flexibility to avail Regular as well as Weekend Classes
    • For fast learners, daily classes of up to 5 hours of each class
    • Test and Mock Interview Sessions for Interview Preparations
    • Exposure on Real time work environment

    Topics Covered under Advance Excel Full Course

    EXCEL PART

    advance excel full courseFocus on real scenarios of Reporting / Data Management / Automation, Difference between basic and advance Excel, Excel Basics, Excel Settings, Advanced Formulas, Name Manager, Absolute and Relative fields, Goal Seek / Scenario, Managing Lists, Cross Reference (Absolute & Relative)

    ADVANCE EXCEL PART

    Conditional formatting, User Settings for Excel Application Level, Data Management and Analysis, Reporting Techniques, Pivot Table, Macros, Identifying Bad Data, Correction of Data Table, Using ActiveX Buttons etc., Application Design, Advanced Charting and Graphs, Cluster Design.

    Set of Important Formulae and related assignments
    • Logical Function Sets – And, Or, Not, Nand, Nor, Xor, True, False, Iferror, Iserror, Iserr, Isna, Isblank, Istrue, IsFalse, IsNumber, IsText, IsEven, Isodd, IsLogical
    • Usage of Operators – Logical Operator, Arithmetic Operator, Assignment Operator and Unary Operators
    • Text Function Set – Upper, Lower, Proper, Left, Mid, Right, Concatenate, Char, Code, Find, Search, Replace, Substitute, trim, text value, Text set, T, BahtText. The array formulae including various other text functions
    • Date & Time Function Set – Date(), Day, month, Year, time(), Hour, minute, second, Datedif, Datevalue, Time Value, Weeknum, Weekday, Age Calculator, Usage of scientific and moderate calculator, Days360, General Date Diff, EDate, EOmonth, Workdays, Workdays.intl, Networkdays, Networkdays.intl, now, Today, Yearfrac
    • Lookup and References set – Address, Area, Choose, Vlookup, Hlookup, Lookup, Reverse Lookup, Index, Match, Row, Rows, Column, Columns, Get Pivot Data, Hyperlink, Indirect, offset, Transpose, RTD
    • Mathematical Function – General Use Function – Sum, sumif, Sumifs, Count, countif, Countifs, Average, Averageif, Averageifs, Product, Sumproduct, Sumproduct Array Formula, Round, Roundup, Rounddown, Floor, Ceiling, INT, Sqrt, Power, Subtotal, Fact, Even, Odd
    • Conditional Statement – If, If else, if else if (nested if), if with operator, if with the use of text functions, if with the use of numbers, if with date function, if with time functions
    DATA FILTERING / DATA FORMATTING

    Understanding Different Data Types, Using String / Text / Number / Long Data Types with examples, Managing Date Time Format, Handling Long Date time Format, Data Correction, Identifying bad data, Conversion of different data types, Importing and accessing different file types in excel

    ADVANCE EXCEL SECURITY

    Protecting Excel File, Protecting worksheet, Workbook, Enable / Disable Range, Allow users to edit range, Protecting users to edit range, Field Controls using customized user access

    FORM BASED

    Database, Tables, Fields and Properties, Form Properties, Variables, Functions, Modules, Subroutines, Conditional Validations, Using Other ActiveX Tools like, Calendar, Watch, PDF…, Looping Constructs (While, Do While, For, Foreach, If Else, If then else…) Functional Parameters

    USING CHARTS  / GRAPHS / PIVOT CHARTS / PIVOT TABLE

    Setting Data Source, Getting Charts / Graphs using Referential fields, Getting ACCESS Data Getting Other Data

    DATA SOURCE

    Setting Data Source, Getting XML Data, Getting ACCESS Data, Getting Other Data

    RETRIEVING DATA FROM SINGLE TABLE

    Integration of Database, Connecting to various DBMS systems through excel

    DATA Connectivity in Excel

    Connecting to a excel Using the SQL Procedure, Connecting to a access Using the SQL Procedure, Connecting to a DBMS Using the DSN

    ODBC

    Understanding how to use the ODBC with Excel, Set up a data source for a database driver, Defining the ODBC API, ODBC Terminology, Defining the Data Source Manager, ODBC Driver, Data Source

    Who Should Attend

    MS Office Specialist, MIS Personals, VBA Programmer, Accounts Personal, Project Managers, Developers, Technical/ Test Leads, Program Managers, Project Managers, Research Workers, Freelancers, Data analysis departments

    Pre-requisites

    Basic Knowledge of Excel, Candidate’s having some programming background will have an added advantage

    What You Need To Bring

    Notepads, Laptops / Notebooks (Up to your choice).

    Key Takeaways

    Various MIS technique with the help of Excel VBA Programming, Generate different Analytical Process. Data handling and correcting bad data with the help of Access, Reporting and Formatting with different angles, Macro generation and application design, Writing customized queries as per the need and, Build a full fledged Dashboard.

    About Trainer

    Having 20+ Years of Experience in Data Analysis, Certified by 28 International Certification. Microsoft MVP, Microsoft Office Specialist (MOS), Expertise in Clinical Data Research, A/B Testing, Data Visualization, Data Mining and Presentation. Delivered more than 250+ VBA Projects (onsite & offsite) Currently working on 30 Excel, VBA, Tableau & SAS Projects from International Organisations.

    ACLM’s Other top performing courses:



    Admission Form

    admission form aclm

    Book a free trial class

     By submitting this form, I authorise the website to call or SMS me in connection with my application & agree to Privacy Policy and Terms of use.
    PAY FEE ONLINE BY :

    Schedule

    1
    Sep
    Tableau Workshop by ACLM
    register
    1
    Sep
    SQL Server Workshop
    register
    1
    Sep
    Digital Marketing Workshop
    register
    1
    Sep
    Python Workshop
    register
    1
    Sep
    Free Core Java Workshop
    register