Skip to content

Instantly share code, notes, and snippets.

@cmarchena

cmarchena/excel102.md

Created March 15, 2023 13:56
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save cmarchena/2e46011d0a2875dff736fe1e83666088 to your computer and use it in GitHub Desktop.
Save cmarchena/2e46011d0a2875dff736fe1e83666088 to your computer and use it in GitHub Desktop.
Download ZIP
Excel 102
Raw
excel102.md

Excel 102

  • Pivot tables: what are pivot tables and why they are useful for data analysis, how to create a pivot table from a table or a range of data, how to arrange fields in rows, columns, values and filters areas , how to apply different calculations and formats to pivot table data , how to use pivot charts and slicers, etc.
  • Data analysis and visualization: how to use various tools and techniques in Excel to analyze and visualize data, such as what-if analysis, goal seek, solver, scenarios, data tables, histograms, box plots, trendlines, etc.
  • Macros and VBA: what are macros and VBA and how they can automate tasks in Excel, how to record and run a macro, how to edit and debug a macro code in the Visual Basic Editor (VBE), how to create user-defined functions (UDFs) and user forms in VBA, etc.
  • Power Query and Power Pivot: what are Power Query and Power Pivot and how they can enhance data processing and modeling in Excel, how to import and transform data from various sources using Power Query Editor (PQE), how to create relationships and calculations using Data Analysis Expressions (DAX) in Power Pivot Manager (PPM), etc.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment