Fintech (Financial Technology) revolution 

Fintech refers to the use of technology in terms of new processes, business models, products or applications to improve financial operations. By utilizing specialized algorithms and software, businesses are able to better manage their financial processes and operations. 

Example: ATMs were once considered cutting-edge fin tech, as were signature-verification technology, which were first utilised by banks in the 1860s. Fin tech helps firms manage their financial procedures and operations more effectively. Crowd funding platforms, mobile payments, crypto currencies, block chain, and insurance are all examples of fin tech.

Indian Prime Minister Narendra ji called for a “Fin tech revolution” in India with a “security shield” on December 3, 2021, at the launch of In finite forum on Fin tech.

The Indian fin tech industry has a cumulative funding of over US$27.6 billion and is expected to be valued at over US$150 billion by 2025.

   -Amitabh Kant (CEO, NITI Aayog),

 

Fin tech market in India

 

In India, there are approximately 2100 Fin tech firms. The Indian market is becoming accepting of super applications. It's also worth mentioning that Big Tech companies like Google, Amazon, and WhatsApp have adjusted their operations in India to give specialised options like Google Pay, Amazon Pay, and WhatsApp Payments. Paytm, a payment app, is also on track to become a Super app.

Major trends driving fin tech revolution in India 

·         Supply side factors
·         Governmental initiatives
·         Investments in India’s Fin tech sector
·         Investments in India’s Fin tech sector
·         Demographic opportunities in India
·         Demand side factors
·         Technological advancements

Different Fin tech segments in India 

• Pay Tech
• Lend Tech:
• Digital banking
• InsurTech
• Wealth Tech
• Finance Fin tech: The various services that can be provided in this segment include:
• Accounting: 
•  Procure to pay
• Quote to cash
• Taxation
• Reconciliation
• Regulation Tech

Can you excel yourself without using a mouse?

 

Microsoft Excel

 

-Can you excel yourself without using a mouse? 

 

By using keyboard shortcuts and key commands, Microsoft Excel may be utilized effectively without a mouse. You can carry out the following routine actions using the keyboard shortcuts listed below:

 

v  Navigating Cells:

v  Selecting Cells:

v  Editing Cells:

v  Formatting Cells:

v  Working with Worksheets and Workbooks:

v  Formulas:

v  Managing Rows and Columns:

v  AutoFill and Data Entry:

v  Working with Charts:

v  Find and Replace:

v  Working with Ribbon and Menus:

v  Undo and Redo:

 

keyboard shortcuts and key commands

 

v      Navigating Cells:

 

·         Move one cell in any direction: Arrow keys (Up, Down, Left, Right).

·         Move to the edge of data region: Ctrl + Arrow keys.

 

v Selecting Cells:

 

·         Select one cell: Arrow keys.

·         Select a range of cells: Shift + Arrow keys.

·         Select the entire column or row: Ctrl + Space (Column) or Shift + Space (Row).

v Editing Cells:

·         Enter Edit mode: F2 or Enter.

·         Exit Edit mode: Enter (to move down) or Tab (to move right).

·         Cancel Edit mode: Esc.

·         Copy: Ctrl + C, Cut: Ctrl + X, Paste: Ctrl + V.

v Formatting Cells:

·         Open Format Cells dialog box: Ctrl + 1.

·         Bold: Ctrl + B, Italic: Ctrl + I, Underline: Ctrl + U.

·         Increase Font Size: Ctrl + Shift + >, Decrease Font Size: Ctrl + Shift + <.

v 

Working with Worksheets and Workbooks:

·         Move to next worksheet: Ctrl + Page Down, Move to previous worksheet: Ctrl + Page Up.

·         Save workbook: Ctrl + S, Open workbook: Ctrl + O, Create new workbook: Ctrl + N.

·         Close workbook: Ctrl + W, Close Excel: Alt + F4.

v 

Formulas:

·         Enter formula bar: F2.

·         Recalculate worksheet: F9, Recalculate all worksheets: Ctrl + Alt + F9.

v 

Managing Rows and Columns:

·         Insert row: Ctrl + Shift + + (Plus key), Insert column: Ctrl + Space, then Ctrl + Shift + + (Plus key).

·         Delete row: Ctrl + - (Minus key), Delete column: Ctrl + Space, then Ctrl + - (Minus key).

v 

AutoFill and Data Entry:

·         AutoFill: Select the cell with data, hold down the Ctrl key, and drag the fill handle (small square at the bottom-right corner of the selected cell).

·         Data Validation: Alt + D, L, then use arrow keys and Enter to navigate and select options.

v 

Working with Charts:

·         Create a chart: Alt + F1.

·         Move between elements in a chart: Tab key.

v 

Find and Replace:

·         Find: Ctrl + F, Replace: Ctrl + H.

v 

Working with Ribbon and Menus:

·         Navigate Ribbon tabs: Alt, then use arrow keys.

·         Access context menus: Shift + F10 or the Application key (usually located between the right Alt and Ctrl keys).

v Undo and Redo:

·         Undo: Ctrl + Z, Redo: Ctrl + Y.

         These are just a few of the typical operations that Excel allows you to complete without the use of a mouse. When using Excel just from the keyboard, becoming familiar with these keyboard shortcuts will greatly increase your productivity.