Login for faster access to the best deals. Click here if you don't have an account.

Microsoft Excel for Business Accounting -

2 weeks ago   Services   Gujranwala   24 views
Location: Gujranwala
Price: ₨ --

Microsoft Excel for Business Accounting -


The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.

You are taught through a combination of

  • Video lessons
  • Online study materials

Course design

This course is designed with the following modules:

Excel Basics

  • Create a Basic Worksheet
  • Use the Help System
  • Create Formulas in a Worksheet
  • Insert Functions in a Worksheet
  • Reuse Formulas
  • Manipulate Data
  • Insert, Manipulate, and Delete Cells, Columns, and Rows
  • Search For and Replace Data
  • Spell Check a Worksheet
  • Apply Number Formats
  • Align Cell Contents
  • Apply Cell Styles
  • Define the Basic Page Layout for a Workbook
  • Refine the Page Layout and Apply Print Options
  • Format Worksheet Tabs
  • Manage Worksheets
  • Manage the View of Worksheets and Workbooks
  • Customize Formula Options
  • Customize the Functionality of Excel by Enabling Add-Ins

Intermediate Functions

  • Apply Range Names
  • Use Specialized Functions
  • Use Text Functions
  • Use Logical Functions
  • Use Lookup Functions
  • Use Date Functions
  • Use Financial Functions
  • Create and Modify Tables
  • Sort and Filter Data
  • Use Subtotal and Database Functions to Calculate Data
  • Create Charts
  • Modify and Format Charts
  • Create a Trendline
  • Create Advanced Charts
  • Create a PivotTable
  • Filter Data by Using Slicers
  • Analyze Data with PivotCharts
  • Preparing a Workbook for Multiple Audiences

Advanced Features

  • Update Workbook Properties
  • Create and Edit a Macro
  • Apply Conditional Formatting
  • Add Data Validation Criteria
  • Trace Cells
  • Troubleshoot Invalid Data and Formula Errors
  • Watch and Evaluate Formulas
  • Create a Data List Outline
  • Create Sparklines
  • Create Scenarios
  • Perform a What-If Analysis
  • Perform a Statistical Analysis with the Analysis ToolPak
  • Create Interactive Data with Power View
  • Consolidate Data
  • Link Cells in Different Workbooks
  • Merge Workbooks
  • Export Excel Data
  • Import a Delimited Text File
  • Create a Web Query
  • Import and Export XML Data

Whatsapp: , , O3O3553O 865 O321 96O67  85,

IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

Home Cleaning
Home Cleaning