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:
1
•
Resources:
266
- Announcements
- 001 What is Microsoft Excel h9Nn gitir
- 002 How do I get Microsoft Excel NCBR gitir
- 003 How do I open Microsoft Excel IpXQ gitir
- 004 Cell Worksheets and Workbooks Z6U9 gitir
- 005 The Ribbon Toolbar T8FY gitir
- 006 Selecting Cells and The Name Box S82f gitir
- 007 Altering Rows and Columns M5sl gitir
- 008 Borders xZiw gitir
- 009 Revision Times Table Square K3F8 gitir
- 010 Exploring Data Types D1r9 gitir
- 011 Formatting Data ecQP gitir
- 012 Creating a Series hu2L gitir
- 013 Creating Formulae IBBV gitir
- 014 Formulae and Autofill Relative Addressing 1LBz gitir
- 015 Resolving Relative Addressing Issues Absolute Addressing I4Qi gitir
- 016 Formatting Cells cpI1 gitir
- 017 Revision Times Table Square GlSF gitir
- 018 Protecting Worksheets dPNM gitir
- 019 Restricting Data in Cells BlMw gitir
- 020 Creating Lists Rckz gitir
- 021 Adding and Deleting Rows and Columns Q4hG gitir
- 022 Conditional Formatting BR3V gitir
- 023 Introducing Functions MOD Cl0b gitir
- 024 Revision Times Table Square IRyA gitir
- 025 Introducing Battleships LOm0 gitir
- 026 The IF Function wraZ gitir
- 027 The COUNTIF Function IwZW gitir
- 028 The COUNTA Function SXqN gitir
- 029 Nested IFs Km2C gitir
- 030 The SUM Function nPMA gitir
- 031 Named Ranges hvzd gitir
- 032 Revision Battleships 3aDr gitir
- 033 3D Formulae zOLE gitir
- 034 Shapes Ox7B gitir
- 035 Images t6i6 gitir
- 036 Revision Battleships F4Oi gitir
- 037 Revision Battleships CcgX gitir
- 038 Using CSV files 5KbU gitir
- 039 Exporting Data into a CSV file 2fwQ gitir
- 040 Issues with CSV files kHsI gitir
- 041 Importing CSV files Using the Legacy Wizard XEWj gitir
- 042 The AVERAGE Function gG6P gitir
- 043 The MEDIAN Function KOIH gitir
- 044 The MODE Function YMQs gitir
- 045 The MODE SNGL Function UNfo gitir
- 046 The MODE MULT function sZ6K gitir
- 047 Revision Gradebook u7gQ gitir
- 048 The VLOOKUP Function gWxz gitir
- 049 The HLOOKUP Function XcOe gitir
- 050 The MAX and MIN Functions SmWG gitir
- 051 The RAND and RANDBETWEEN Functions IeSa gitir
- 052 The INDEX Function HCTa gitir
- 053 The MATCH Function JyR9 gitir
- 054 Filters gqCp gitir
- 055 Revision Gradebook Qc7v gitir
- 056 The SUMIF Function APRK gitir
- 057 The SUMIFS Function rvDG gitir
- 058 Working with Dates ENPl gitir
- 059 Working with Text Ls3c gitir
- 060 Simple Bar Graphs vr0u gitir
- 061 Pie Charts Rovl gitir
- 062 Scattergraphs y8wg gitir
- 063 Scattergraphs 2 Cqru gitir
- 064 Manipulating Text m0YL gitir
- 065 More Manipulating Text XwEF gitir
- 066 Importing Data from the Web o8ps gitir
- 067 Creating Test Data Pt 1 x3ZQ gitir
- 068 Creating Test Data Pt 2 39YV gitir
- 069 Developing a Budget Spreadsheet 3r6z gitir
- 070 Continuing the Budget Spreadsheet bwdq gitir
- 071 Revision Astronomical Modeling Pt 1 u0Vx gitir
- 072 Revision Astronomical Modeling Pt 2 UUnk gitir
- 073 Revision Astronomical Modeling Pt 3 1Q3w gitir
- 074 Revision Astronomical Modeling Pt 4 yaQN gitir
- 075 UNIQUE and Spills FfW9 gitir
- 076 The IFS Function jQfK gitir
- 077 The MAXIFS Function IEWb gitir
- 078 The MINIFS Function es2c gitir
- 079 The SWITCH Function dxZ7 gitir
- 080 The SORT Function lFX5 gitir
- 081 The XMATCH Function Kp2v gitir
- 082 The LET Function PGSG gitir
- 083 The XLOOKUP Function kSzn gitir
- 084 The FILTER Function lmp9 gitir
- 085 The SORTBY Function e3AX gitir
- 086 The SEQUENCE Function OKvY gitir
- 087 Revision Combining Functions BlvZ gitir
- 088 The RANDARRAY Function gDjD gitir
- 089 Text to Columns nzTX gitir
- 090 Zooms and Sheet Selections htsR gitir
- 091 Logical Functions StHT gitir
- 092 ODDs and EVENs L8jl gitir
- 093 Trigonometry ok6m gitir
- 094 Ceilings and Floors SYHo gitir
- 095 Reviewing all our Learning YlUZ gitir
- 096 Welcome to Data Visualization 3OM9 gitir
- 097 Introduction to the Course SIyd gitir
- 098 Introducing Conditional Formatting lKiv gitir
- 099 Highlight Cell Rules LJ8T gitir
- 100 Top Bottom Rules AN2Y gitir
- 101 Data Bars V2QU gitir
- 102 Colors Scales J5mw gitir
- 103 Icon Sets DBPv gitir
- 104 Create Clear or Manage Rules EL54 gitir
- 105 Revision 1AQJ gitir
- 106 Practice Project A Academic Report QQUH gitir
- 107 Introducing Charts Graphs Ryre gitir
- 108 Tables vs Charts Graphs W2ao gitir
- 109 Sparklines I5kq gitir
- 110 Mini Charts ofce gitir
- 111 Revision F77K gitir
- 112 Practice Project B Gantt Chart FCtu gitir
- 113 Understanding the Need mvNP gitir
- 114 Chart Area NX9J gitir
- 115 Plot Area W3w1 gitir
- 116 Axes 0jYc gitir
- 117 Axes Titles C0Ya gitir
- 118 Chart Title D9b3 gitir
- 119 Data Labels TvrZ gitir
- 120 Data Table gBO4 gitir
- 121 Error Bars HYqT gitir
- 122 Gridlines gJ8o gitir
- 123 Legend Lfyq gitir
- 124 Trendlines XToS gitir
- 125 Altering Styles PvS8 gitir
- 126 Altering Colors bsRd gitir
- 127 Data Sources OXNu gitir
- 128 Data Series Tk00 gitir
- 129 Revision aBsg gitir
- 130 Quick Quiz A 10 MCQs Zg9u gitir
- 131 Column or Bar Charts Comparisons SKqs gitir
- 132 Line or Area Charts Trends oRM8 gitir
- 133 Pie or Doughnut Charts Proportions KphK gitir
- 134 Scatter or Bubble Chart Relationships cBaK gitir
- 135 Histograms or Box Whisker Statistical Analysis oFVM gitir
- 136 Treemap or Sunburst Hierarchies 3vDN gitir
- 137 Revision BmJ4 gitir
- 138 Practice Project C Daily Activity Tracker Y1OX gitir
- 139 Combo Charts Mixed Data d1BO gitir
- 140 Waterfall Popular Demand 94TG gitir
- 141 Funnel Stages of a Process uvnR gitir
- 142 Stock Fluctuations oSgi gitir
- 143 Surface Multidimensional Data GwBO gitir
- 144 Radar Skewness bHIT gitir
- 145 Revision IApN gitir
- 146 Quick Quiz B 10 MCQs pRZz gitir
- 147 Choosing the Right Rules CCzL gitir
- 148 Choosing the Right Charts tK3u gitir
- 149 Revision VrL3 gitir
- 150 Quick Quiz C 10 MCQs An31 gitir
- 151 The Concept E1xs gitir
- 152 Pivot Tables aEez gitir
- 153 Pivot Charts mSil gitir
- 154 Slicers Timelines DB2t gitir
- 155 Dashboard Design Decisions 4fQL gitir
- 156 Revision 5NFu gitir
- 157 Practice Project D KPI Dashboard xQYk gitir
- 158 Practice Project E Investment Dashboard d8ly gitir
- 159 2D or Filled Maps CZ6j gitir
- 160 3D Maps 1s2w gitir
- 161 Revision 9fIs gitir
- 162 Quick Quiz D 10 MCQs Miij gitir
- 163 Permissions L3Gd gitir
- 164 Bing Maps ONYP gitir
- 165 Viso Data Visualizer PfdI gitir
- 166 People Graph Ne2r gitir
- 167 QR4 Office NaUr gitir
- 168 Mini Calendar Date Picker UVGi gitir
- 169 Web Video Player cLFO gitir
- 170 Colorizer p8mH gitir
- 171 Places p6NM gitir
- 172 Revision CJXe gitir
- 173 Quick Quiz E 10 MCQs giKt gitir
- 174 The Big Picture 8UpO gitir
- 175 Cell References 1EGJ gitir
- 176 Naming Cells mCNS gitir
- 177 Adjusting Cell Width Height 6x7D gitir
- 178 Freezing or Spliting Panes h3yv gitir
- 179 Grouping Data FCG5 gitir
- 180 Drop Downs xgzH gitir
- 181 Adjusting Chart Location Position IqjH gitir
- 182 Adjusting Chart Cell Connections WpMa gitir
- 183 Switching Views mNPH gitir
- 184 Linking Data between Sheets ePMC gitir
- 185 Printing Options Hwd4 gitir
- 186 Sharing o1yc gitir
- 187 Exporting bMQW gitir
- 188 Revision cQd3 gitir
- 189 Practice Project F Web Analytics Report LOig gitir
- 190 Quick Quiz F 5 MCQs GoQR gitir
- 191 Welcome to Data Analysis VuJ9 gitir
- 192 Introduction to the Course nCGg gitir
- 193 Instructors Introduction U9Gf gitir
- 194 Table Organization XUfb gitir
- 195 Primary Keys F3lJ gitir
- 196 Conditioning Data GGFa gitir
- 197 Checking Data Through Functions Ow5h gitir
- 198 Nesting Formulas UwGz gitir
- 199 Array Formulas XZYO gitir
- 200 Introduction of Overarching Dataset and Setting a Framework KTN9 gitir
- 201 Data Analysis Framework WntN gitir
- 202 Baseline Analysis srkJ gitir
- 203 Overarching Project Introduction WuOC gitir
- 204 Introduction to Pivot Tables MgM6 gitir
- 205 Pivot Table Functions and Basic Pivots EHZh gitir
- 206 Pivot Tables with Overarching Project vtMa gitir
- 207 Pivot Practice 6atH gitir
- 208 Introduction to Power Query yUUD gitir
- 209 Using Power Query exsB gitir
- 210 Power Query with Overarching Project fzjG gitir
- 211 Power Query Practice h9w8 gitir
- 212 Introduction to Power Pivot jau5 gitir
- 213 Using Power Pivot mGp3 gitir
- 214 Power Pivot with Overarching Project ROUj gitir
- 215 Power Pivot Practice LOQo gitir
- 216 Introduction to Dynamic Array Formulas D2sp gitir
- 217 Using Dynamic Array Formulas 3nwH gitir
- 218 Dynamic Array Formulas with Overarching Project YePG gitir
- 219 Dynamic Array Formulas Practice 4c6F gitir
- 220 Introduction and Preparation for Predictive Analysis ALop gitir
- 221 Using Predictive Analysis FjwG gitir
- 222 Excels Predictive Shortcuts BkKb gitir
- 223 Gcode Extraction WEvM gitir
- 224 House Budgeting with Power Pivot 2fbl gitir
- 225 Budgeting with Power Pivot 1wOe gitir
- 226 Budgeting with Power Query xA7c gitir
- 227 Analysis and Logic Trap Exercise GfmN gitir
- 228 Capstone Project Introduction fRsc gitir
- 229 Capstone Project by Formulas 1a7Y gitir
- 230 Capstone Project by Pivot Tables I4MJ gitir
- 231 Capstone Project by Power Query DEDP gitir
- 232 Capstone Project by Power Pivot vlEd gitir
- 233 Capstone Project by Dynamic Array Formulas Bigk gitir
- 234 Course Conclusion iRbU gitir
- 235 Welcome to Excel Programming REff gitir
- 236 Introduction DMNf gitir
- 237 What is Programming and VBA 7JbR gitir
- 238 Object Oriented Programming UJES gitir
- 239 Introduction to Recording Macros y0He gitir
- 240 Introduction kuhB gitir
- 241 Drop Down Menus in VBA Part I H4ZZ gitir
- 242 Drop Down Menus in VBA Part II kwAI gitir
- 243 Introduction ST0Z gitir
- 244 MsgBox Introduction to Workbook and Worksheet Ouwa gitir
- 245 Workbooks Open Statements mlvf gitir
- 246 Workbooks Save and Worksheets UDBH gitir
- 247 Customize Toolbar and Ribbons EWSP gitir
- 248 What is a Variable 9VIw gitir
- 249 Using Variables to Perform Basic Math Functions nRFm gitir
- 250 Introduction to Additional Data Types cULw gitir
- 251 VBA Tips and Tricks Part I qVxa gitir
- 252 VBA Tips and Tricks Part II CFha gitir
- 253 Data Types Additional Information ARDz gitir
- 254 Variables Continued 6kZS gitir
- 255 Call Procedure ntoY gitir
- 256 Workbooks Name Workbook Clear and Workbook Close ZVJO gitir
- 257 Public and Private Procedures LAMh gitir
- 258 Introduction to Constants I8Lu gitir
- 259 Row Offset and Exit Sub ebwO gitir
- 260 Application Object Part I sWpb gitir
- 261 Application Object Part II BpjY gitir
- 262 Object Count Path and more VBA Tips and Tricks cqvd gitir
- 263 Workbooks Add Workbooks Close fDNR gitir
- 264 Workbook Activate Open and Close wfGt gitir
- 265 Worksheet Visible Copy Delete iAHb gitir
- 266 Last Words 2WHN gitir