Syste
m (Hardware/Software)
Requirements
Operating
Software | Windows XP or
Higher
| Processor | Minim
um P4 or Higher
| RAM | 1 GB or
Higher
| Browser | Any
| Recommended Internet
Speed | Minimum 1MBPS
| Supported Browser
Plug-ins | * Updated
Flash Player, * Update Java
| Other
Requirements | Speaker or
headphone | |
Prdocut DescriptionAs 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 with a blend of our years of 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 the productivity and efficiency by introducing participants to numerous tools and techniques available in Excel.
This Excel 2010 Beginner course is hands on practical course. While instructing, the trainer actually performs the operations over an excel sheet for a better learning. Completion of this course, a participant 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 SUBTITLE. 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.
Note: Microsoft Excel 2010 Beginner (this course) is also a part of Excel - Excel Course (Basic and Advanced). If you are looking for both Beginner and Advanced Excel 2010, Please go for Comprehensive program.
Instructor: Mr. Dheeraj V. (CFA, FRM, IIML, IITD)
Dheeraj, A financial wizard, His relentless pursuit of knowledge and financial acumen has made him one of the most sought after individual in the training circles. He was associated with J.P Morgan Chase Equity Research Group as an analyst and later moved to CLSA India (Asia's #1 Broking Firm) in the field of Equity Research and Investment Banking domain.
Website: - edu CBA
Course Page - excel training 2010 basic
Be a part of the learning community onFacebook orTwitter
You may also find awesome resources at our Excel blog
Course Curriculum
Lecture1 Excel 2010 Beginner - Overview
Section2 Excel 2010 Getting Started
Lecture2 Getting Started - Ribbons & Quick Access Toolbar
Lecture3 Getting Started - Surfing Excel & HELP Function
Quiz1 Getting Started Quiz
Section3 Case Study
Lecture4 Excel Case Study
Quiz2 Excel Case Study Quiz
Lecture5 Data Entry in Excel
Quiz3 Data Entry Quiz
Lecture6 Populating the case study - Download excel sheets
Lecture7 Populating the Case Study in Excel
Quiz4 Populating the Case Study in Excel Quiz
Section4 Calculations
Lecture8 Calculations Working Files - Download These First
Lecture9 Calculations - Addition Subtract Multiply Division
Quiz5 Calculations Quiz
Section5 Formulas
Lecture10 Formulas Working Files - Download These First
Lecture11 Formulas - SUM MAX MIN AVERAGE
Quiz6 Formulas Quiz
Section6 Formatting
Lecture12 Formatting - Number Formats Working Files - Download These First
Lecture13 Formatting - Number Formats
Quiz7 Formatting - Number Formatting Quiz
Lecture14 Formatting (Table) Working Files - Download These First
Lecture15 Formatting - Table Formats
Quiz8 Formatting - Table Format Quiz
Section7 Updating a Calculation
Lecture16 Updating a Calculation Working Files - Download These First
Lecture17 Updating a Calculation
Quiz9 Updating a Calculation Quiz
Section8 Percentages & Absolute References
Lecture18 Working Files - Download These First
Lecture19 Percentages & Absolute References
Quiz10 Percentage and Absolute References Quiz
Section9 Conditional Formatting
Lecture20 Conditional Formatting Working Files - Download These First
Lecture21 Conditional Formatting
Quiz11 Conditional Formatting Quiz
Section10 IF Function
Lecture22 IF Working Files - Download These First
Lecture23 IF function
Quiz12 IF Function Quiz
Section11 COUNTIF and SUMIF
Lecture24 COUNTIF Working Files - Download These First
Lecture25 COUNTIF Function
Quiz13 COUNT IF Quiz
Lecture26 SUMIF Working Files - Download These First
Lecture27 SUMIF Function
Quiz14 SUMIF Function Quiz
Section12 Charts and Graphs
Lecture28 Charts and Graphs Working Files - Download These First
Lecture29 Creating Charts and Graphs
Quiz15 Charts and Graphs Quiz I
Lecture30 Pie Charts Working Files - Download These First
Lecture31 Create Pie Charts
Quiz16 Charts and Graphs Quiz II
Section13 Sorts and Filters
Lecture32 Sorts Working Files - Download These First
Lecture33 Sorts
Quiz17 SORT Quiz
Lecture34 Filters Working Files - Download These First
Lecture35 Filters
Quiz18 Filter Quiz
Section14 Pivot Tables
Lecture36 Pivot Table Working Files - Download These First
Lecture37 Pivot Tables
Quiz19 Pivot Table Quiz
Section15 Freeze and Split
Lecture38 Freeze and Split Working Files - Download These First
Lecture39 Freeze and Split
Quiz20 Freeze and Split Quiz
Section16 Presentation
Lecture40 Presentation I Working Files - Download These First
Lecture41 Presentation - Table Formats
Quiz21 Presentation Quiz I
Lecture42 Presentation II Working Files - Download These First
Lecture43 Presentation - Indents and Formatting Charts
Quiz22 Presentation Quiz II
Section17 Print
Lecture44 Printing the Worksheet
Quiz23 Printing the Worksheet Quiz
Lecture45 Printing - Headers and Titles
Quiz24 Print Quiz
Section18 Shortcuts
Lecture46 Excel Shortcuts Working Files - Download These First
Lecture47 Shortcuts - Formatting and Navigation
Quiz25 Shortcut Part I Quiz
Lecture48 Shortcuts - Selection, Data and Formula
Quiz26 Shortcut Part II Quiz
Section19 Common Errors
Lecture49 Common Errors
Quiz27 Common Error Quiz
Section20 Concluding Lecture
Lecture50 Concluding Lecture
Benefits
eduCBA e-campus
Virtual campus powered by robust LMS which enables to study through internet with cutting edge features
Online Video Training Material
Presentation Slides
USP of the product
* 24 x 7 online access* Learn from tutorials curated by expert industry professionals and trainers* Certificate of Completion* Practical application oriented skillsHow to use? (Steps to use Study Material)
Step 1 - eduCBA sends the redemption coupon along with the registration link. Step 2 - Student will register with his register email id and coupon Step 3 - Student receive the course access and password on his/her email idStep 4 - Login using your email id and password and start learningTo get more information, you may want to watch the video below
Learn Everything, Anywhere, Anytime
India's Largest Online Education Marketplace