What you’ll learn in Excel
- Creating effective spreadsheets
- Managing large sets of data
- Mastering the use of some of Excel’s most popular and highly sought after functions (SUM, VLOOKUP, HLOOKUP, INDEX, MATCH, SLICER, PIVOT TABLS, FLASH FILL, IF, AVERAGE, COUNTA, SUMIF, SUBTOTAL, VALUE, and many more…)
- Create Dynamic MIS report with Excel PivotTables
- Learn how to work with charts in excel
- 160+ Keyboard Shortcuts to make your excel superstar
- 40+ Excel Magical Tips and Tricks to make your office work easier
- 40+ Excel basic and Advanced formulas
What you’ll learn in Word
- You will learn how to take full advantage of Microsoft Word
- All Tabs & Commands explained in full depth
- Begin with the basics of creating Microsoft Word documents
- Format documents effectively using Microsoft Word Styles
- Control page formatting and flow with sections and page breaks
- Create and Manage Table Layouts
- Perform Mail Merges to create Mailing Labels and Form Letters
- Track and Accept/Reject Changes to a Document
- Preparing documents for printing and exporting
- How to make Company Letter Head, Curriculum Vitae, Letter
- 20 Useful Keyboard Shortcuts
- 20+ MS Word Tips for make Office Work easier
What you’ll learn in PowerPoint
- Mastering Visual Impact: Discover the art of crafting eye-catching slides that captivate your audience from the first glance. Learn proven techniques to design visually appealing presentations that leave a lasting impression.
- Custom Design Perfection: Elevate your slides to perfection with custom designs tailored to your unique style and message. Unlock the secrets to creating polished presentations that reflect your professionalism and attention to detail.
- Dynamic Transitions and Sound Effects: Explore the world of transitions and sound effects to add depth and dimension to your presentations. Learn how to seamlessly integrate audiovisual elements to enhance the flow and impact of your slides.
- Animating Slide Content: Dive into the intricacies of animation and bring your content to life with dynamic effects and transitions. Master the art of animation to create engaging presentations that captivate and inspire.
- Tailored Customization: Customize your slideshow with precision and finesse using advanced tools and techniques. From layout adjustments to font selection, learn how to tailor every aspect of your presentation to perfection.
- Harnessing the Designer Tool: Unleash the full potential of PowerPoint’s Designer Tool to effortlessly create professional-looking presentations in minutes. Streamline your workflow and elevate your presentations with cutting-edge design suggestions.
- AI-Powered Presentations: Explore the future of presentations with AI integration. Discover how artificial intelligence can revolutionize the way you create and deliver presentations, making the process smarter, faster, and more efficient.
- Crafting Photo Albums: Learn how to transform your photos into captivating photo albums with PowerPoint’s versatile features. From arranging images to adding captions, unlock the secrets to creating stunning photo presentations.
What you’ll learn in Outlook
Outlook course will be upload by this week.
You do not need much technical knowledge to do this course, you should only know how to run a computer.
Course Features
- Lectures 167
- Quiz 1
- Duration 60 hours
- Skill level All levels
- Language Hindi
- Students 29
- Certificate Yes
- Assessments Self
Curriculum
- 6 Sections
- 167 Lessons
- Lifetime
Expand all sectionsCollapse all sections
- Excel for BeginnersLearn Microsoft Excel from Beginners to Advanced55
- 1.1Excel Shortcuts PDF & Practice Files – Download
- 1.21 Excel – 4 ways to Start Excel2 Minutes
- 1.32 Excel – Excel Complete Structure19 Minutes
- 1.43 Excel – Write, Enter, Delete, Modify, Select Value12 Minutes
- 1.54 Excel – File Menu Complete21 Minutes
- 1.65 Excel – Quick Access Toolbar – Save, undo, Redo, Add or Remove Command11 Minutes
- 1.76 Excel – Cut, Copy, Paste, Format Painter, Clipboard18 Minutes
- 1.87 Excel – Font & Settings41 Minutes
- 1.98 Excel – Alignment & Settings29 Minutes
- 1.109 Excel – Number Format & Settings36 Minutes
- 1.1110 Excel – Complete Conditional Formatting33 Minutes
- 1.1211 Excel – Format As Table, Cell Style14 Minutes
- 1.1312 Excel – Insert and Delete Cell, Row, Column, Sheets25 Minutes
- 1.1413 Excel – Format Commands All Options33 Minutes
- 1.1514 Excel – Autosum Fill & Clear Function35 Minutes
- 1.1615 Excel – Sort and Filter Find and Select16 Minutes
- 1.1716 Excel – Illustrations12 Minutes
- 1.1817 Excel – Insert Charts, Filter, Element and Style10 Minutes
- 1.1918 Excel – Hyperlink, Text, Symbol Complete19 Minutes
- 1.2019 Excel – Page Layout & Setup32 Minutes
- 1.2120 Excel – Text To Column Function8 Minutes
- 1.2221 Excel – Remove Duplicate Function6 Minutes
- 1.2322 Excel – Consolidate Function – Summarize Data8 Minutes
- 1.2423 Excel – Goal Seek Function with 2 Examples13 Minutes
- 1.2524 Excel – Group Ungroup Subtotal Function7 Minutes
- 1.2625 Excel – Comments All Option6 Minutes
- 1.2726 Excel – View Tab Complete13 Minutes
- 1.2827 Excel – Start new Line in Same Cell5 Minutes
- 1.2928 Excel – Absolute Reference – Why we lock Cells/Range12 Minutes
- 1.3029 Excel – Save 1000s Excel Charts as image2 Minutes
- 1.3130 Excel – How to Use Flash FillCopy4 Minutes
- 1.3231 Excel – Sort Data Row WiseCopy4 Minutes
- 1.3332 Excel – Filter Secret Tips and Tricks10 Minutes
- 1.3433 Excel – Convert Excel to Image6 Minutes
- 1.3534 Excel – Data Entry Work in excel6 Minutes
- 1.3635 Excel – Write Big Number in Excel8 Minutes
- 1.3736 Excel – How to Use Macro in Excel10 Minutes
- 1.3837 Excel – Remove Extra Space from Excel Sheet4 Minutes
- 1.3938 Excel – How to Save Excel File as PDF3 Minutes
- 1.4039 Excel – Use Hyperlink on Same Sheet5 Minutes
- 1.4140 Excel – Link Excel File to MS Word Automatic Update4 Minutes
- 1.4241 Excel – How to Protect Excel File7 Minutes
- 1.4342 Excel – 7 Ways to SUM, Subtract, Multiple, Divide26 Minutes
- 1.4443 Excel – Percentage Calculation (3 examples5 Minutes
- 1.4544 Excel – Index Formula8 Minutes
- 1.4645 Excel – Match Formula5 Minutes
- 1.4746 Excel – Count, Counta, CountBlank Formula6 Minutes
- 1.4847 Excel – Vlookup Formula8 Minutes
- 1.4948 Excel – Sumif and Sumifs Formula11 Minutes
- 1.5049 Excel – If Formula9 Minutes
- 1.5150 Excel – Hlookup6 Minutes
- 1.5251 Excel – Rand & RandBetween Formula4 Minutes
- 1.5352 Excel – SumProduct Formula3 Minutes
- 1.5453 Excel – Create Check Box6 Minutes
- 1.5554 Excel – Split Data from One Column to Multiple Column4 Minutes
- Advanced Excel67
- 2.1How to Use ChatGPT for Excel Work 10130 Minutes
- 2.255 Excel – Pivot Table & Pivot Chart20 Minutes
- 2.356 Excel – Refresh Pivot Table (4 Method)6 Minutes
- 2.457 Excel – Create Pivot Table from Multiple Sheets8 Minutes
- 2.558 Excel – Split Data from Master Sheet to Multiple Sheets24 Minutes
- 2.659 Excel – Slicer9 Minutes
- 2.760 Excel – Prepare Dynamic MIS Report15 Minutes
- 2.861 Excel – Maintain Multiple Stock / Inventory46 Minutes
- 2.962 Excel – Prepare Attendance Register16 Minutes
- 2.1063 Excel – Search Box Using7 Minutes
- 2.1164 Excel – Google Translate formula5 Minutes
- 2.1265 Excel – 3 Best Method to Transpose6 Minutes
- 2.1366 Excel – 5 Way to Remove Duplicates Data19 Minutes
- 2.1467 Excel – 4 Way to Add Zero Before any Number7 Minutes
- 2.1568 Excel – Excel Sheets Tips and Tricks14 Minutes
- 2.1669 Excel – Make Automatic Update Drop Down List19 Minutes
- 2.1770 Excel – Calculate Running Total6 Minutes
- 2.1871 Excel – Create Notification or Reminder for Due Dates11 Minutes
- 2.1972 Excel – Excel 165 + Keyboard Shortcuts2 Hours
- 2.2073 Excel – Fully Automatic GST Invoice57 Minutes
- 2.2174 Excel – Save Each Invoice in PDF format automatically11 Minutes
- 2.2275 Excel – Unstack Excel Data from One Column to Multiple Column6 Minutes
- 2.2376 Excel – Convert any Image or Printout to Excel6 Minutes
- 2.2477 Excel – Mail Merge with Decimal Problem Solution14 Minutes
- 2.2578 Excel – Recover Unsaved Excel file8 Minutes
- 2.2679 Excel – Prevent/Stop Duplicate Entries in Excel14 Minutes
- 2.2780 Excel – Excel Trick to Find Wrong Mobile Number5 Minutes
- 2.2881 Excel – 7 way to Jump on any Excel Sheet2 Minutes
- 2.2982 Excel – Amazing Use of 1 Number Value5 Minutes
- 2.3083 Excel – Hide Formula6 Minutes
- 2.3184 Excel – Convert any Text to lower Proper UPPER case in same cell6 Minutes
- 2.3285 Excel – Highlight a Particular Word or Number5 Minutes
- 2.3386 Excel – Data Filtering Problem9 Minutes
- 2.3487 Excel – Create Data Entry form9 Minutes
- 2.3588 Excel – Highlight Active Cell Row and Column4 Minutes
- 2.3689 Excel – Unlock Protected Sheet without knowing Password6 Minutes
- 2.3790 Excel – Maintain Overtime & Overtime Wages22 Minutes
- 2.3891 Excel – 3 Formula to Calculate Rank9 Minutes
- 2.3992 Excel – Double Vlookup Formula11 Minutes
- 2.4093 Excel – Amazing Use of Hlookup Formula12 Minutes
- 2.4194 Excel – Fuzzy lookup8 Minutes
- 2.4295 Excel – Picture Lookup in Excel10 Minutes
- 2.4396 Excel – Subtotal formula14 Minutes
- 2.4497 Excel – Sumif Vs Sumifs10 Minutes
- 2.4598 Excel – Value Formula8 Minutes
- 2.4699 Excel – Index + Match Formula15 Minutes
- 2.47100 Excel – Quotient and Mod Formula6 Minutes
- 2.48101 Excel – Add Search Box in Slicer Function9 Minutes
- 2.49102 Excel – Compare Two List with Match Formula6 Minutes
- 2.50103 Excel – Import 1000 Excel Contact to Mobile7 Minutes
- 2.51104 Excel – Convert Formula – Easy way to convert units9 Minutes
- 2.52105 Excel – Forecast Formula5 Minutes
- 2.53106 Excel – Average Vs Averageif Formula6 Minutes
- 2.54107 Excel – Countif Formula in Excel4 Minutes
- 2.55108 Excel – Concatenate Formula8 Minutes
- 2.56109 Excel – Average, Averageif and Averageifs Formula12 Minutes
- 2.57110 Excel – Make Searchable Drop Down List6 Minutes
- 2.58111 Excel – Insert Right Tick and Cross Tick10 Minutes
- 2.59112 Excel – Excel 12 Tips And Tricks21 Minutes
- 2.60113 Excel – 06 Tips and Tricks19 Minutes
- 2.61114 Excel – 06 Tips and Tricks14 Minutes
- 2.62115 Excel – 02 Tips and Tricks7 Minutes
- 2.63116 Excel – 07 Tips and Tricks14 Minutes
- 2.64117 Excel – 05 Tips and Tricks11 Minutes
- 2.65118 Excel – 05 Tips and Tricks10 Minutes
- 2.66119 Excel – 04 Tips and Tricks18 Minutes
- 2.67120 Excel – Excel Tips for Copy formula4 Minutes
- Microsoft Word from Beginners to Advanced34
- 3.01 Word – Ways to Start MS Word, Complete Structure33 Minutes
- 3.12 Word – Write, Delete, Select, Save Docs.13 Minutes
- 3.23 Word – Quick Access Toolbar8 Minutes
- 3.34 Word – File Menu Complete52 Minutes
- 3.45 Word – Cut, Copy, Paste, Format Painter, Clipboard22 Minutes
- 3.56 Word – Font Group & Setting29 Minutes
- 3.67 Word – Paragraph Group Settings & Style48 Minutes
- 3.78 Word – Find Replace Select16 Minutes
- 3.89 Word – Cover Page, Picture, Shapes35 Minutes
- 3.910 Word – Blank Page, Page Break, Table57 Minutes
- 3.1011 Word – Illustrations46 Minutes
- 3.1112 Word – Hyperlink, Bookmark, Comment18 Minutes
- 3.1213 Word – Insert Header Footer & Page Number23 Minutes
- 3.1314 Word – Text Group All Functions35 Minutes
- 3.1415 Word – Equation and Symbol9 Minutes
- 3.1516 Word – Design Tab Complete19 Minutes
- 3.1617 Word – Layout Tab Complete32 Minutes
- 3.1718 Word – Reference Tab Part 123 Minutes
- 3.1819 Word – Reference Tab Part 223 Minutes
- 3.1920 Word – Mailing Tab Part 129 Minutes
- 3.2021 Word – Mailing Tab Part 239 Minutes
- 3.2122 Word – Review Tab Part 118 Minutes
- 3.2223 Word – Review Tab Part 220 Minutes
- 3.2324 Word – View Tab Complete & Help20 Minutes
- 3.2425 Word – Make Company Letter Head25 Minutes
- 3.2526 Word – Make Curriculum Vitae25 Minutes
- 3.2627 Word – Prepare Letter7 Minutes
- 3.2728 Word – 20 Useful Magical Shortcuts23 Minutes
- 3.2829 Word – 4 Useful Tips and Trick19 Minutes
- 3.2930 Word – 3 Useful Tips24 Minutes
- 3.3031 Word – Restore Break Line Paragraph & Split MS Word Pages19 Minutes
- 3.3132 Word – 10 Most Useful Magical Tricks22 Minutes
- 3.3233 Word – 4 Small & Valuable Tips for Word12 Minutes
- 3.33MS Word All shortcuts PDF & Practice File – Download
- Microsoft PowerPoint from Beginners to Advanced11
- 4.11 PowerPoint – Basics of PowerPoint23 Minutes
- 4.22 PowerPoint – Create Powerpoint Presentation41 Minutes
- 4.33 PowerPoint -Design Tab18 Minutes
- 4.44 PowerPoint – Transition Tab26 Minutes
- 4.55 PowerPoint – Anitmation Tab43 Minutes
- 4.66 PowerPoint – Slide Show Customization19 Minutes
- 4.77 PowerPoint – Record Tab (Screen, Audio, Camera Feed Recording)27 Minutes
- 4.88 PowerPoint – Review and View Tab14 Minutes
- 4.99 PowerPoint – Designer Tool6 Minutes
- 4.1010 PowerPoint – Create Photo Album in PowerPoint
- 4.1111 PowerPoint – Create PowerPoint Presentation with AI
- Outlook from Beginners to Advanced0
- Final Quiz for Certificate1
1 Comment
Sairam sir, please let me know after purchasing the course how long it is valid for assessment.