Excel Training

Training Details:#

Topic: Microsoft Excel Training#

Link:#

• Youtube - Excel Training
• Youtube - XLOOKUP Training

Training covers:#

• Microsoft Excel for Beginners

  • Entering data and navigating through a spreadsheet
  • Creating formulas to solve problems
  • Creating charts and graphs for data visualization
  • Understanding relative vs. absolute references
  • Importing and exporting data
  • Implementing VLOOKUP for data lookup
  • Using pivot tables for data analysis
  • Splitting and concatenating text for efficient data handling

• XLOOKUP

  • Handling Missing Items
  • Using Wildcards for Partial Matches
  • Simplifying Horizontal Lookups
  • Mastering Two-Way Lookups
  • Performing Approximate Matches