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

or https://forms.gle/fdpFh5qzsw9XBt3r5

__________________________________________________________________________

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:
https://chat.whatsapp.com/F2PRlRjvtfWCv2qr4ZQnb5

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