Excel Tips and Tricks

• Excel Function to Extract a Word or Text from a Cell
• MS-Excel Self-Skill test for free
• My Office program did not open a recovered file
• Upload Macros Enabled Excel Spread Sheet on One Drive Account
• Calculate Average Excluding Zeros in Excel
• How to make cells Unclickable (Unselectable) in Excel
• Arrange and View Multiple Worksheets at Once in Excel 
• Count Specific Errors in excel 
• Count the Errors in a Range of cells in Excel 
• Extract data from a long and between of the string in Excel
• How to select cells, ranges, rows, or columns in Excel
  
  

  
  
  

  Excel Functions:

• CHAR function in Excel
• MID Function in MS-Excel 
• CELL Function in MS Excel
• VLOOKUP Function in MS Excel
• ISEVEN Function in Excel 
• TRIM Function in Excel 
• REPLACE Function in Excel
• SUBSTITUTE Function in Excel
• MIN Function in MS-Excel
• ADDRESS Function in MS-Excel
• AND Function in MS-Excel
• ODD Function in MS-Excel
• N Function in MS-Excel
• MONTH Function in MS-Excel
• MINUTE Function in MS-Excel
• NOW Function in MS-Excel
• RIGHT Function in MS- Excel
• LEN Function in MS-Excel
• FIND Function in MS-Excel
• CELL Function to Pick the File Name & File Path By MS-Excel Formula
• EDATE Function in MS-Excel
• SUM and the OFFSET Function in MS-Excel
• DATEDIF Function for age calculation
• SEARCH Function in MS-Excel 
• IF Function in Microsoft Excel

       Excel Shortcuts:

• Excel Ribbon Tab Shortcuts for Windows
• Shortcuts to Make Selections in Excel
  
• Formatting Cell Shortcuts in Excel
• Inside the Ribbon Shortcuts in Excel
  
• Frequently Used Keyboard Shortcuts For Mac & Windows in Excel
  
• Excel Cell Navigation Shortcuts For Mac & Windows
• Formula Shortcuts For Mac & Windows
• Excel Shortcut Keys
• Increase Productivity Using Top Excel Keyboard Shortcuts
• AutoSum Shortcut Key in MS-Excel

 

       Excel VBA:

• How to Install the Macro
• Use Special Characters in Excel Formula or in VBA Code
• Best Links to Learn Advance Excel / Macro
• Create a Custom Function in Excel - UDF
• Show a Processing Window While Macro Runs
• VBA Code for excel to send multiple emails using Outlook
• How to Select Filtered Values using VBA
• Overwrite an Existing File Using VBA Code in Excel