Microsoft

Sub Categories

Microsoft Courses

course
  • 14 Classes
  • 12 Students
  • All Levels

Master Advanced Excel Formulas. Solve Complex Problems. Learn Advanced Excel Skills to Save Time & Impress (Excel 2013)

  • 499 2000
  • (5)
  • (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...

course
  • 14 Classes
  • 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
  • (5)
  • (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...

course
  • 7 Classes
  • 2 Students
  • All Levels

PowerPoint when and where you need it. Design and deliver beautiful presentations with ease and confidence.

  • 499 2000
  • (5)
  • (1 ratings)
What you will learn
  • • Interface • Quick Access bar – Customize • Menu Bar • Home Tab • Insert Type • Formatting • Grow and Decrease F...
  • • Style, Solid Color, Gradients, Picture, Texture, Pattern • Line Properties • Shape • Position, Size, Text Box, Alt...
  • • Insert Table • Format Table • Table Borders • Cell Bevels, Shadows, Reflections • Draw Table • Eraser • Pen Colo...
  • • Image Format • Background Erasing of Image • Corrections • Color • Artistic Effects • Compress Pictures • Change...
  • • Color Themes • Color Patterns • Insert Shapes • Animations • Add Animation • Motion path • Adding Animation • P...
  • • Themes and Backgrounds • Customize Color • Format Background • Artistic Effects • Picture Corrections • Slide Siz...
  • • Use Presenter View • Play Narration • Use Timings • Show Presenter View • See All slides • Pen Marker • Highligh...

course
  • 11 Classes
  • 2 Students
  • All Levels

Learn the essential as well as the advanced features in Microsoft Word 2013 in an easy and compelling way.

  • 499 2000
  • (5)
  • (1 ratings)
What you will learn
  • • Interface • Key Board • Function Keys • Alphabetic Key • Numeric Keys • Print Screen • Mouse Over View • Word...
  • • Shadows. Glows, 3D Effects, Reflections, soft Edges • Formatting • Grow and Decrease Font Size • Font Color • Bol...
  • • Spell Check • Alignment • Left, Center, Right, Justify • Zoom • Bullets and Numbering • Symbols • Shading • Lin...
  • • Insert Table • Draw Table • Table Formatting • Insert Rows, Insert Columns • Header Row • Table Layout • Table D...
  • • Indentation • Left Indentation, Right Indentation • First Line Indent, Hanging Indent • Line Spacing • Insert Exce...
  • • Picture Border • Picture Effects • Picture Layout • Convert To Smart Art Graphics • Picture Format • Arrange • B...
  • • List, Process, Cycle, Hierarchy etc. • Layouts • Change Colors • Smart Art Styles • Add Shapes • Reset Graphic •...
  • • Screen Shot • Links • Comment • Header and Footer • Text Box • Auto Text • Document Property • Word Art • Drop...
  • • Margin • Columns • Size • Orientation • Breaks • Line Numbers • Hyphenation • Reference Tab • Table Of Content...
  • • Edit data Source • Review Tab • Spelling Grammar • Word Count • Track Changes • Track Changes Option • Reviewing...
  • • Protect Document • Inspect Document • Printing Document • One Drive • Share • Export • Create PDF File • Change...

course
  • 51 Classes
  • 83 Students
  • All Levels

മൈക്രോസോഫ്റ്റ് എക്സൽ ഇനി മലയാളത്തിൽ വളരെ എളുപ്പത്തിൽ പഠിക്കാം.

  • 499 5000
  • (5)
  • (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