Jumpstart with MS Excel ❖ Introduction to MS Excel .Concept Spreadsheet, Worksheet & Workbook. Tell the name of its workspace. Navigate with name box. Number of row & Column. ❖ Customize the ribbon & Quick Access Toolbar. Make a new ribbon. Change its settings. ❖ How Excel Works? ❖ File management related command ❖ Excel Major Data Type Excel Formula & Functions ❖ Formula anatomy of Excel. ❖ Assignment operator, ❖ arithmetic operator, ❖ variable, constant ❖ Create formula to calculate value. Manual addition & average. ❖ Functions importance over formula in Excel ❖ Understanding Functions components(Arguments, single, array) ❖ Most Popular functions(Sum, Average, max, min, count) Cell Reference in Formula ❖ Cell Referencing of Excel ❖ Relative Reference ❖ Absolute Reference ❖ Mixed Reference ❖ Use absolute reference & Mixed Reference Editing & Proofing ❖ Enter and revise data ❖ Auto Fill & Fill Series ❖ Manage data by using Flash Fill ❖ Find and replace data ❖ Spelling, Grammar & Thesaurus Changing Worksheet appearance ❖ Format cells & use format painter ❖ Define styles ❖ Make numbers easier to read ❖ Change the appearance of data based on its value ❖ Add images to worksheets Managing Large workbook ❖ Printing your preferred data ❖ Organize sheets inside a single workbook ❖ Move & Copy data inside a workbook ❖ Protect sheets & Workbook Module-2 PROFESSIONAL
Working With Multiple Worksheets & Workbooks ❖ Reference Cells and Groups of Cells across Worksheets ❖ Link Cells to External Worksheets ❖ Consolidate Data across Worksheets ❖ Use Magical 3D Formula Create Data Subset using Excel Tables ❖ Why Excel table is useful? ❖ Get the benefits from Total row ❖ Sorting & Filtering feature of Excel table ❖ Removing Duplicates in a data table Create Formula based on Condition ❖ Understanding Excel If function ❖ Know Logical test, True Condition & False condition ❖ Create a new condition-based formula using existing one. ❖ Use nested IF functions ❖ Enhance your IF functions using AND() & OR() functions More Conditional functions ❖ Understanding SUMIF & COUNTIF ❖ SUMIFS & COUNTIFS ❖ COUNTIF & COUNTIFS function Lookup & Reference functions ❖ Create hyperlink in Excel ❖ The Basic Lookup ❖ Advanced Lookups ❖ Information Functions Visualizing Your Data ❖ Data Bars ❖ Color Scales ❖ Icon Sets Module-3 MASTER Formula Auditing & find errors in formula ❖ Display Relationships between Cells and Formulas with the Trace Command ❖ Watch Cells and Formulas from the Watch Tool ❖ Difference between IF Error & Is error functions Automating Workbook Functionality ❖ Create and Manage Validation Rules ❖ Invalid Data and Formulas with Errors ❖ Record Macros to Automate Tasks Worksheet Collaboration ❖ Preparing Your Workbook ❖ Distributing Your Workbook ❖ Adding Comments ❖ Tracking Changes ❖ Sharing Your Workbook Data analysis using PivotTables & Slicers ❖ Building Pivot Tables ❖ Fine-Tuning Pivot Table Calculations ❖ Filtering a Pivot Table ❖ Pivot Charts ❖ Using Slicers Forecasting your Data ❖ Determine Potential Outcomes Using Scenarios ❖ Solve for Desired Outputs with the Goal Seek ❖ Feature Forecast Data Trend
Curriculum
Certified Training on: Mastering Microsoft Excel-Basic to Advance
Certified Training on: Mastering Microsoft Excel-Basic to Advance
