MS Excel – You will Love Excel Just in 05 Hours

What you’ll learn
Master essential functions for effective data management and analysis.
Create impactful charts and graphs to interpret and present data.
Utilize advanced formulas for in-depth data analysis and problem-solving.
Learn to protect, share, and collaborate efficiently using Excel’s security features.

Requirements
No prior skill is needed

Description
Dive into the world of Microsoft Excel with this easy-to-follow course. It’s perfect for those starting out or looking to refresh their skills. You’ll learn the basics of Excel, from understanding the layout to organizing data neatly. We’ll guide you through creating eye-catching charts, performing simple calculations, and managing lists effectively. Plus, you’ll get tips on how to keep your data safe and share it with others smoothly. By the end of this course, you’ll be comfortable using Excel for everyday tasks, making your work or study life easier and more organized.Syllabus ContentI. Introduction to ExcelBasic Parts of Excel WindowHow to SaveHow to Page Setup & PrintII. Data Entry and FormattingItems in Group Clipboard (Home Tab)Items in Group Font (Home Tab)Items in Group Alignment (Home Tab)Items in Group Number (Home Tab)Inserting Pictures, Shapes & Smart ArtInserting Equation & SymbolInsert a Dropdown ListCheck SpellingHow to Hide GridlinesIII. Data Manipulation and AnalysisItems in Group Editing (Home Tab)Sum, Average, Rank, Max & MinCount & CountAUpper, Lower & First Letter CapitalCombine Word from Different CellsColumns to Rows & Vice VersaGroup Ungroup Columns and RowsRemove DuplicatesSplitting Data in a CellConverting Numbers into WordsFinding Number of Characters in a CellUsing LEFT, RIGHT, and MID FunctionsRemoving Extra Spaces Inside a CellIV. Data VisualizationWorking with ChartsInserting Graphs Inside a CellUse of SlicerInteractive Dashboard using HyperlinkPivot TablesV. Data Organization and ReferenceItems in Group Cells (Home Tab)Items in Group Styles (Home Tab)Freeze Rows & ColumnsRelative, Absolute, and Mixed ReferencesHow to use VLOOKUPHow to use HLOOKUPUsing ISNA with VLOOKUPTrace PrecedentsTrace DependentsMonitoring Cells with Watch WindowVI. Advanced Excel FunctionsIF functionEliminating Blank RowsAdding Current Date and TimeAuto Time Using VBALocking Certain Cells in a WorksheetProtecting a WorkbookPassword Protect Excel FileCalculating Loan InstallmentsUsing Scenario Manager for What-If AnalysisImplementing Goal Seek for Data OptimizationUsing Match FormulaBasic MacroVII. Data Integration and CollaborationImport Data Using QueriesHow to use Smart LookupHow to use TranslateHow to use CommentsFinding AgeFinding Hours WorkedWorkbook Statistics

Who this course is for
Excel Skill Development