Intermediate Excel Course from Normal Axelman
Total of 15 Key Lessons. Ten to fifteen minutes each to learn all the essentials functions of Excel
- Comprehensive – Learn virtually everything you will ever need to succeed using MS Excel
- Logical and sequential segments using real life examples you can put to work right away
- 10-12 minute segments, easy to follow and digest
- Not just a ‘screen shot’ and a voice in the background. Using ‘Green Screen’ technology, you can follow a dynamic presentation clearly showing how to accomplish each step
Your Instructor
Norman Axelman is the founder and President of Advantage Computer Solutions, Inc. Based in Miami, Florida, Advantage Computer Solutions has been offering computer training and consulting services to individuals and businesses since 2001, saving clients thousands of hours of work time, with commensurate savings in payroll dollars. With over 25 years of professional experience, Mr. Axelman provides an outstanding level of computer training and consulting with a focus on practical and useful day-to-day features and functions resulting in increased efficiency and productivity, and as a Quickbooks Pro Advisor has helped many clients with set up and use of the Quickbooks program.
Mr. Axelman is an adjunct professor for the Miami Dade College School of Continuing Education, has been retained as a computer instructor for a yearly national convention of Quickbooks users, and is accredited by the State of Florida to teach Continuing Education computer classes for licensed Community Association Managers.
Course Curriculum
-
PreviewIntroduction - The Power of Microsoft Office (9:04)
-
StartSession 1 - Navigation Tools (12:10)
-
StartSession 2 - Working with Rows and Columns (15:44)
-
StartSession 3 - Number Formulas (12:27)
-
StartSession 4 - Working with Formulas (13:26)
-
StartSession 5 - Static v. Dynamic Lists / Cell Formatting (7:59)
-
PreviewSession 6 - Text to Columns and Extracting selective data from cells (9:28)
-
StartSession 7 - Concatenate and Find/Replace (13:05)
-
StartSession 8 - Working if IF Statements (10:41)
-
StartSession 9 - More IF statement examples and SIMIF Formulas (14:22)
-
StartSession 10 - Vlookup (7:48)
-
StartSession 11 - Working with Dates (6:42)
-
StartSession 12 - Conditional Formatting and Data Validation (11:46)
-
StartSession 13 - Protecting your data and Create Pivot Tables (11:16)
-
StartSession 14 - Cleaning up Data (8:36)
-
StartSession 15 - Working with Graphs and Charts (6:13)