Have a question?
Message sent Close
0
0 reviews

Advanced Excel

After completion of the course, you can get a suitable position in any organization as an Accounts Assistant, Finance Analyst, ... Show more
  • Description
  • Curriculum
  • Reviews

What you’ll learn ?

 

After completion of the course, you can get a suitable position in any organization as an Accounts Assistant, Finance Analyst, Retail Store Manager and Data Analyst in any organization.

 

Important Dates

 
  • Batch Commencement: One batch in each calendar month (January to December)
  • Date(s) of Application and Fee Payment by Learner: 1st – 30th day of each calendar month
  • Date(s) of Learner Confirmation by ALC: 1st – 30th day of each calendar month
  • Course Start Date and Date of Issuing Learner Login: Date of admission confirmation

The syllabus covers the following skills:

  1. Apply custom formats and layouts
  2. Create advanced formulas
  3. Use of Scenario
  4. Pivot tables and charts
  5. Manage and share workbooks
Outputs:

Organizing the data professionally, Using Metadata and Big Data, Internationalization for Excel Workbooks, data segregation using custom formats and layouts, Dashboard creation using Power Query and Power Pivot table, Using Power Map, Connecting Excel workbooks to external data, preparing a checklist for data collection using Canva, Data collection for social media marketing

Apply Custom Formats and Layouts
Create advanced formulas
Slide4.JPG
Course details
Duration 2 Months
Lectures 71
Video 144
Level Beginner

Archive

Working hours

Monday 8:00 am - 6.00 pm
Tuesday 8:00 am - 6.00 pm
Wednesday 8:00 am - 6.00 pm
Thursday 8:00 am - 6.00 pm
Friday 8:00 am - 6.00 pm
Saturday 8:00 am - 6.00 pm
Sunday 8:00 am - 6.00 pm