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:06:00 | ||
GST BILL IN EXCEL | |||
Chapter-1 How to Create GST Bill in Excel.(Part.1) | 00:16:00 | ||
Chapter-1 How to Create GST Bill in Excel.(Part.2) | 00:23:00 | ||
Chapter-1 How to Create GST Bill in Excel.(Part.3) | 00:10:00 | ||
Office 365 with Gulf VAT | |||
Chapter-1 How to Access Office 365 | 00:14:00 | ||
Chapter-2 Introduce Main Page | 00:09:00 | ||
Chapter-3 Edit Profile Page | 00:10:00 | ||
Chapter-4 Flash Fill Function in Excel | 00:07:00 | ||
Chapter-5 Sum Function in Excel | 00:10:00 | ||
Chapter-6 Remove enter Space using Trim Function in Excel | 00:04:00 | ||
Chapter-7 Find the Difference between Two Date in Excel | 00:09:00 | ||
Chapter-8 How to Calculate Age in Excel | 00:06:18 | ||
Chapter-9 DGET Function In Excel | 00:10:00 | ||
Chapter-10 Shortcut Repeat Last Action In Excel | 00:05:00 | ||
Chapter-11 Add Serial Numbers to Data set with Blank Rows | 00:08:16 | ||
Chapter-12 Remove Data before or after a Specific Character in Excel | 00:07:00 | ||
Chapter-13 Copy File Names Into An Excel Worksheet | 00:05:00 | ||
Chapter-14 Highlight Rows that contain a Specific Text in Excel | 00:06:00 | ||
Chapter-15 Excel Shortcut To Add Bullets Point | 00:03:00 | ||
Chapter-16 Automatic Serial Number In Excel | 00:05:00 | ||
Chapter-17 Highlight Blank Cells In Excel | 00:03:00 | ||
Chapter-18 Method To Edit Cell Values In Excel | 00:04:00 | ||
Chapter-19 Even Function In Excel | 00:04:00 | ||
Chapter-20 Find The Square Root Function In Excel | 00:04:00 | ||
Chapter-21 How to Find Highest and Lowest Salary of Employees | 00:07:00 | ||
Chapter-22 How To Add Input Messages In Cells | 00:06:00 | ||
Chapter-23 Copying Millions of Copies in just One Drag | 00:05:00 | ||
Chapter-24 Just One Click And Get Multiple Functions | 00:09:00 | ||
Chapter-25 How To Build A Search Box In Excel | 00:10:00 | ||
Chapter-26 Track Changes And Comments In Excel | 00:10:00 | ||
Chapter-27 How to calculate GULF Payroll(Salary Calculation) | 00:15:00 | ||
Chapter-28 Draw Menu | 00:06:00 | ||
Chapter-29 How To Create Barcode In Excel | 00:06:00 | ||
Chapter-30 Hide And Unhide Cell Content | 00:07:00 | ||
Chapter-31 How To Calculate Net Price | 00:06:00 | ||
Chapter-32 How to calculate VAT Amount and Selling Price | 00:04:00 | ||
Chapter-33 How to calculate GULF VAT in Excel | 00:10:00 | ||
Final Examination | |||
Excel Quiz | 00:30:00 |
Course Reviews
763 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