Why this course?

Description

Enhance Your Microsoft Excel Skills and Increase Productivity at Workplace.
Learn Functions, Dashboard, MIS & many more...

You will learn the Following Points in Microsoft Excel

• Interface
• Tabs and Ribbons
• Selection Tips
• Navigation Tips
• Fonts, Fills, and Alignment
• Cut, Copy, and Paste
• Paste Special
• Moving, Finding, and Replacing a Value
• Cell Styles
• Formatting Numbers
• Managing Worksheets
• Modifying Rows and Columns
• Using Operations
• Creating Formulas
• Using Relative, Absolute, and Mixed References
• Zoom Features
• Freeze Panes
• Split Windows
• Viewing Multiple Windows
• Watermarks
• AutoFill and Custom Lists
• Conditional Formatting
• Insert a Table and Style Options
• Summarise With Pivot Table
• Data Validation
• Drop-Down Lists
• Removing Duplicates
• Text To Columns
• Goal Seek
• Scenario Manager
• Multiple Sheet References
• Consolidating Data - With or Without Links
• Trace the Precedents and Dependents
• Using the Watch Window
• VLOOKUP
• HLOOKUP
• XLOOKUP
• INDEX
• MATCH
• IF Statement, IFERROR
• Nested IF
• AND, OR, NOT
• SUMIF, SUMIFS, AVERAGE, MAX, MIN
• COUNT, COUNTA, COUNTIF & COUNTIFS
• Introduction to Charts
• Adding Graphics to Spreadsheets
• Outline, Sort, Filter, and Subtotal
• PivotTables
• Protecting Data
• Inserting Hyperlinks
• Sharing a Workbook
• Page Orientation
• Page Breaks, Print Area
• Margins, Headers and Footers, Scaling
• Printing setup
• AutoRecover Save Options
• Save As PDF
• Recording a Macro
• Assign a Macro to a Button or Shape
• MIS report
• Loan sheet
• NPV, IRR function
• Payroll sheet
• Automatic Dashboard