Select Page

Learn Excel Quickly With Excel Boot Camp

Excel Boot Camp is an easy way to come up to speed with Excel topics. Twice a week (Tuesday and Thursday evenings) I will point you to an Excel Video. Watch those two videos each week and in no time you will be faster and more accurate as you create increasingly powerful spreadsheets. Start with the fundamentals of Excel.  The very basics.  Learn shortcuts to cut, copy, paste, and print.  Navigate throughout your spreadsheet and slowly add more functionality over time.  Following is the current Excel Boot Camp list:

#255 Advanced Filtering Part 5

#254 Advanced Filtering Part 4

#253 Advanced Filtering Part 3

#252 Advanced Filtering Part 2

#251 Advanced Filtering Part 1

#250 Excel Table Slicers Part 2

#249 Excel 2013 Table Slicers Part 1

#248 Search Box Filter

#247 Text, Number, and Date Filters

#246 Manual Filtering in Tables

#245 Sorting by Color in Tables

#244 Excel Functions Every Excel User Should Know, Part 6 — Article

#243 Sorting in Tables

#242 Excel Functions Every Excel User Should Know, Part 5 — Article

#241 Excel 2013 Tables

#240 Timelines – Part 2

#239 Excel Functions Every Excel User Should Know, Part 4 — Article

#238 Timelines – Part 1

#237 Excel Functions Every Excel User Should Know, Part 3 — Article

#236 Quick Analysis – Tables and Sparklines

#235 Excel Functions Every Excel User Should Know, Part 2 — Article

#234 Quick Analysis Totals

#233 Excel Functions Every Excel User Should Know, Part 1 — Article

#232 Quick Analysis — Charts

#231 Working with Spreadsheet Tabs, Part 3 — Article

#230 Quick Analysis — Formatting

#229 Working with Spreadsheet Tabs, Part 2 — Article

#228 Flash Fill

#227 Working with Spreadsheet Tabs, Part 1 — Article

#226 Introducing Excel 2013

#225 Freezing Columns — Article

#224  Using Arrays to See if a List is Unique

#223 Sparklines Part 2 — Article

#222 Using Arrays to See if Data is Sorted

#221  Sparklines Part 1 — Article

#220 Using Arrays with TRUNC and Using Arrays to Sort

#219 Excel Charting Tips Part 4 — Article

#218 Using Arrays with ABS

#217 Excel Charting Tips Part 3 — Article

#216 Using Arrays to Exclude Values

#215 Excel Charting Tips Part 2 — Article

#214 Using Arrays to Average and to Count Errors

#213 Excel Charting Tips Part 1 — Article

#212 Using Arrays to Sum Ranges with Errors

#211 Make Printing Spreadsheets Easier Part 2 — Article

#210 Using LARGE to Find the Last Referral Part 2

#209 Make Printing Spreadsheets Easier Part 1 — Article

#208 Using LARGE to Find the Last Referral

#207 Handling Excel’s IFERROR — Article

#206 Using Arrays with SMALL, Part 3

#205 Excel’s Insert Function Tool — Article

#204 Using Arrays with SMALL, Part 2

#203 Using Arrays with SMALL

#202 Using SMALL to Find the Third Next Available Appointment

#201 Absolute vs Relative References in Excel — Article

#200 ROUND in an Array

#199 Business Intelligence for Medical Practices — Article

#198 LEN in an Array

#197 Document Your Work with Excel’s Comments Function — Article

#196 SUM With OR Criteria in an Array

#195 Paste As You Like It — Article

#194 SUM and Multiple IFs in an Array

#193 Excel Shortcuts to Cut, Copy, and Paste Data — Article

#192 SUM and IF in an Array

#191 Remove Duplicates Quickly and Painlessly in Excel — Article

#190 Using Arrays to Copy Data

#189 Flash Fill in Excel 2013 – Article

#188 Transposing Arrays

#187 Data Validation — Article

#186 Changing Named Array Constants

#185 Excel’s Financial Functions — Article

#184 Naming an Array

#183 Calculating Weekdays in Excel — Article

#182 Using Constants in an Array Formula

#181 Summing Data in Excel — Article

#180 Constants in Array Formulas

#179 Conditional Formatting Part 4 — Article

#178 Deleting, Moving, and Expanding Array Formulas

#177 Conditional Formatting Part 3 — Article

#176 Multi-Cell Array Formulas

#175 Conditional Formatting Part 2 — Article

#174 Introducing Arrays

#173 Conditional Formatting Part 1 — Article

#172 Data Tables Tips and Tricks

#171 Advanced Table Features — Article

#170 Data Tables with Three Variables

#169 Using Excel Tables to Manipulate Billing Data — Article

#168 Data Tables with Two Variables

#167 Use Excel to Manipulate Patient Names and More — Article

#166 Introducing Data Tables

#165 Using Data Wisely — Article

#164 Scenario Manager Pivot Table and Merging Scenarios

#163 If — Article

#162 Scenario Manager Summary

#161 Moore Filling Works Great — Article

#160 Introducing Scenario Manager

#159 How to Find (and Replace) What You’re Looking For – Article

#158 Loading and Saving Solver Scenarios

#157 Measure Meaningful Use – Article

#156 Solving for Min and Max

#155 Using Microsoft Excel’s Pivot Table Feature to Turn Medical Billing Data into Actionable Practice Knowledge – Article

#154 Solver Reports

#153 Introducing Microsoft Excel’s Pivot Table Feature – Article

#152 Changing Constraints in Solver

