ja_mageia

In our class, we will use MS Excel to input and analyze data. We encourage you learn Excel and share your experience. Here is a series of training videos from Youtube, called "Excel Basics". If you are new to Excel, you may start from here.

Excel Basics #1: What Is Excel?

Excel Basics #2: Keyboard Shortcuts

Excel Basics #3: Formulas w Cell References

Excel Basics #4: Formulas and Functions

Excel Basics #5: Formulas Operators and Math

Excel Basics #6: Names Cell Ranges and Functions

Excel Basics #7: Range Functions

Excel Basics #8: Cell References Relative & Absolute

Excel Basics #9: Mixed Cell References in Formulas

Excel Basics #10: Formulas: Copy Vs. Cut

Excel Basics #11: Spreadsheet Setup & Cell References

Excel Basics #12: Stylistic & Number Formatting

Excel Basics #13: Percentage Number Format

Excel Basics #14: ROUND function & Number Formatting

Excel Basics #15: Date & Time Format & Calculations

Excel Basics #16: Chart Basics

Excel Basics #17: Page Setup

Excel Basics #18: Data Analysis Sort

Excel Basics #19: Data Analysis Subtotals

Excel Basics #21: Data Analysis Filter &Dynamic Ranges

Excel Basics #22: IF function formula made easy!

Excel Basics #23: VLOOKUP function formula