Online Diploma in Microsoft Excel

Sold By:Comptech Global Link Limited

Highlights

  • Online Diploma in Microsoft Excel 

Spreadsheet Basics:

  • Objectives                                                                                                                           
  • Create a new file
  • Enter and format text
  • Add borders
  • Work with cells
  • Add header and footer
  • Print the Worksheets
  • Work with Templates
  • Managing data in Excel
  • Objectives
  • Working with rows and columns
  • Formatting numbers
  • Using Functions
  • Sorting data
  • Creating references
  • Filtering data
  • Linking data
  • Using Enhanced Worksheet Features
  • Objectives
  • Create and Format Charts
  • § Microsoft Advanced Excel
  • Formulas and Functions
  • Entering Formulas
  • Entering Functions
  • Reference Operators
  • Autosum
  • Function Wizard
  • Function instead of a Formula
  • Copying Formulas/Functions and Cell References
  • Relative Cell References
  • Absolute Cell References
  •  Mixed Cell References
  • Order of Operations 
  • Using Named Ranges Formulas and Functions

Redemption Process: The Training link will be sent to the participants through google cloud by sending your (Gmail account) 

  • Coupon(s) valid until 2017-05-17 (unused Coupons after this date will not be honoured/refunded by Merchant/DealDey)
    • Multiple Coupons may be purchased
    • Coupons numbers or QR codes must be presented for redemption
    • Download Coupon for Merchant’s details 
    • Reservation must be made before redemption
    • Please call 01-4609950 | 08094609951 for more payment enquiries 
  • Terms and conditions apply
  • Details

    Microsoft excel is an interactive computer application program for organization, offices, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array is a model–view–controller element that may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells. Microsoft excel users may adjust any stored value and observe the effects on calculated values. This makes the spreadsheet useful for “what-if” analysis since many cases can be rapidly investigated without manual recalculation. Modern spreadsheet software can have multiple interacting sheets, and can display data either as text and numerals, or in graphical form. Microsoft excel have replaced paper-based systems throughout the business world. Although they were first developed for accounting or bookkeeping tasks, they now are used extensively in any context where tabular lists are built, sorted, and shared. Advantages of Using Spreadsheets/ Microsoft Excel Microsoft excel offer a range of advantages, particularly to business users. Popular spreadsheet programs provide the tools to analyze and visualize data sets in accessible ways. If you have a set of data related to numerical, financial, statistical or other information, you can use a spreadsheet not only to store this data but also to manage it, perform analytical processing on it and present it. Spreadsheets provide complex processing in ways that even people with little technical experience can access. Comptech is a leading professional training based in Abuja Nigeria with core competence in the area of IT Professional training. We employ consultants from a wide variety of backgrounds who bring varied experience and multiple perspectives to projects and training. We are also committed to delivering the best and highest quality training at very affordable costs with experienced professionals handling all training modules.

    Comptech Global Link Limited 3, Olawaye Street, Anifowoshe, Ikeja, Lagos, Nigeria
    DealDey Helpline

    01-4609950, 08094609951

    Reviews

    There are no reviews yet.

    Be the first to review “Online Diploma in Microsoft Excel”

    Sold By:Comptech Global Link Limited

    Highlights

    • Online Diploma in Microsoft Excel 

    Spreadsheet Basics:

    • Objectives                                                                                                                           
    • Create a new file
    • Enter and format text
    • Add borders
    • Work with cells
    • Add header and footer
    • Print the Worksheets
    • Work with Templates
    • Managing data in Excel
    • Objectives
    • Working with rows and columns
    • Formatting numbers
    • Using Functions
    • Sorting data
    • Creating references
    • Filtering data
    • Linking data
    • Using Enhanced Worksheet Features
    • Objectives
    • Create and Format Charts
    • § Microsoft Advanced Excel
    • Formulas and Functions
    • Entering Formulas
    • Entering Functions
    • Reference Operators
    • Autosum
    • Function Wizard
    • Function instead of a Formula
    • Copying Formulas/Functions and Cell References
    • Relative Cell References
    • Absolute Cell References
    •  Mixed Cell References
    • Order of Operations 
    • Using Named Ranges Formulas and Functions

    Redemption Process: The Training link will be sent to the participants through google cloud by sending your (Gmail account) 

  • Coupon(s) valid until 2017-05-17 (unused Coupons after this date will not be honoured/refunded by Merchant/DealDey)
    • Multiple Coupons may be purchased
    • Coupons numbers or QR codes must be presented for redemption
    • Download Coupon for Merchant’s details 
    • Reservation must be made before redemption
    • Please call 01-4609950 | 08094609951 for more payment enquiries 
  • Terms and conditions apply
  • Details

    Microsoft excel is an interactive computer application program for organization, offices, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array is a model–view–controller element that may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells. Microsoft excel users may adjust any stored value and observe the effects on calculated values. This makes the spreadsheet useful for “what-if” analysis since many cases can be rapidly investigated without manual recalculation. Modern spreadsheet software can have multiple interacting sheets, and can display data either as text and numerals, or in graphical form. Microsoft excel have replaced paper-based systems throughout the business world. Although they were first developed for accounting or bookkeeping tasks, they now are used extensively in any context where tabular lists are built, sorted, and shared. Advantages of Using Spreadsheets/ Microsoft Excel Microsoft excel offer a range of advantages, particularly to business users. Popular spreadsheet programs provide the tools to analyze and visualize data sets in accessible ways. If you have a set of data related to numerical, financial, statistical or other information, you can use a spreadsheet not only to store this data but also to manage it, perform analytical processing on it and present it. Spreadsheets provide complex processing in ways that even people with little technical experience can access. Comptech is a leading professional training based in Abuja Nigeria with core competence in the area of IT Professional training. We employ consultants from a wide variety of backgrounds who bring varied experience and multiple perspectives to projects and training. We are also committed to delivering the best and highest quality training at very affordable costs with experienced professionals handling all training modules.

    Comptech Global Link Limited 3, Olawaye Street, Anifowoshe, Ikeja, Lagos, Nigeria
    DealDey Helpline

    01-4609950, 08094609951

    Reviews

    There are no reviews yet.

    Be the first to review “Online Diploma in Microsoft Excel”