The ‘The Complete Excel’ program is designed to train you in the latest accounting and spread sheet techniques. Microsoft Excel is one of the most popular, powerful and easiest programs for managing information. Whether you need a simple spread sheet or a complex interactive database and to calculate financial, statistical and engineering information.
Course duration:
The Complete Excelis 45 Days course. The training programs are in e-learning video sessions that can be access at anywhere.
Eligibility:
10th/+2/ Graduates/ Working professionals
Requirements
- PC capable of Running Excel
- No other knowledge is required, as each step is explained fully in the course.
Job opportunities:
On successfully completing the ‘The Complete Excel” course, you will be ready to join top companies as:
- Financial Analysts.
- Retail Store Managers.
- Project Managers.
- Business Analysts.
- Data Journalists.
- Accountants.
Course Preview
Course Curriculum
INTRODUCTION | |||
Introduction | 00:15:00 | ||
ENTERING CLIPBORD AND FONT RIBONS | |||
Chapter- 1 Clipboard and Font Ribbons | 00:10:00 | ||
Chapter-2 Save and Save as | 00:07:00 | ||
TEXT ALIGNMENT | |||
Chapter- 1 Text Alignment | 00:08:00 | ||
CONDITIONAL FORMATING | |||
Chapter-1 Conditional Formatting | 00:10:00 | ||
Chapter-2 Number Formatting | 00:07:00 | ||
TABLE FORMATING AND CELL STYLES | |||
Chapter-1 Table Formatting and Cell Styles | 00:07:00 | ||
MANAGING CELL FORMATING AND TEXT EDITING | |||
Chapter-1 Cell Formatting | 00:08:00 | ||
Chapter-2 Text Editing. (Part.1) | 00:08:00 | ||
Chapter-2 Text Editing.(Part.2) | 00:08:00 | ||
PIVOT TABLES AND PIVOT CHARTS | |||
Chapter-1 Table, Pivot Tables and Pivot Charts | 00:14:00 | ||
ADDING GRAPHICS TO SPREDSHEETS | |||
Chapter-1 Clipart and Shape. (Part.1) | 00:09:00 | ||
Chapter-1 Clipart and Shape. (Part.2) | 00:06:00 | ||
Chapter-2 Insert Picture | 00:12:00 | ||
Chapter-3 Smart art Creation | 00:08:00 | ||
CHART CREATION AND FORMATING CHARTS | |||
Chapter-1 Chart Creation | 00:09:00 | ||
Chapter-2 Formatting Charts | 00:08:00 | ||
TEXT FORMULAS | |||
Chapter-1 Header and Footer | 00:12:00 | ||
Chapter-2 Text Ribbon. (Part.1) | 00:07:00 | ||
Chapter-2 Text Ribbon. (Part.2) | 00:13:00 | ||
PAGELAYOUT MENU | |||
Chapter-1 Page Layout. (Part.1) | 00:08:00 | ||
Chapter-1 Page Layout. (Part.2) | 00:05:00 | ||
Chapter-2 Print Titles | 00:16:00 | ||
VIEW MENU | |||
Chapter-1 Freeze Pane. | 00:05:00 | ||
Chapter-2 View Menu.(Part.1) | 00:09:00 | ||
LOOKUPS VALUES | |||
Chapter-1 V lookup Function.(Part.1) | 00:06:00 | ||
Chapter-1 V lookup Function.(Part.2) | 00:08:00 | ||
SORT FILTTER AND REMOVE DUPLICATES | |||
Chapter-1 Advanced Filter. | 00:07:00 | ||
Chapter-2 Data Sorting. | 00:09:00 | ||
Chapter-3 Data Validation. | 00:10:00 | ||
Chapter-4 Filter. | 00:05:00 | ||
Chapter-5 Remove Duplicates. | 00:05:00 | ||
Chapter-6 Text to Columns. | 00:05:00 | ||
PROTECTING DATA | |||
Chapter-1 Protect WorkBook and Work Sheet. | 00:05:00 | ||
SAVING A WORKBOOK | |||
Chapter-1 Save and Save as. | 00:07:00 | ||
MACROS | |||
Chapter-1 Macros.(Part.1) | 00:08:00 | ||
Chapter-1 Macros.(Part.2) | 00:06:00 | ||
MODIFYING ROWS AND COLUMNS | |||
Chapter-1 Modifying Rows And Columns | 00:06:00 | ||
UNDERSTANDING FORMULAS (ADVANCED EXCEL) | |||
Chapter-1 ABS Function. | 00:07:00 | ||
Chapter-2 AND Function. | 00:06:00 | ||
Chapter-3 Basic Formulas. | 00:11:00 | ||
Chapter-4 Cancel Duplicate Entry. | 00:05:00 | ||
Chapter-5 Cell Function. | 00:04:00 | ||
Chapter-6 Choose Function. | 00:06:00 | ||
Chapter-7 Closing Stock. | 00:04:00 | ||
Chapter-8 Code Function | 00:08:00 | ||
Chapter-9 Concantinate Function. | 00:07:00 | ||
Chapter-10 Count Function | 00:07:00 | ||
Chapter-11 Date Function. | 00:11:00 | ||
Chapter-12 Even and Exact Function | 00:05:00 | ||
Chapter-13 Fees Details.(Part.1) | 00:06:00 | ||
Chapter-13 Fees Details.(Part.2) | 00:10:00 | ||
Chapter-14 Fees Details.(Part.3) | 00:10:00 | ||
Chapter-15 Form Function. | 00:05:00 | ||
Chapter-16 H look up Function. | 00:06:00 | ||
Chapter-17 Interest Calculator. | 00:04:00 | ||
Chapter-18 Create Print Button. | 00:05:00 | ||
Chapter-19 Profit Calculation | 00:09:00 | ||
Chapter-20 Sales Reports. | 00:05:00 | ||
Chapter-21 Stock Management Application | 00:13:00 | ||
Chapter-22 Students Mark list | 00:10:00 | ||
Chapter-23 Sub Total | 00:06:00 | ||
Chapter-24 Calculate Stock | 00:11:00 | ||
Chapter-25 Payroll or Salary Details | 00:10:00 | ||
DEVELOPER TAB (ADVANCED EXCEL) | |||
Chapter-1 VBA Advanced Filter. | 00:10:00 | ||
FILE PRINTING | |||
Chapter-1 File Printing. | 00:00:00 | ||
GST BILL IN EXCEL | |||
Chapter-1 How to Create GST Bill in Excel.(Part.1) | 00:00:00 | ||
Chapter-1 How to Create GST Bill in Excel.(Part.2) | 00:00:00 | ||
Chapter-1 How to Create GST Bill in Excel.(Part.3) | 00:00:00 | ||
Final Examination | |||
Excel Quiz | 00:30:00 |
Course Reviews
822 STUDENTS ENROLLED
The Complete MS Excel
Excellent, All the classes of video tutorials are very deeply done which was very simple and easy to learn.
Excel
It will be good if some excel assignments are also given
Excellent class
GREAT
Well organised excel modules.. happy learning
fantastic experience
thanks KCSM