☰
Excel
- Featured Courses
Last Updated 24th April 2021
- 14 Classes
- All Levels
- 5
- (1 Rating)
Master Intermediate Excel Formulas. Solve Complex Problems. Learn Adva...
- Featured Courses
Last Updated 16th September 2020
- 14 Classes
- All Levels
- 5
- (1 Rating)
Master Advanced Excel 2013 Features. Become A Expert And Learn To Use...
- Featured Courses
Last Updated 2nd December 2020
- 51 Classes
- All Levels
- 5
- (3 Rating)
മൈക്രോസോഫ്റ്റ് എക്സൽ ഇനി മലയാളത്തിൽ വളരെ എളുപ്പത്തിൽ പഠിക്കാം.
.jpg)
- Featured Courses
Last Updated 20th April 2021
- 61 Classes
- All Levels
- 5
- (1 Rating)
Advanced syllabus for Microsoft Excel
Excel Courses
- 14 Courses
- 9 Students
- All Levels
Master Intermediate Excel Formulas. Solve Complex Problems. Learn Advanced Excel Skills to Save Time & Impress (Excel 2013)
- 499
2000
- (1 ratings)
What you will learn
- • Copying formulas. • Absolute and relative reference. • 3dformulas. • Auto-sum. • Displaying formulas. • Debugging...
- • Vlookup & Hlookup. • Vlookup Exact Match. • Nesting of Vlookup. • Vlookup large table. • Match function. • Choose...
- • If function. • Nesting of if functions. • Compound if.
- • Date arithmetic. • Today. • Weekday functions.
- • Cell. • Istext. • Isformula. • Iserror.
- • Aggregate. • Convert. • Mod. • Round functions. • Trunc and int.
- • Countif and Sumif. • Countifs. • Median and Mode. • Writing Flies and Folders.
- • Count and Counta. • Count Blank. • Large and small. • Rank.
- • Frequency.
- • Concatenate. • Find and Search. • Replace and Substitute. • Proper. • Left and Right. • Text and Rept.
- • What is macros • Create a Macro. • Assign a macro to Quick Access Tool Bar. • Assign a macro already created to an...
- • Using do loop in macros
- • How to use Do untill loop in macros • Use of for loop in macros • When one for loop comes in another at macros
- • Use for loop to create conditional formatting • Describes what is absolute and relative reference • How to save a ma...
- 14 Courses
- 1 Students
- All Levels
Master Advanced Excel 2013 Features. Become A Expert And Learn To Use Excel Like A Pro With This Advanced Excel Training
- 499
2000
- (1 ratings)
What you will learn
- • Interface • Quick Access bar – Customize • Create New File • Open • Touch/Mouse • Ribbon Overview • Ribbon Disp...
- • Zoom in and Zoom out • Borders • Insert Cells • Insert Rows • Insert Columns • Auto Fill • Undo and Redo • Save...
- • Average • Absolute reference Cell • Auto Sum • Minimum Function • Maximum Function • Median Function • STD Funct...
- • Merge and Center • Wrap Text • Year Function • Lookup Function • Sum If
- • Count Numbers • Count If • AND Function • If (AND Function • PMT Function • Format Cell • Number, Alignment, Fon...
- Number – Custom, Special, Date Text Alignment Horizontal and Vertical Indent Orientation Text Direction Superscript...
- • Pivot Table • Pivot table Field • Pivot Table Options • Refresh • Active Fields • Show Reporter Pages • Change D...
- • Shapes • Smart Art • Insert Chart • Values and Names • Spark Lines • Tools and Options • Hyperlink • Header and...
- • Width, Height and Scale • Grid Lines • Heading • Formula Tab • Data Tab • Trace Precedents • Trace Dependents •...
- • Flash Fill • What If Analysis • Scenario manger • Data Table • Goal Seek • Sub total • Review Tab • Spell Check...
- • Protect Work Book • View Tab • Page Break Preview • Group • Custom View • Zoom • Zoom To Selection • Arrange A...
- • Document panel • Inspect Work Book • Versions • Browser View Options • Templates • Recent Work Book • One Drive...
- 51 Courses
- 138 Students
- All Levels
മൈക്രോസോഫ്റ്റ് എക്സൽ ഇനി മലയാളത്തിൽ വളരെ എളുപ്പത്തിൽ പഠിക്കാം.
- 499
5000
- (3 ratings)
What you will learn
- Getting Started with Excel
- Entering, Editing and Number Formatting
- Formatting Data
- Working with Cells and Ranges
- How to Manage Worksheets
- Working with Tables
- Auto-fill - Custom Lists - Flash Fill
- Custom Number Formatting
- Create your First Formula
- 61 Courses
- 31 Students
- All Levels
Advanced syllabus for Microsoft Excel
- 999
9999
- (1 ratings)
What you will learn
- Explore fun, interactive, and highly effective lessons from a best-selling Excel instructor
- Master unique tips, tools and case studies that you won't find in ANY other course, guaranteed
- Learn how to THINK like Excel, and write powerful and dynamic Excel formulas from scratch
- Build Excel formulas to analyze dates, text fields, values and arrays
- Create dynamic reports by mastering one of the most popular tools, Pivot Tables
- Wow your boss by unlocking dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions and many more