Outline Course contentPart I. Getting readyWhat you'll learn What you'll need Mindsets Using this site Part II. How computers run programsComputing the tip CPU arithmetic Program structure From Eva to Excel Iffy variables More exercises Summary Part III. Building blocksExpressionsNumeric expressions String expressions If statements and logical expressions More exercises Summary ThunkingChunks and patterns Dudes at work Patterns nest Web page output More exercises Summary BugsTypes of bugs Breakpointing Lily, Klaus, taxes, and bugs More exercises Summary SubroutinesBetter thunking Subing a program Subing a sub Reusing code User input and flags Stubs More exercises Summary Part IV. Data analysisTwo big ideasIndexes Loops Indexes and loops are BFFs Summarizing dataAccumulators Finding the end Filtering data Extracting dataExtracting to a worksheet Extracting to an array From array to data file Basic data analysis programsReading a file Frequencies More exercises Extra: Beyond one dimensionSummary worksheets Data records Data grids Extra: DashboardsProgramming charts Workbook structure Assemble the pieces What now? Tips and tricksManage your time Configuring Excel for VBA Save as XLSM Adding a button to run a program Option Explicit and declaring variables Coding standards Shortcut keys Finding stuff on this site VBA online documentation Free programming books Rounding numbers in Excel VBA ‹ Extra: Beyond one dimension up Data records ›
