Microsoft Office 2010 Advanced Excel Online Certified Course
Introduction
Do you have a basic knowledge of excel and want to become an expert in using excel? Well, Your wait is over because we/NIFM brings the best solution in the form of special, easy and unique designed course for you. Get yourself register for our online Advance Level Excel Beginners program and get a perfect command of the different concept of Excel.
NIFM provides you the best Online Courses that help you to upgrade your level from beginner to an Expert. Microsoft office 2010 Advance Excel online Course for Beginners Specially designed in the simple and step by step manner to enhance your knowledge, Skills, and Expertise in all elements of Excel. You can learn through our online Advance Excel course with the example that involves charts design, excel formula, data analysis, and data sorting with the help of filters like color, slicer etc.
MS Excel is a highly used software for office work and it requires in the day to day professional life. It is highly necessary for an office worker to learn the Advance level excel for their personal as well as professional work. NIFM Online MS Excel advance level course delivers the combination of basic, intermediate and advanced level knowledge about the tools required for the development of Excel worksheet.
This course is designed under the guidance of our highly educated, experienced and professional faculty to deliver the best instruction that will help you to improve your understanding and knowledge to transform you from beginner to the professional.
Online Advance Excel certified Course detail Chapters in a stepwise manner to get the result you want in the matter of time. This course includes the detailed chapters of advanced level functionalities, Centering the Worksheet Data, Data validation, Detailed number of excel formula and Excels productive tips.
What you will get?
Pre-recorded chapter vise videos - Yes (approx 5-6 hours)
Language: HINDI
Book: NO
Certification: Certification from NIFM
Faculty: Veenika Singh
About Course
NIFM Advance Excel Course provides you the complete detail explanation of all command like-
Array,
Conditional Formatting,
Convert Function,
Countif,
Sumif,
Averageif Function,
Match Function,
Mode Function
Vlookup Function
And many more.....
with the help pre-recorded video.
Course Requirements
Computer, Laptop, ipad, tab or mobile phone required with broadband or 4G internet.
Who is this Course for?
Microsoft Office Advanced Excel is the advance education in the MS Office computer field. This course is prepared for everyone wants to do job or business.
Course Outline
Chapter 1 : Applying Range Names to Formula
Chapter 2 : Array
Chapter 3 : Autofill and Custom List
Chapter 4 : Autosum Row and Column Reference
Chapter 5 : Centering the Worksheet Data
Chapter 6 : Changing Label Orientation
Chapter 7 : Changing Worksheet in One Go
Chapter 8 : Column Label Change in Number Label
Chapter 9 : Comment Shape
Chapter 10 : Concatenate
Chapter 11 : Conditional formating
Chapter 12 : Conditional Formatting with Mod Function
Chapter 13 : Controlling Display of the Scrollbar
Chapter 14 : Convert Function
Chapter 15 : Copy Numbers Only
Chapter 16 : Countblank Counta
Chapter 17 : Countif, Sumif and Averageif Function
Chapter 18 : Create Bar Graph
Chapter 19 : Create Button
Chapter 20 : Creating Combo Box
Chapter 21 : Cycle Font Color
Chapter 22 : Data Validation
Chapter 23 : Deleting Graphics When Deleting Rows
Chapter 24 : Dependent Dropdown List
Chapter 25 : Entered Values are Divided by 100
Chapter 26 : Enterkey Behaviour
Chapter 27 : Find Search and Mid function
Chapter 28 : Formula Copy
Chapter 29 : Gride Line Color and Formula Bar Off and On
Chapter 30 : Hide Graphics
Chapter 31 : Hiding Error On Printout
Chapter 32 : Hlookup Function
Chapter 33 : Hyperlink
Chapter 34 : If, OR, AND Function
Chapter 35 : Index Function
Chapter 36 : Information Function
Chapter 37 : Insert and Edit Data Multiple Worksheet
Chapter 38 : Insert Sheets
Chapter 39 : Insert Total Row
Chapter 40 : Insert Watermark
Chapter 41 : Large and Small Function
Chapter 42 : Left and Right Function
Chapter 43 : Lookup Formula
Chapter 44 : Macro Function
Chapter 45 : Manipulating Objects
Chapter 46 : Match and Index Function
Chapter 47 : Match Function
Chapter 48 : Mod Function
Chapter 49 : More Text Function
Chapter 50 : Nested If
Chapter 51 : Open a Copy of Workbook
Chapter 52 : Pivot Table
Chapter 53 : Print Comment In Excel
Chapter 54 : Print Gridlines and Headings
Chapter 55 : Printing a Draft of Worksheet
Chapter 56 : Printing a Portion of Worksheet
Chapter 57 : Printing Rows Conditionally
Chapter 58 : Printing Without Opening Workbooks
Chapter 59 : Print Page Number at the Bottom of Each
Chapter 60 : Print Several Worksheet on Single Page
Chapter 61 : Proper, Upper and Lower Function
Chapter 62 : Quickly Copy Formula
Chapter 63 : Quickly Insert Current Date and Time
Chapter 64 : Quickly Transpose
Chapter 65 : Rank Function
Chapter 66 : Replace and Substitute Function
Chapter 67 : Search Box
Chapter 68 : Selecting Group of Cells
Chapter 69 : Selecting Ranges with Keyboard
Chapter 70 : Share Workbook
Chapter 71 : Shortcut to Viewing Formulas
Chapter 72 : Spelling Check
Chapter 73 : Split Column Data
Chapter 74 : Switch Between Workbooks
Chapter 75 : Text Convert Number
Chapter 76 : Text Function
Chapter 77 : Transpose Function
Chapter 78 : Trick to Changed Predefined Group Name
Chapter 79 : Trick to Create Own New Tab
Chapter 80 : Trick to Insert Picture Comment
Chapter 81 : Trick to Open Specific Workbooks
Chapter 82 : Turn Off and On Worksheet and Scrollbar
Chapter 83 : Unprotect Spreadsheet
Chapter 84 : Vlookup Function
Chapter 85 : Weekday Function
Rs.1500* Rs.4500
67% OFFThis Course includes
85 Section
E-Books in pdf
Mock Test
Certification Test
Certification
Corporate Training
Enterprise training for Team
Get a QuoteRecommended Courses
Microsoft Office Word 2010 Complete Online Course
Complete basic to advance level online course on Microsoft Office Word also known as MS Word certified by NIFM.
Microsoft Office Excel 2010 Complete Online Course
Complete course on Microsoft Office Excel ( MS Excel ). Learn basic to advanced excel through videos.
DTP Photoshop Complete Certificate Online Course
Learn Desktop Publishing Adobe Photoshop graphic designing used for photo editing through our online certification course.
Advance Tally ERP 9 Accounting Software Complete course
Learn to certify for Tally ERP 9 a user friendly & successful accounting software for business accounting in India.
CorelDRAW Graphic Designing Complete Online Course
Corel Draw graphic designing software training course to create illustrations, page layout, web graphics etc.
GST in Tally ERP 9 Software Online Certificate Course
Complete Online GST course for Tally ERP, learn how to use latest tally software compatible for GST.
Microsoft Office 2010 Powerpoint Complete Online Course
Complete tutorial course on Microsoft office powerpoint application used to make presentations etc.
DTP Pagemaker Complete Certificate Online Course
Complete online course on DTP Pagemaker software for designing of page layout with practical training.
Wordpress course online
Best online certification course on wordpress to make your own websites or for your clients very easily.
Canva Graphic Designing Course
Canva Graphic Designing online course is the best easy course to became a graphic designer offered by NIFM institute.