Friday CLOSED

Sat - Thu 10.00 am - 08.00 pm

Call : 021-3498-6664, 0312-216-9325, DHA 021-35344-600

Ms Office – Advanced Excel with Outlook


Be the first to rate Advanced Excel
Or log in to access your purchased courses
by admin
Price: 8,000.00 6,000.00
2 Months
0 Lessons

COURSE DESCRIPTION

Certificate-Advanced-Excel

Ms Office – Advanced Excel Course (with Outlook)

Microsoft Excel is a leading and very high-demand office automation tool used all across industries for example Banks, Insurance, Telecom, Public Sector and many Small and Medium size Organization to perform Complex calculations, Data Analysis, Reporting and Dashboards creation, understanding financial modeling, learning Advanced Excel is a highly valuable career Asset, a must-have criteria to qualify for many jobs!

Course participants will learn all the key Excel functions and features using Advanced Microsoft Excel tools from basic to mastery level of excel expertise, after completing the course participants would be able to perform their day-to-day job in more productive and professional way to improve organizational performance. A best and most affordable advanced excel training @ Omni Academy.

Advanced Excel Course

Course Content:

Module-I – Excel Foundation 

  • Formula Basics & Cell References
  • Auto Fills & Custom Lists
  • Working with Basic Excel Functions
  • Using Smart Tables
  • Sorting & Filtering Data
  • Working with Conditional Formats
  • Working with Charts
  • Using Subtotal

Module-II – Formula | Data | Charts Concepts

  • Formula Basics & Cell References
  • Auto Fills & Custom Lists
  • Working with Basic Excel Functions
  • Using Smart Tables
  • Sorting & Filtering Data
  • Working with Conditional Formats
  • Working with Charts

Module-III –  Using Advanced Functions

  • Working with Named Ranges
  • Using Complex Excel Functions
  • Using Multi-sheet Formulas
  • Using Advanced Filters
  • Data Validation & Protection
  • Consolidation & List Management
  • Automating with Macros

Module-III – Reporting & Dashboards 

  • Business Reporting with Excel Dashboards
  • Advanced Charting & Visualizations
  • Using Sparkline Charts
  • Creating Interactive Dashboard Reports

Module-IV – Working with Macros & Custom Functions 

  • Writing Customized Macros
  • Using What-If-Analysis
  • Working with Financial Functions
  • Creating Custom Excel Functions

MS Outlook Introduction (*Bonus Item for Corporate Students)

  • Use Outlook features efficiently
  • Organize and compose emails
  • Work with contacts
  • Use calendar features
  • Complete Outlook tasks

Ms Outlook – Key Learning

  • Using Email, calendar and contacts: Schedule appointments, send emails and create and delegate tasks all from one central location.
  • Get offline email access: Access email anytime, anywhere with Outlook’s offline email access.
  • Organize email: Sort messages into folders, forward or flag items to organize your inbox and minimize clutter.
  • Share and delegate calendars: Schedule meetings with coworkers quickly by sharing calendars.
  • Manage contacts: Outlook offers detailed contact information to easily manage and communicate with contacts.

 

Duration: Two Month – Approx (Fast Track Available)

Flexible Class Options

  • Evening Classes | Corporate Workshops | Fast-Track
  • Week End Classes For Professionals  SAT / SUN
  • Online Classes – Live Virtual Class (L.V.C), Online Training

-30% Discount on group of ten (10) or more
-20% Discount for Omni student

Trainer profile:

Trainer: Mr. Kashif uddin

Sir Kashif is Microsoft Certified Trainer, Industry Experience Trainer, Delivered 100+ sessions.
Professional Background: IT trainer at IBA, Sr. learning technology facilitator at Agha Khan education service.

Related Courses

Computerized Accounting Course 

Advanced Excel Guru 

Financial Modeling Course

Microsoft Certified Solutions Associate (MCSA) Office 365

KEY FEATURES

Flexible Classes Schedule

Online Classes for out of city / country students

Free Practice Exam

Weekend Classes for Professionals

Internship| Job Referral

Step-by-step Learning, Basic to Advanced Level

Inquire Now

Select Country:
Enter Phone e.g 923451234567
Branch
Online
Enter Code Below

Inquire Now

Lessons

Or log in to access your purchased courses
Course participants will learn all the key Excel functions and features using Advanced Microsoft Excel tools from basic to mastery level of excel expertise.
ABOUT US

OMNI ACADEMY is one of the most prestigious Training, Consulting & Digital Marketing firm, founded in 2010, under MHSG Consulting Group aim to help our customers in promoting brands, build preference, more engage with customers and increase sales through digital transformation. We are helping People to Get Valuable Skills and Get Jobs.

Read More

Contact Us

Get your self enrolled for unlimited learning 500+ courses, Corporate Group Training, Instructor led Class-Room and ONLINE learning options. Join Now!
  • Gulshan Campus : A-242, Sardar Ali Sabri Rd. Block-2, Gulshan-e-Iqbal, (Near Rab Medial) Karachi.
  • Dha Campus: 14-C, Saher Commercial Area, Phase VII, Defence Housing Authority, Karachi-75500 Pakistan. 02135344600 , 966502283468
  • 021 3498 6664(OMNI), 033 77 222 191, 0312 2169 325
  • info@omni-academy.com
WORKING HOURS

  • Monday9.30am - 8.00pm
  • Tuesday9.30am - 8.00pm
  • Wednesday9.30am - 8.00pm
  • Thursday9.30am - 8.00pm
  • FridayClosed
  • Saturday9.30am - 8.00pm
  • Sunday9.30am - 8.00pm
WhatsApp chat