#151 Three Ways to Manage the Future Using Appointment Data – Article

#150 Introducing Solver

#149 Goal Seek Part 2

#148 Introducing Goal Seek

#147 Create a Pivot Chart from Scratch

#146 Pivot Chart Field Buttons

#145 Introducing Pivot Charts

#144 Pivot Table Custom Subtotals

#143 Pivot Table Layouts

#142 Pivot Table Style Options

#141 Remove Deleted Items From Pivot Table Drop Down List

#140 Pivot Table Display Options

#139 Sort Pivot Tables with Custom Lists

#138 Allow Multiple Filters per Field

#137 Pivot Table Format Options

#136 Pivot Table Layout Options

#135 Show Report Filter Pages

#134 Pivot Table Menu Tips

#133 Refreshing Pivot Table Data

#132 Pivot Table Field List

#131 Calculated Fields in Pivot Tables Part 2

#130 Calculated Fields in Pivot Tables Part 1

#129 GETPIVOTDATA Part 3

#128 GETPIVOTDATA Part 2

#127 GETPIVOTDATA Part 1

#126 Basic Formulas with Pivot Table Data

#125 Show Values as an Index in Pivot Tables

#124 Ranking in Pivot Tables

#123 Running Totals

#122 Percentage Difference from a Baseline

#121 Difference From a Baseline

#120 Percentage of a Baseline

#119 Show Values As Shortcuts

#118 Percentages of the Parent Column Total

#117 Percentages of the Parent Row Total

#116 Percentages of the Total

#115 Calculations in a Pivot Table

#114 Expanding and Collapsing Groups

#113 Grouping Text Part 2

#112 Grouping Text Part 1

#111 Grouping Dates

#110 Drill Down to Detail 

#109 Search Box Filter Part 2

#108 Search Box Filter Part 1

#107 Slicers Part 2

#106 Slicers Part 1

#105 Top 10 Filters

#104 Value Filters

#103 Date Filters

#102 Label Filters

#101 Manual Filters

#100 Manually Sorting Pivot Table Data

#99 Sorting Pivot Table Data

#98 Pivoting Rows and Columns in a Pivot Table

#97 Create a Pivot Table

#96 Stop if True

#95 Manage Conflicting Rules

#94 Manage Rules

#93 Find and Clear Conditional Formatting

#92 Formulas in Conditional Formatting

#91 Above or Below Average

#90 Top or Bottom Rules

#89 Conditional Formatting Errors and Blanks

#88 Format Based on Values

#87 Icon Sets Part 2

#86 Icon Sets Part 1

#85 Color Scales

#84 Data Bars

#83 Top Bottom Rules

#82 Highlight Cells Rules, Part 2

#81 Highlight Cells Rules, Part 1

#80 Introducing Conditional Formatting

#79 Excel and Word

#78 Finding Merged Cells

#77 Filling Blank Cells with Data

#76 Finding and Deleting Blank Rows

#75 Finding Row Differences

#74 Finding and Selecting Precedents and Dependents

#73 Finding and Selecting Visible Cells

#72 Use Go To Constants to Create a Resuable Form

#71 Go To and Go To Special

#70 Find Formats and Find All

#69 Options in the Find and Replace Window

#68 Using Wildcards to Find

#67 Find and Replace

#66 Clear

#65 Using Tables to Filter

#64 Filtering in Excel

#63 Using Tables to Sort

#62 Custom Sorting in Excel

#61 Sorting in Excel

#60 Use Fill Justify to Manage Text

#59 Fill Trends

#58 Fill Series 

#57 Fill Down, Right, Up or Left

#56 Shortcuts to Sum

#55 Format Menu

#54 Mixed Cell References

#53 Absolute Cell References

#52 Relative Cell References

#51 Formulas Across Multiple Tabs

#50 Changing Multiple Tabs at Once

#49 Writing Formulas Between Tabs

#48 Moving and Copying Tabs

#47 Introducing Tabs

#46 Insert and Delete Part 2

#45 Insert and Delete Part 1

#44 Freeze Panes

#43 Save Frustration and Save Time with AutoCorrect

#42 AutoComplete

#41 Navigating Through Excel with the Enter Key

#40 Comments on the Review Tab

#39 More Comments

#38 Comments

#37 Custom Views

#36 Hide and Unhide

#35 Cell Styles

#34 Fee Schedule Example Part 3

#33 Fee Schedule Example Part 2

#32 Fee Schedule Example Part 1

#31 Add, Subtract, Multiply and Divide

#30 Downloading Data from the Internet

#29 Text to Columns

#28 Three Ways to Get Your Data in Excel

#27 Custom Headers and Footers

#26 Headers and Footers

#25 Page Setup

#24 Page Break Preview

#23 Page Breaks, Backgrounds, and Print Titles

#22 Setting Margins and Print Area

#21 Printing Basics 

#20 Recent Workbooks and New Workbooks

#19 File Menu Basics

#18 Custom Date Formats

#17 Number and Date Formatting

#16 Orienting Cells

#15 Two Ways to Center Data

#14 Wrap Text and Alt+Enter

#13 Format Cells Part 3

#12 Format Cells Part 2

#11 Format Cells Part 1

#10 4 More Navigation Shortcuts

#9 Shift + End + Arrow Key

#8 Selecting Cells with the Control and Shift Keys

#7 Format Painter

#6 Paste Special

#5 PASTE

#4 COPY

#3 CUT

#2 Quick Access Toolbar Part 2

#1 Quick Access Toolbar Part 1