Skip to content
  • Courses
  • Schools and Centers
    • Syed Ahsan Ali & Syed Maratib Ali School of Education
    • Shaikh Ahmad Hassan School of Law
    • Suleman Dawood School of Business
    • Syed Babar Ali School of Science & Engineering
    • Mushtaq Gurmani School of Humanities & Social Sciences
    • LUMS Learning Institute
    • Gurmani Center for Languages & Literature
    • Center for Continuing Education Studies
  • Programs
    • Professional Certificates
    • Open LUMS Courses
    • Executive Education
    • Events & Webinars
  • About
    • Our Purpose
    • Partners
    • Faculty
    • FAQS
Menu
  • Courses
  • Schools and Centers
    • Syed Ahsan Ali & Syed Maratib Ali School of Education
    • Shaikh Ahmad Hassan School of Law
    • Suleman Dawood School of Business
    • Syed Babar Ali School of Science & Engineering
    • Mushtaq Gurmani School of Humanities & Social Sciences
    • LUMS Learning Institute
    • Gurmani Center for Languages & Literature
    • Center for Continuing Education Studies
  • Programs
    • Professional Certificates
    • Open LUMS Courses
    • Executive Education
    • Events & Webinars
  • About
    • Our Purpose
    • Partners
    • Faculty
    • FAQS
  • Courses
  • Schools and Centers
    • Syed Ahsan Ali & Syed Maratib Ali School of Education
    • Shaikh Ahmad Hassan School of Law
    • Suleman Dawood School of Business
    • Syed Babar Ali School of Science & Engineering
    • Mushtaq Gurmani School of Humanities & Social Sciences
    • LUMS Learning Institute
    • Gurmani Center for Languages & Literature
    • Center for Continuing Education Studies
  • Programs
    • Professional Certificates
    • Open LUMS Courses
    • Executive Education
    • Events & Webinars
  • About
    • Our Purpose
    • Partners
    • Faculty
    • FAQS
Menu
  • Courses
  • Schools and Centers
    • Syed Ahsan Ali & Syed Maratib Ali School of Education
    • Shaikh Ahmad Hassan School of Law
    • Suleman Dawood School of Business
    • Syed Babar Ali School of Science & Engineering
    • Mushtaq Gurmani School of Humanities & Social Sciences
    • LUMS Learning Institute
    • Gurmani Center for Languages & Literature
    • Center for Continuing Education Studies
  • Programs
    • Professional Certificates
    • Open LUMS Courses
    • Executive Education
    • Events & Webinars
  • About
    • Our Purpose
    • Partners
    • Faculty
    • FAQS

Advanced Excel

By Jahangir Sachwani
Enroll Now

Charges

Rs.20500

Duration

6 weeks

Language

Bilingual

Course Access

Limited

Certificate

On Completion

Advanced Excel

By Jahangir Sachwani
Enroll Now

About this Course

Microsoft Office Excel is one of the most powerful and valuable tools available in the Microsoft Office arsenal. With this course, you will be able to unlock its full potential for all your academic and professional data analysis needs.

What will you learn

This course will teach participants how to use shortcuts in Excel to work faster, apply advanced Excel formulas and use Excel’s many features to gather, analyze, and visualize information.

Partners

Information is the raw material any organization needs, and the right kind of information at the right time will enable decision-makers to act both timely and effectively.

Course Outline

Module 1
Business Excel with Real World Examples
In the first module, you will be introduced to all the essential tips and tricks you need to Excel-erate your work! You will also learn about the application of advanced formulas and functions such as SumIFs, CountIFs and IFError to tackle complex data.
Module 2
Analysing and Designing Reports
In this module, you will delve into advanced features of Excel such as Pivot Table and Sparklines and will be able to create dynamic dashboards to effectively represent your data.
Module 3
Task Automation with Excel BI
The final module explores applications of Power Query and PowerPivot (Dax Language) for automated Excel tasks. By using these tools, you can clean, transform, merge, and append data from multiple sources, as well as create data models.

Instructors

Jahangir Sachwani

CEO
Innovinc

You might also like

Course

سیکھنا سیکھیں

ڈاکٹر صبیح انور، ڈاکٹر ہانیہ اعظم، ڈاکٹر ارشد احمد اور ڈاکٹر سلیمان شاہد
  • PKR 2500
  • 4 ہفتے
  • 01/05/2023
Course

21st Century Teaching Practices

Dr Shazia Awan, Sabahat Quadri, Salahuddin Azmat Isa
  • PKR 4999
  • 4 - 6 weeks
  • 01/05/2023
Course

Course Design & Development

Dr Launa Gauthier & Talha Dogar
  • Coming Soon
Course

Personal Health & Wellness – A Manual

Dr Basmaa Ali
  • Coming Soon
Course

Machine Learning

Dr Agha Ali Raza
  • Coming Soon
Previous
Next

Related Masterclasses

Explore all >
< Back to LUMS

About Us

  • Our Purpose
  • FAQS
  • Faculty
  • Partners
  • Our Purpose
  • FAQS
  • Faculty
  • Partners

Schools

  • SBASSE
  • MGSHSS
  • SDSB
  • SOE
  • SAHSOL
  • SBASSE
  • MGSHSS
  • SDSB
  • SOE
  • SAHSOL

Centers

  • LLI
  • REDC
  • CES
  • GCLL
  • LLI
  • REDC
  • CES
  • GCLL
2023 (C) Lahore University of Management Sciences. All Rights Reserved
Facebook-f Instagram Youtube Twitter Linkedin-in