Home->Course->IT courses
MS Excel  The Core Knowledge

MS Excel The Core Knowledge

Mastering the basic Excel functionalities and functions are critical for beginners to become highly proficient in financial analysis and so on. Microsoft Excel is considered the industry standard piece of software in data analysis. Microsoft’s spreadsheet program also happens to be one of the most preferred software by investment bankers and financial analysts in data processing, financial modelling, and presentation. This course provides an overview and a list of basic Excel functionalities.

Course Features

Excel Interface

  • Customizing The Quick Access Toolbar
  • Working With The Ribbons
  • File Menu

Selecting and Entering Data

  • Entering Text And Numbers
  • Entering Numbers As Text
  • Inputting Dates And Times
  • Using Copy And Paste
  • The FILL Handle
  • Inserting Cells , Columns And Rows
  • Hiding And Unhiding A Column Or Row
  • Searching For Values In A Worksheet

Developing a workbook

  • Formatting And Naming Of Worksheet Tabs
  • Moving Worksheets Within And Between Workbooks
  • Copying Worksheets Within Workbooks
  • Inserting And Deleting Worksheets
  • Viewing More Than One Workbook
  • Hiding And Unhiding Worksheets

Workbook formatting

  • Modifying Typeface , Font Size And Colors
  • Merging Cells
  • Applying Number Formats
  • Aligning Cell Contents
  • Changing The Text Direction In A Cell
  • Adding Borders To Cells And Ranges
  • Applying A Date Format To A Cell Or Range
  • Use Of The Format Painter

Excel calculation

  • Introduction To Excel Formulas SUM
  • Copying Formulas And Functions
  • Displaying Formulae On A Worksheet
  • Introduction To Excel Formulas AVERAGE
  • Introduction To Excel Formulas COUNTING
  • Absolute Referencing Requirements
  • Making Use Of Named Cells And Ranges

Advanced formatting   

  • Enhancing Worksheets Using Themes
  • Working With Comments
  • Creating Own Auto Fill List
  • Tables in excel

Security

  • Protection On A Worksheet
  • Protecting Part Of A Worksheet To Facilitate Data Entry
  • Saving A Workbook With Password Protection

Excel Template

  • Creating A Workbook From A Template
  • Creating Your Custom Template

Excel Convertor

  • Convert word into excel
  • Convert Excel into word

Apply Now Inquiry