Advanced MS. Excel Course

User Avatar
₨10,000.00 ₨5,000.00

COURSE DESCRIPTION

Microsoft Excel is one best tool that every business organization prefers to choose. Every employer understands that MS Excel has the right functions that they need for his business. Certainly, organizations, whether small, medium or corporate entities require MS Excel professionals. And if the person has the ability to use the MS Excel with advanced features, such as VBA and Macros, then it is much like icing on the cake. The ICT Academy is conducting the Advanced Excel Course in Karachi for all those looking to become the Excel professionals. This MS. Excel Training Institute in Karachi is well-versed in delivering the right knowledge to its students that may help them glitter their resume and find a suitable job.

WHAT WILL YOU LEARN?

This course will make the students learn:

  • The comprehensive usage of the basic and advanced MS Excel, ranging from the standard formatting to the complex operations that are required by almost every other organization;
  • The advanced Excel techniques that include the complex operation of the MS Excel, such as the RANDBETWEEN, VLookup and some other logical functions;
  • The application of the logical and other complex functions with their practical approach and usage in the day to day professional course of life and,
  • The application of the Visual Basic for Applications (VBA) and the Microsoft Excel Macros.

ADVANCED MS. EXCEL COURSE OUTLINE

Lesson 1: Working with Advanced Functions

  • Working with Functions
  • Using the IF Function
  • Nesting Functions
  • Using Multiple Conditions with the IF Function
  • Using Table Lookup Functions (HLookup and VLookup)
  • Using Text Functions

Lesson 2: Analyzing Data

  • Using Automatic Outlining
  • Consolidating Information by Position or Category
  • Inserting Subtotals
  • Creating an Advanced Filter
  • Using Database Functions

Lesson 3: Working with Data

  • Importing Data from a Text File
  • Exporting Data
  • Converting Text to Columns
  • Connecting to Data in an Access Database
  • Creating a Web Query
  • Importing Web Data using a Saved Query
  • Working with Hypertext Links

Lesson 4: Creating and Working with PivotTables

  • Understanding PivotTables
  • Creating a PivotTable using Worksheet Data
  • Creating a PivotTable using an External Data Connections
  • Laying out a PivotTable on a Worksheet
  • Modifying PivotTable Fields
  • Using a Report Filter
  • Refreshing a PivotTable
  • Formatting a PivotTable

Lesson 5: Enhancing PivotTables

  • Working with Summary Functions
  • Sorting Items in a PivotTable
  • Creating a Slicer
  • Grouping Data
  • Applying Label and Value Filters
  • Creating a Calculated Field
  • Creating a Calculated Item
  • Creating Charts from PivotTables

Lesson 6: Working with Data Analysis Tools

  • Creating Scenarios
  • Working with Scenarios
  • Using Goal Seek
  • Using One-Input Data Tables
  • Using Two-Input Data Tables
  • Understanding Solver
  • Defining a Problem
  • Solving a Problem
  • Generating a Report of Results and Alternate Solutions

Lesson 7: Working with Macros

  • Recording a Macro
  • Saving a Macro-Enabled Workbook
  • Executing a Macro
  • Creating a Macro Button
  • Working with Macro Buttons

Microsoft Office 2016Advanced Microsoft ExcelSearch Engine Optimization (SEO)Social Media Marketing (SMM)PHP with MySQLWordPress Website DevelopmentAmazon Web Server (AWS)Project Management Professional (PMP)Angular 8 TrainingMean Stack TrainingGraphic DesignEnglish Language

Course Features

  • Lectures 0
  • Quizzes 0
  • Duration 36 hours
  • Skill level All levels
  • Language Urdu
  • Students 0
  • Assessments Yes
Curriculum is empty
₨10,000.00 ₨5,000.00