The First Annual K.C. Zachariah Memorial Lecture will be held at O.P. Jindal Global University, New Delhi, on December 14, 2024, at 11:00 AM.

Call for Papers Theme: People on the Move: International Migration as a Catalyst for Achieving the SDGs

Chair is a member of the Scientific Committee for the preparation of the 2025 International Forum for Migration Statistics (IFMS)

Special Issue: Climate and Development (hybrid open access journal): Publishes research on the interfaces between climate, development, policy and practice to make analysis of climate and development issues more accessible.

Webinar series on “Perceptions and Realities of Academics Abroad with special focus on Masters in the Netherlands”

Excel for All

Why join this Course

Enroll now to go through a deep dive into one of the most popular spreadsheet tools on the market, Microsoft Excel. We will guide you step by step through the beginner to advanced level and beyond.

As you participate in each of the 3 courses you will master Excel that will clear away the pain of stumbling through your daily tasks. You will start with the basics, building a solid foundation that will give you further knowledge as you progress into intermediate and advanced level topics.

Who this course is for

These Microsoft Excel courses will take you through 3 levels of Microsoft Excel topics (Beginner, Intermediate, Advanced and Macros).
If your looking to take your Excel skills from beginner to advanced level and beyond, then this course is for you.

Requirements

No Prior Excel Knowledge Required
Microsoft Excel 2007, 2010, 2013, 2013, 2019 or Microsoft 365 Excel Loaded on Computer to Follow Along with Instructor Lectures is Recommended

Course Description

Microsoft Excel all in One Package – This Microsoft Excel is made up of 3 different courses.

Microsoft Excel Level 1 – An Introduction to Excel
Microsoft Excel Level 2 – Intermediate Level Excel
Microsoft Excel Level 3 – Advanced Level Excel

Topics covered in this course apply to Excel 2007, 2010, 2013, 2016, and 2019 (Microsoft/Office 365)

Course Timing

The course is spread across 3 weeks with lectures every Friday, Saturday and Sunday from 6:30 to 8:00 PM IST

Microsoft Excel Level 1 – An Introduction to Excel

Excel Basics

A Tour around Excel
Customizing Excel.

Worksheet Design

Building Worksheets.
Formatting Worksheets.
Editing and Proofing Worksheets.
Managing Worksheets.
Printing Worksheets.

Worksheet Collaboration and Review

Protecting Workbooks and Worksheet Data.
Preparing a Workbook for Distribution.
Sharing Workbooks and Worksheet Data.

Microsoft Excel Level 2 – Intermediate Level Excel

Formulas and Functions

Building Basic Formulas
Logical Functions and Error Trapping.
Date and Time Formulas.
Financial Formulas.
Math and Statistical Formulas.
Lookup, Information, and Text Formulas.

Charts and Graphics

Charting Worksheet Data.
Adding Graphic Objects.

Data Management

Building and Maintaining Tables.
Filtering and Querying a Table.

Microsoft Excel Level 3 – Advanced Level Excel

Data Analysis

Basic Statistical Analysis
Performing What if Analysis
Performing Large Scale Data Analysis

Excel Macros

Recording and Running Macros.

Course Fee

The course fee is ₹ 500 per level. for normal participants of the course.

Payment Details

Mode of Payment: Online Transfer

Name of the Account: The International Institute of Migration and Development

Name of the Bank: Union Bank

Bank Address: T C 3/21(18) Mathews Arcade, Kesavadasapuram, Pattom Palace, Trivandrum 695 004

Account Number: 545101010050227

IFSC/ NEFT/RTGS: UBIN0554511