Educba
Basic Excel Course
Learn the basics of MS Excel 2010 using practical Excel case studies
Self paced
tutorials
As the industry standard for spreadsheet software, Microsoft Excel comes with many advantages to the new user. This awesome Excel 2010 for Beginners online course on MS Excel deals with the tools, techniques and functions of Excel 2010. This course will introduce you to different powerful tools of Excel 2010.
The Excel 2010 Beginner: ZERO to HERO in just 1 day course content is developed based on feedback from students and professionals and years of our experience in providing Excel training. This program is suitable for housewives, entrepreneurs, marketing and sale professionals, students, accountants and finance & non-finance professionals and anyone looking to learn Excel 2010. The objective of the course is to increase productivity and efficiency by introducing participants to numerous tools and techniques available in Excel.
Why should you take this course?
This Excel 2010 Beginner course is a hands-on practical course. While instructing, the trainer actually performs the operations over an Excel sheet for better learning. On completion of this course, the participants will be capable of working on an Excel sheet using different tools and techniques.
This Excel 2010 Beginner Course has 80 lectures with 6 hours of videos along with 27 quizzes. We have provided 100+ working files for participants to download along with subtitles. We have also shown functions in Excel 2003 and 2007 to compare with Excel 2010. Take this Excel 2010 Beginner course and learn how to use Microsoft Excel with numerous tools and techniques.
What are the prerequisites?
The course starts from scratch and does not require any pre-requirements.
What am I going to get from this course?
- Over 50 lectures and 4 hours of content
- The objective of the course is to introduce you to the power of Excel and to enable a participant to work on an Excel sheet using different tools and techniques
Who should take this course?
- This is a very basic course on Excel. This course will introduce you to the power of Excel. The target audience for this course is anyone interested in Excel
- Students, accountants, finance & non-finance professionals
Course Content:
| Section 1: INTRODUCTION |
| Lecture 1: Introduction |
| Section 2: EXCEL 2010: GETTING STARTED |
| Lecture 2: All Working Files Basic Excel - Download These First |
| Lecture 3: All Working Files Advanced Excel - Download These First |
| Lecture 4: Getting Started - Ribbons & Quick Access Toolbar |
| Lecture 5: Getting Started - Surfing Excel & HELP Function |
| Section 3: CASE STUDY |
| Lecture 6: XYZ Company Basic Excel Case Study |
| Lecture 7: Excel Case Study |
| Lecture 8: Data Entry in Excel |
| Lecture 9: Populating the Case Study in Excel |
| Section 4: CALCULATIONS |
| Lecture 10: Calculations - Addition Subtraction Multiplication Division |
| Section 5: FORMULAS |
| Lecture 11: Formulas - SUM MAX MIN AVERAGE |
| Section 6: FORMATTING |
| Lecture 12: Formatting - Number Formats |
| Lecture 13: Formatting - Table Formats |
| Section 7: UPDATING A CALCULATION |
| Lecture 14: Updating a Calculation |
| Section 8: PERCENTAGES & ABSOLUTE REFERENCES |
| Lecture 15: Percentages and Absolute References |
| Section 9: CONDITIONAL FORMATTING |
| Lecture 16: Conditional Formatting |
| Section 10: IF FUNCTION |
| Lecture 17: IF Function |
| Section 11: COUNTIF AND SUMIF |
| Lecture 18: COUNTIF Function |
| Lecture 19: SUMIF Function |
| Section 12: CHARTS AND GRAPHS |
| Lecture 20: Creating Charts and Graphs |
| Lecture 21: Create Pie Charts |
| Section 13: SORTS AND FILTERS |
| Lecture 22: Sorts |
| Lecture 23: Filter |
| Section 14: FREEZE AND SPLIT |
| Lecture 24: Freeze and Split |
| Section 15: PRESENTATION |
| Lecture 25: Presentation - Table Formats |
| Lecture 26: Presentation - Indents and Formatting Charts |
| Section 16: PRINT |
| Lecture 27: Printing the Worksheet |
| Lecture 28: Printing - Headers and Titles |
| Section 17: SHORTCUTS |
| Lecture 29: Shortcuts - Formatting and Navigation |
| Lecture 30: Shortcuts - Selection, Data and Formula |
| Section 18: COMMON ERRORS |
Lecture 31: Common Errors |
Language of instruction: English
- 3+ hours of High Quality Content
- Become Excel Hero in just 1 day
- Hands on practical course
- 50+ HD Video Tutorials
eduCBA is a globally recognized training firm, providing a blend of instructor-led and online financial training programs in Excel, Advanced Excel, VBAs, Macros, Equity Research, Wealth Management, Technical Analysis Investment Banking, Private Equity, Fundamental Analysis, Investment Research, Credit Research etc and preparatory courses like CFA Level I & II and FRM Level I & II, Campus Placement Trainings etc.
eduCBA Online Training Learning Management System provides access to high-end Excel videos, valuation tutorials, online tests, downloadable templates and models that are prepared by Research Analysts & Investment Bankers.
Schedule & Syllabus
Please wait while we are fetching data...
