advance excel training in lahore

Soft Sunrise is One of The best Microsoft Office training accedemy in Pakistan . We teach according to the latest trends and technologies available in the Market. We Provide you a professional training and made you professional to do work according the trends. If you are looking for a good training center get admin with soft sunrise today.


advance excel training in lahore

Course Outline

Excel for Accounts

  • Excel in accounting and effective spreadsheet design
  • Managing cell and range Names
  • Date and time formulas for accounting records
  • Using Data Validation to ensure accuracy of data input
  • Accounting functions for calculating depreciation of assets / cash flows
  • Varying cell content and format with If functions and Conditional Formats
  • Looking up Accounting Data from with Vlookup and related functions
  • More complex data location for Vlookup using Index and Match functions
  • Filtering / totalling data with advanced filter, subtotals, database functions
  • Linking and consolidating data from multiple workbooks
  • Auditing and error checking your accounting spreadsheets
  • Financial Reporting: advanced graphs and charts
  • Summarising accounting data with Pivot Tables and charts
  • Automatically extending data selection with Dynamic Data Ranges
  • Forecasting: What If Analysis with Goal Seek, Solver and Scenarios
  • Forecasting and Budgeting: moving averages and trend analysis

Microsoft Excel

  • Introduction to Microsoft Excel
  • Entering and Amending Data
  • Saving and Opening Workbooks
  • Navigating and Selecting Ranges
  • Entering Formulas
  • Inserting/Deleting Rows and Columns
  • Formatting Worksheets
  • Using Simple Functions
  • Copying, Moving and AutoFill
  • Relative vs. Absolute References
  • Previewing and Printing
  • Find and Replace
  • Introduction to Range Names
  • Using Multiple Worksheets
  • Cell Styles and Conditional Formatting
  • Paste Special
  • Text and Date Formulas
  • IF Function
  • Using Charts
  • Sorting and Filtering Lists
  • Using Tables
  • SmartArt and Drawings
  • Comments and Hyperlinks
  • Importing and Exporting Data
  • Relational Database Design
  • Modifying Table Design
  • Using Lookup Fields
  • Modifying Queries
  • Outer Joins
  • Calculated Fields
  • Query Wizards
  • Simple Parameter Queries
  • Modifying Form Design
  • Controls and the Property Sheet
  • Managing Controls
  • Modifying Report Design
  • Sorting and Grouping
  • Database Management
  • Object Dependencies
  • Importing and Exporting Data
  • Managing Range Names
  • Date and Time Formulas
  • Custom Formats
  • IF and Related Functions
  • VLOOKUP and Related Functions
  • Advanced Filter / Subtotals
  • Database Functions
  • Multiple Workbooks / Consolidation
  • Data Validation
  • Auditing
  • Pivot Tables
  • Shared Workbooks / Tracking
  • Protecting Worksheets
  • Using Templates

Copyright © 2018 All rights reserved Soft Sunrise Software House and Professional Training Center .