Enrolment options
- Enrolled students: There are no students enrolled in this course.
Guests cannot access this course. Please log in.
Course content
Sections:
1
•
Activities:
0
•
Resources:
256
- 001 Ask Questions R5mz gitir
- 002 Course Exercise Files CxuD gitir
- 003 Certificate of Completion mJsm gitir
- 004 Launching Excel cqXN gitir
- 005 Microsoft Excel Startup Screen IqqE gitir
- 006 Introduction to the Excel Interface 49Je gitir
- 007 TIP Hide Excel Ribbon AXDu gitir
- 008 TIP Customizing the Excel Quick Access Toolbar UFRb gitir
- 009 More on the Excel Interface Workbook and Status Bar srgj gitir
- 010 Understanding the Structure of an Excel Workbook UYxB gitir
- 011 Saving an Excel Document s7SW gitir
- 012 Opening an Existing Excel Document iVoL gitir
- 013 Common Excel Shortcut Keys cBnI gitir
- 015 Entering Text to Create Excel Spreadsheet Titles dzcg gitir
- 016 Working with Numeric Data in Excel vZOn gitir
- 017 Entering Date Values in Excel HofD gitir
- 018 Working with Cell References IsKJ gitir
- 019 Creating Basic Formulas in Excel HwZy gitir
- 020 Relative Versus Absolute Cell References in Formulas xovo gitir
- 021 Understanding the Order of Operation DOWNLOAD EXERCISE FILE 2ycm gitir
- 023 The structure of an Excel Function Zgo5 gitir
- 024 Working with the SUM Function hZW5 gitir
- 025 Working with the MIN and MAX Functions if2v gitir
- 026 Working with the AVERAGE Function 5O6U gitir
- 027 Working with the COUNT Function buyi gitir
- 028 Adjacent Cells Error in Excel Calculations JcZX gitir
- 029 Using the AutoSum Command 3pjF gitir
- 030 Excel s AutoSum Shortcut Key ez6z gitir
- 031 Using the AutoFill Command to Copy Formulas Iln9 gitir
- 033 Moving and Copying Data in an Excel Worksheet vRgj gitir
- 034 Inserting and Deleting Rows and Columns 4jmz gitir
- 035 Changing the Width and Height of Cells 6s2J gitir
- 036 Hiding and Unhiding Excel Rows and Columns UIiR gitir
- 037 Renaming an Excel Worksheet VYpm gitir
- 038 Deleting an Excel Worksheet 4QjS gitir
- 039 Moving and Copying an Excel Worksheet KKTu gitir
- 041 Working with Font Formatting Commands HP25 gitir
- 042 Changing the Background Color of a Cell SJW8 gitir
- 043 Adding Borders to Cells NkLE gitir
- 044 Excel Cell Borders Continued jaWa gitir
- 045 Formatting Data as Currency Values qgg7 gitir
- 046 Formatting Percentages mHSJ gitir
- 047 Using Excel s Format Painter 4nzz gitir
- 048 Creating Styles to Format Data jBti gitir
- 049 Merging and Centering Cells Be5o gitir
- 050 Using Conditional Formatting 2P8A gitir
- 051 Editing Excel Conditional Formatting Us7i gitir
- 053 Inserting Images DwcJ gitir
- 054 Inserting Excel Shapes v282 gitir
- 055 Formatting Excel Shapes wPQA gitir
- 056 Working with Excel SmartArt KZk6 gitir
- 057 Creating an Excel Column Chart zH0L gitir
- 058 Working with the Excel Chart Ribbon tog3 gitir
- 059 Adding and Modifying Data on an Excel Chart RE8z gitir
- 060 Formatting an Excel Chart TnAo gitir
- 061 Moving a Chart to another Worksheet 4bSL gitir
- 062 Working with Excel Pie Charts Es32 gitir
- 065 Viewing your Document in Print Preview gYJD gitir
- 066 Changing the Margins Scaling and Orientation PRGf gitir
- 067 Excel Worksheet Margins RNVU gitir
- 068 Working with Page Layout View 7bzU gitir
- 069 Adding Header and Footer Content hlNI gitir
- 070 Printing a Specific Range of Cells 828D gitir
- 072 Intro to Excel Templates KaKH gitir
- 073 Opening an Existing Template IrSZ gitir
- 074 Creating a Custom Template NHPa gitir
- 077 Congratulations N41d gitir
- 078 Excel 102 Course Exercise Files DOWNLOAD 3R2Y gitir
- 079 Understanding Excel List Structure K3SL gitir
- 080 Sorting a List Using Single Level Sort RVK2 gitir
- 081 Sorting a List Using Multi Level Sorts AS9P gitir
- 082 Using Custom Sorts in an Excel List ltGC gitir
- 083 Filter an Excel List Using the AutoFilter Tool 8U9h gitir
- 084 Creating Subtotals in a List fPf6 gitir
- 085 Format a List as a Table 5qDE gitir
- 086 Using Conditional Formatting to Find Duplicates K2ai gitir
- 087 Removing Duplicates NvMN gitir
- 089 Introduction to Excels Function DSUM MFs8 gitir
- 090 Excel DSUM Function Single Criteria Continued numZ gitir
- 091 Excel DSUM Function with OR Criteria 0Hli gitir
- 092 Excel DSUM Function with AND Criteria MT45 gitir
- 093 Excel Function DAVERAGE VvI9 gitir
- 094 Excel Function DCOUNT 18BR gitir
- 095 Excel Function SUBTOTAL NYQ0 gitir
- 097 Understanding the Need for Excel Data Validation ek1l gitir
- 098 Creating an Excel Data Validation List eEXc gitir
- 099 Excel Decimal Data Validation a9PY gitir
- 100 Adding a Custom Excel Data Validation Error As4Q gitir
- 101 Dynamic Formulas by Using Excel Data Validation Techniques 24yZ gitir
- 103 Importing Data Into Microsoft Excel 10XP gitir
- 104 Importing Data from Text Files GRhR gitir
- 105 Importing Data from Microsoft Access kpQq gitir
- 106 NEW VERSION Import Data From Text Files into Excel kEnt gitir
- 107 NEW VERSION Import Data From a Database into Excel EpbY gitir
- 108 Microsoft Excel Legacy Import Options for New Excel Versions a1rj gitir
- 109 Exporting Data to a Text File k9lg gitir
- 111 Understanding Excel PivotTables SmhS gitir
- 112 Creating an Excel PivotTable MPQz gitir
- 113 Modifying Excel PivotTable Calculations OYLK gitir
- 114 Grouping PivotTable Data fo1S gitir
- 115 Formatting PivotTable Data n8Ah gitir
- 116 Modifying PivotTable Calculations 5QOM gitir
- 117 Drilling Down into PivotTable Data MY5b gitir
- 118 Creating PivotCharts Jqwp gitir
- 119 Filtering PivotTable Data KANU gitir
- 120 Filtering with the Slicer Tool y5wz gitir
- 121 Introduction to Excel Power Pivot KLUt gitir
- 122 Why PowerPivot GRtH gitir
- 123 Activating the Excel PowerPivot AddIn FlJf gitir
- 124 Creating Data Models with PowerPivot VoBu gitir
- 125 Excel Power Pivot Data Model Relationships fSGG gitir
- 126 Creating PivotTables based on Data Models 9nb4 gitir
- 127 Excel Power Pivot KPIs obSa gitir
- 128 Using the Freeze Panes Tool uBEv gitir
- 129 Grouping Data Columns and or Rows tLpN gitir
- 130 Print Options for Large Sets of Data oikY gitir
- 131 Linking Worksheets 3D Formulas w66K gitir
- 132 Consolidating Data from Multiple Worksheets pre5 gitir
- 135 Congratulations gKvn gitir
- 136 Excel 103 Course Exercise Files DOWNLOAD w15q gitir
- 137 Working with Excel Name Ranges rcMM gitir
- 138 Advantages and Disadvantages of Excel Name Ranges zIBF gitir
- 139 Editing an Excel Name Range Tk3I gitir
- 140 Using Excel s IF Function qQHD gitir
- 141 Excel s IF Function with a Name Range capP gitir
- 142 Nesting Functions with Excel 4pbD gitir
- 143 Nesting Excels AND Function within the IF Function P1Uo gitir
- 144 Using Excel s COUNTIF Function H6tE gitir
- 145 Using Excel s SUMIF Function XFQ2 gitir
- 146 Using Excel s IFERROR Function MFsh gitir
- 147 Microsoft Excel VLOOKUP Function xbHY gitir
- 148 Microsoft Excel HLOOKUP Function voPc gitir
- 149 Microsoft Excel INDEX Function Amz0 gitir
- 150 Microsoft Excel MATCH Function qV8d gitir
- 151 Microsoft Excel INDEX and MATCH Function Combined FwlR gitir
- 152 Microsoft Excel INDEX and MATCH Function Combined Continued bydc gitir
- 153 Creating a Dynamic HLOOKUP with the MATCH Function JUFs gitir
- 154 Using Excel s LEFT RIGHT and MID Functions Ift9 gitir
- 155 Using Excel s LEN Function rstu gitir
- 156 Using Excel s SEARCH Function 55Va gitir
- 157 Using Excel s CONCATENATE Function qyCD gitir
- 159 Introduction to New Excel Functions u7CN gitir
- 160 DOWNLOAD Microsoft Excel 365 Functions Exercise File jpOv gitir
- 161 Microsoft Excel 365 FILTER Function Dlkl gitir
- 162 Microsoft Excel 365 SORT Function aZEK gitir
- 163 Microsoft Excel 365 UNIQUE Function kBZ8 gitir
- 164 Microsoft Excel Dynamic FILTER Function with Data Validation asJr gitir
- 165 Microsoft Excel 365 XLOOKUP Function LuB4 gitir
- 166 EXERCISE Dynamic Employee Order List wK0s gitir
- 167 Microsoft Excel 365 SWITCH Function av9y gitir
- 168 TIP TRUE Expressions with Microsoft Excel 365 SWITCH Function Nzup gitir
- 169 Microsoft Excel 365 TEXTJOIN Function VOPc gitir
- 170 TIP TEXTJOIN Function with Criteria ciME gitir
- 171 Microsoft Excel 365 TEXTSPLIT Function vcgQ gitir
- 172 Tracing Precedents in Excel Formulas bLKV gitir
- 173 Tracing Dependents in Excel Formulas 2WKg gitir
- 174 Working with the Watch Window LoUp gitir
- 175 Showing Formulas I9vg gitir
- 176 Protecting Specific Cells in a Worksheet IYof gitir
- 177 Protecting the Structure of a Workbook xXE6 gitir
- 178 Adding a Workbook Password X9Fb gitir
- 179 Working with Excel s Goal Seek Tool T7uR gitir
- 180 Working with Excel s Solver Tool FXpx gitir
- 181 Building Effective Data Tables in Excel H9pw gitir
- 182 Creating Scenarios in Excel fhOq gitir
- 183 Understanding Excel Macros s5Xj gitir
- 184 Activating the Developer Tab in Excel oxLL gitir
- 185 Creating a Macro with the Macro Recorder vgu2 gitir
- 186 Editing a Macro with VBA r428 gitir
- 187 Creating Buttons to Run Macros ef2C gitir
- 189 Congratulations on Completing the Microsoft Excel 103 MCXN gitir
- 190 Welcome to the Course 6rpY gitir
- 191 Understanding the Why and How Behind Excel Macros HEUe gitir
- 192 Introduction to Project 1 Inserting and Formatting Text H6gy gitir
- 194 Activating the Excel Developer Tab fbku gitir
- 195 Project 1 Start Recording fXHq gitir
- 196 Running a Microsoft Excel Macro bccH gitir
- 197 Project 1 Running an Excel Macro with a Button MIdZ gitir
- 198 BONUS Create a Custom Button Using Excel Shapes XpHi gitir
- 199 Adding the Excel Macro to the Quick Access Toolbar 5ksu gitir
- 200 Project 1 Editing the VBA Recorded by the Macro Recorder TS3M gitir
- 201 Save a Workbook with a Macro VBA Code ZGSU gitir
- 202 Practical Uses of Excel Macros 9P9J gitir
- 203 Intro to Excel VBA Concepts AfXv gitir
- 204 Intro to Excel VBA Object Oriented Programming Concepts XWCy gitir
- 206 The Visual Basic Editor VBE Pnhd gitir
- 207 Introduction to the Excel VBA Immediate Window GYwQ gitir
- 208 Excel VBA Modules owwf gitir
- 209 Creating an Excel VBA Procedure E3VI gitir
- 210 Adding Code to a VBA Procedure CvAk gitir
- 211 Including Excel VBA Comments tHjn gitir
- 212 Excel VBA MSGBOX Function 8VW8 gitir
- 213 Excel VBA MsgBox Microsoft Help Information VKWZ gitir
- 214 Understanding and Working with Excel VBA Variables vUOD gitir
- 215 REMINDER Saving an Excel Workbook with VBA Code 5ZVd gitir
- 217 Building Logic with an Excel VBA IF Statement mCBf gitir
- 218 Including an Else Statement in the VBA IF Statement xExm gitir
- 219 Expanding the IF Logic with Multiple ElseIf Statements p1Wc gitir
- 220 Working with Excel VBA Select Case Statements 6sTd gitir
- 221 Working with an Excel VBA Do While Loop CHad gitir
- 222 Excel VBA Do While Loop Dynamic Condition GQNL gitir
- 223 Working with an Excel VBA For Each Loop 2H0z gitir
- 224 Working with an Excel VBA For Next Loop zsFF gitir
- 225 Introduction to Project 2 Interacting with the User CMVp gitir
- 227 Project 2 Introduction to the Excel VBA Range Sort Method qBql gitir
- 228 Creating the Excel VBA Sort Procedures for this Project Iek2 gitir
- 229 Project 2 Prompting the User for Information 9gln gitir
- 230 Continue Excel VBA InputBox 3Xjo gitir
- 231 Project 2 Building Logic into Your Macros cHIQ gitir
- 232 Project 2 Alerting the User of Errors wpG2 gitir
- 233 Using Excel VBA Error Control Statements GL5A gitir
- 234 Create a Button to Run the Sort Procedure and Save MgnH gitir
- 235 Introduction to Project 3 Cleaning Up and Formatting Data xQhJ gitir
- 237 Project 3 Preparing to the Use the Macro Recorder G1K5 gitir
- 238 Project 3 Inserting the Headers Ryio gitir
- 239 Project 3 Formatting the Headers pZwW gitir
- 240 Project 3 Testing the Macros ced7 gitir
- 241 Project 3 Using an Excel VBA Loop to Loop through all Worksheets lpr9 gitir
- 242 Project 3 Testing the Excel VBA Loop K1YC gitir
- 243 Project 3 Adding Logic to an Excel VBA Loop t9ol gitir
- 244 Introduction to Project 4 Automate Excel Formulas Ia6V gitir
- 246 Project 4 Start the Procedure to Automate the SUM Function QPOA gitir
- 247 Working with the Range Address Property akIT gitir
- 248 Creating the SUM Function in VBA deGt gitir
- 249 Run the Excel VBA Procedure to SUM Records wtdU gitir
- 250 Project 4 Loop the SUM Function Over Multiple Worksheets jFq2 gitir
- 251 Introduction to Project 5 Creating the Final Report 4wbj gitir
- 253 Project 5 Creating the Final Report Excel VBA Loop MVgS gitir
- 254 Project 5 Copying Content with Excel VBA t7Xv gitir
- 255 Project 5 Pasting Content with Excel VBA fcgH gitir
- 256 Cleaning Up the Final Report VBA Loop Code Q63W gitir
- 257 Adding Logic to Stop the Loop from Running Multiple Times on a Worksheet VWFX gitir
- 258 Project 5 Running the Final Report Procedure evnB gitir
- 259 Introduction to Project 6 Working with Excel VBA User Forms en24 gitir
- 261 Project 6 Creating an Excel User Form k2FP gitir
- 262 Project 6 Working with Form and Control Properties S0t0 gitir
- 263 Project 6 Formatting Excel VBA User Form Controls 3ukk gitir
- 264 Project 6 Adding VBA Code to the Initialize Event 1moo gitir
- 265 Project 6 Using the AddItem Method within a Loop hC6V gitir
- 266 Project 6 Adding VBA Code to the ComboBox Change Event f7i2 gitir
- 267 Project 6 Adding VBA Code to the Add Worksheet Button 4DFs gitir
- 268 Project 6 Change Worksheet Name 6g6x gitir
- 269 Project 6 Catch Errors When Adding a Worksheet 5Wje gitir
- 271 Project 6 Additional Conditions on the Loop Z3Hn gitir
- 272 Project 6 Running the Final Report Procedure fVrf gitir
- 273 Project 6 Showing the VBA User Form On Workbook Open TzVl gitir
- 274 Project 7 Opening a Text File for Import hwI1 gitir
- 275 Project 7 Opening a Text File for Import ZMel gitir
- 276 Project 7 Get Data from Text File xNw3 gitir
- 277 Project 7 Importing Multiple Text Files with the GetOpenFilename Method YhUX gitir
- 278 Project 7 Creating a Loop to Read Each File tZNb gitir
- 279 Project 7 Adding a New Sheet for Imported Data 7sEI gitir
- 280 Project 7 Clear the Clipboard DGQu gitir
- 281 Project 7 Working with the ScreenUpdating Property YcMY gitir
- 282 Project 7 Creating Reusable Code with a VBA Function i6rp gitir
- 283 Congratulations You re an Excel Macro VBA Master DFDd gitir