Self-Paced LecturesOne MentorReal Life Examples

Microsoft Office

Upskill

Master Excel, Word, PowerPoint, and Data Management for efficiency. Ideal for students, professionals, and entrepreneurs.

Duration25+ hours

Views7 views/lecture

LanguageEnglish

Coverage100%

Validity1 YearT&C Apply

CourierCourier Not Provided

Course Description

This course covers covers four modules: MS Excel for data analysis and visualization, MS Word for document creation, MS PowerPoint for impactful presentations, and Data Management for organizing and storing information effectively. Whether you're a student, professional, or entrepreneur, this course equips you with the skills to work smarter and achieve your goals.

Category	Functions/Features
Mathematical	Sum, Sumproduct, Average, Averagea, Min, Mina, Max, Maxa, Small, Large, Abs, Count, Countblank, Counta, Aggregate, Mod, Rank, Absolute and Relative Referencing
Paste Special	Value, Format, Transpose, Link, Add, Subtract, Product and Many Useful Features
Rounding Functions	Round, Roundup, Rounddown (Also to nearest Tens, Hundreds and Thousands), Ceiling, Floor, and Mround
Date	Day, Date, Month, Year, Now, Today, Cleaning and Formatting
Text Functions	Trim, Concatenate, ‘&’, Lower, Proper, Upper, and Value
Advance Text	Left, Right, Mid, Replace, Substitute, Find, Len, Working With ‘*’ For Data Cleaning, Text To Column, and Other Advanced Data Cleaning Techniques
Shortcuts	Smart Editing Techniques, Learning Useful Shortcuts The Easy Way, and Formatting
Lookup Functions	Vlookup, Hlookup, and Automation Of The Same
Logical Operators	If, Nested If, And, Or, Isna, Iserror, Iserr, Isblank, Istext, Isformula, and XOR
Conditional Formatting	Basic Conditional Formatting (Formatting using Formulas covered in next Module)
Array Functions	Array formulas, Array constant, Create one dimensional and two dimensional constants, Dynamic Transpose