Scribd Logo
Upload

Welcome to Scribd!

  • 42 views

    FINAL Advanced Excel Training 04nov2023

    Uploaded by

    Sakshi Marwah Chamola
    The document compares basic and advanced Excel. Basic Excel involves simple formulas, functions, formatting, counting, and other basic tasks. Advanced Excel uses more complex formulas and functions like V-lookup, data consolidation, conditional formatting, pivot tables, and VBA macros. The document then provides an overview of topics covered in a basic Excel session and exercises. It moves on to demonstrating advanced features like wrapping text, changing case, merging and splitting cells, and more with corresponding exercises. Finally, it discusses pivot tables, page setup modification, and cardinal rules for Excel use.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    FINAL Advanced Excel Training 04nov2023

    Uploaded by

    Sakshi Marwah Chamola
    42 views19 pages
    The document compares basic and advanced Excel. Basic Excel involves simple formulas, functions, formatting, counting, and other basic tasks. Advanced Excel uses more complex formulas and functions like V-lookup, data consolidation, conditional formatting, pivot tables, and VBA macros. The document then provides an overview of topics covered in a basic Excel session and exercises. It moves on to demonstrating advanced features like wrapping text, changing case, merging and splitting cells, and more with corresponding exercises. Finally, it discusses pivot tables, page setup modification, and cardinal rules for Excel use.

    Original Title

    FINAL Advanced Excel Training 04Nov2023

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document compares basic and advanced Excel. Basic Excel involves simple formulas, functions, formatting, counting, and other basic tasks. Advanced Excel uses more complex formulas and functions like V-lookup, data consolidation, conditional formatting, pivot tables, and VBA macros. The document then provides an overview of topics covered in a basic Excel session and exercises. It moves on to demonstrating advanced features like wrapping text, changing case, merging and splitting cells, and more with corresponding exercises. Finally, it discusses pivot tables, page setup modification, and cardinal rules for Excel use.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    42 views19 pages

    FINAL Advanced Excel Training 04nov2023

    Uploaded by

    Sakshi Marwah Chamola
    The document compares basic and advanced Excel. Basic Excel involves simple formulas, functions, formatting, counting, and other basic tasks. Advanced Excel uses more complex formulas and functions like V-lookup, data consolidation, conditional formatting, pivot tables, and VBA macros. The document then provides an overview of topics covered in a basic Excel session and exercises. It moves on to demonstrating advanced features like wrapping text, changing case, merging and splitting cells, and more with corresponding exercises. Finally, it discusses pivot tables, page setup modification, and cardinal rules for Excel use.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 19

    Advanced

    Excel

    04 November 2023
    Difference between Basic and Advanced Excel

    Basic Advanced

    In Basic Excel simple formulas Whereas in Advanced Excel, high


    and functions are performed, acknowledgement formulas and
    without any complication like, functions are performed with
    simple arithmetic formulas, complex data, like v-lookup,
    formatting, count, etc. consolidation, conditional
    formatting, pivot tables, vba
    macros, etc.
    Recap of what we covered in Session 1 on Basic Excel
    • Basic Formulas
    • Functions
    • Formatting cells
    • Text alignment
    • Inserting and Deleting rows and columns
    • Moving Cell contents using cut & paste
    • Find and replace text
    • Sorting
    • Filter
    Revision Exercises of Basic Excel Formulas

    20 minutes
    Features in Advanced Excel – Wrap Text / Unwrap Text
    Features in Advanced Excel – Change Case
    Features in Advanced Excel – Merge Cells / Unmerge Cells
    Features in Advanced Excel – Split Cell Contents
    Features in Advanced Excel – Merge Cell Contents
    Practice Exercise

    15 minutes
    Features in Advanced Excel – V-lookup
    Features in Advanced Excel – V-lookup
    Practice Exercise

    20 minutes
    Features in Advanced Excel – Pivot
    Practice Exercise

    20 minutes
    Features in Advanced Excel – Modify Page Set-up
    Practice Exercise

    10 minutes
    Cardinal Rules for Excel
    • Always ensure there is data sanctity in your spreadsheet
    • Always use formulas
    • Always enter/input numeric data without manually putting commas and decimals.
    • Always format your spreadsheet with borders, data alignment, font and font sizes,
    cell colors etc.
    • Always ensure your spreadsheet is shared internally in a printable format.
    • Always share your spreadsheet with clients in PDF format only.

    PRACTICE PRACTICE PRACTICE


    THANK YOU

    GET IN TOUCH
    FOUNDED IN 2008
    Send us an email or call us at:

    NCR : +91 124 5025025/6


    Mumbai : +91 22 6901 3000
    Bangalore : +99 1032 6400

    client@sapphirehs.com

    You might also like