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
