Excel Series- 1 || Advanced Excel: Two-Day Online Training Program || Day and Date: 13-14 July 2024 (Saturday & Sunday) || Time: 5:30 pm to 08:30 pm || Last Date: 11 July 2024

Excel Series- 1

Advanced Microsoft Excel: Two-Day Online Training Program

Organized by: LibAuto- A Leading Library Automation & Digitization Company in India

Day and Date: 13-14 July 2024 (Saturday & Sunday)
Time: 5:30 pm to 08:30 pm 

Last Date: 11 July 2024

Registration Fee: Rs. 498 (with video recording)

🌐 Link for Registration: https://bit.ly/LibAuto-Registration 


Account Detail for Paying Registration Fee: 

Bank Account details
Account Holder: LibAuto
Account Number: 50200091760910
IFSC: HDFC0002784
Bank Branch: HDFC Bank, Kapurthala II

Phone Pay/Google Pay/ Paytm number 9463116032

UPI: 9463116032@paytm

🌐 Link for Registration: https://bit.ly/LibAuto-Registration

✔️ PG/Diploma Courses: PG-Diploma-Courses

 After making the payment, please send a screenshot to wa.me/+917888685521
✔ Eligibility: Faculty, Researcher, LIS & IT Professionals, and Students.
✔ The medium of instruction for the training is Hindi.
✔ Limited seats are available on a First- cum-First-Serve basis.
 E-certificate will be provided to the participants after successfully completing the training.
✔ Confirmation will be sent to all registered candidates by e-mail/Whatsapp.
✔ All the sessions will be conducted on Zoom platforms.
✔ The video recording of the live session will be made available.

Join Whatsapp Community Group for Upcoming Events:

Topics to be covered

Formatting and Proofing

  • Basic conditional formatting

Mathematical Functions

  • SumIf, SumIfs CountIf, CountIfs AverageIf, AverageIfs, Nested IF, IFERROR Statement, AND, OR, NOT

Protecting Excel

  • File Level Protection
  • Workbook, Worksheet Protection

Text Functions

  • Upper, Lower, Proper
  • Left, Mid, Right
  • Trim, Len, Exact
  • Concatenate
  • Find, Substitute

Date and Time Functions

  • Today, Now
  • Day, Month, Year
  • Date, Date if, DateAdd
  • EOMonth, Weekday

Advanced Paste Special Techniques

  • Paste Formulas, Paste Formats
  • Paste Validations
  • Transpose Tables

Sorting and Filtering

  • Filtering on Text, Numbers & Colors
  • Sorting Options
  • Advanced Filters on 15-20 different criteria(s)

Printing Workbooks

  • Setting Up Print Area
  • Customizing Headers & Footers
  • Designing the structure of a template
  • Print Titles –Repeat Rows / Columns

Logical Functions

  • If Function
  • How to Fix Errors – if error
  • Nested If
  • Complex if and or functions

Data Validation

  • Number, Date & Time Validation
  • Text and List Validation
  • Custom validations based on formula for a cell
  • Dynamic Dropdown List Creation using Data Validation  Dependency List

Lookup Functions

  • Vlookup HLookup
  • Index and Match
  • Creating Smooth User Interface Using Lookup
  • Nested VLookup
  • Reverse Lookup using Choose Function
  • Worksheet linking using Indirect
  • Vlookup with Helper Column

Pivot Tables

  • Creating Simple Pivot Tables
  • Basic and Advanced Value Field Setting
  • Classic Pivot table
  • Choosing Field
  • Filtering PivotTables
  • Modifying PivotTable Data
  • Grouping based on numbers and Dates
  • Calculated Field & Calculated Items
  • Arrays Functions
  • What are the Array Formulas, Use of the Array Formulas?
  • Basic Examples of Arrays (Using ctrl+shift+enter).
  • Array with if, len and mid functions formulas.
  • Array with Lookup functions.
  • Advanced Use of formulas with Array.

Charts and slicers

  • Various Charts i.e. Bar Charts / Pie Charts / Line Charts
  • Using SLICERS, Filter data with Slicers
  • Manage Primary and Secondary Axis

Please feel free to contact us for any queries.

LibAuto: -the smart library
(A Leading Library Automation Company in India)
Registration Number:- UDYAM-PB-11-0025691
Address: St. No-5, Nanak Nagri, Abohar- 152116 (Punjab)
Contact: 094631-16032
Email: contact.libauto@gmail.com
Website: www.libauto.in


Post a Comment