Data Analyst Online Training - callus +919000444287

Data Analyst Online Training

Click Here For Enquiry

Excel Course Content Creating an Excel Workbook What’s New in Office Excel? How to Start Excel How to Create a New Default Excel Workbook How to Create A New Excel Workbook Using A Template Becoming Familiar with the Excel Screen How to Work with the Ribbon How to Use Access Keys How to Use the Office Button How to Access the Shortcut Menu Using the Mouse How to Show and Hide Workbook Elements Getting Help and Maintenance How to Search Help How to Get Help from Office Online How to Set the Auto Recover Options How to Recover An Excel File Moving Around Your Cursor How to Activate a Cell Using the Mouse How to Move to a Cell Using the Keyboard How to Move around Using the Go to Command How to Move to a Cell Using the Name Box How to Move Within a Selected Range How to Move to Other Sheets within a Workbook Entering Data into Worksheet How to Enter Text (Label) Into a Cell How to Undo and Redo Changes How to Enter Date into a Cell How to Use AutoFill to Enter Text How to Use AutoFill Options How to Use AutoFill to Enter a Sequence Of Numbers How to Save a Workbook for the First Time How to Save another Copy Using `Save As’ How to Save With a Different File Format How to Save To another Folder How to Close the Current Workbook How to Open a Workbook How to Exit Excel Performing Calculations Using a Simple Formula How to Resize the Formula Bar How to Enter A Formula Using the Keyboard How to Use AutoSum To Calculate Totals Selecting a Range Of Cells in Workbook How to Select a Single Cell How to Select a Range of Cells How to Select a Range of Cells Using <Shift> How to Select an Entire Column How to Select the Entire Row How to Select the Entire Worksheet How to Select Non-Adjacent Ranges How to Select Multiple Worksheets Managing Worksheets and Workbook Information Managing Worksheet Information How to Move Information Using Cut and Paste How to Drag and Drop Information How to Copy and Paste Information How to Use Paste Options How to Drag and Drop to Copy Information How to Insert a New Row How to Insert Multiple Rows How to Delete Rows How to Insert a New Column How to Insert Multiple Columns How to Delete Columns How to Insert A Cell Managing Workbook Information How to Rename Worksheet How to Add a New Worksheet How to Rearrange Worksheets How to Copy Worksheet How to Hide and Unhide a Worksheet How to Format a Worksheet Tab How to Delete a Worksheet Formatting Worksheets Adjusting Column Width / Row Height How to Adjust the Column Width Using the Mouse How to Adjust the Column Width Using the Menu How to Adjust the Row Height Using the Mouse How to Adjust the Row Height Using the Menu How to Hide / Unhide Rows / Columns How to Freeze a Column / a Row How to Split a Worksheet into Panes Formatting Cells Using the Ribbons How to Change the Font How to Change the Font Size How to Make Text Bold How to Italicize Text How to Underline Text How to Change the Font Color How to Align Data in A Cell How to Merge Cells How to Change Numbers to Percentages How to Increase / Decrease Decimal Places How to Copy a Format Using Format Painter How to Set a Password to Open a Worksheet How to Remove a Password from a Workbook How to Set a Password to Modify a Worksheet Using Conditional Formatting How to Use the Conditional Formatting To Highlight Cells How to Use the Data Bars How to Use the Color Scales How to Use the Icon Sets How to Edit the Rules How to Change the Precedence of the Rules How to Stop a Rule How to Clear the Rules Linking Information from Different Worksheets and Workbooks How To Link Information Using Copy And Paste Link Using Logical functions How to Use Logical Test How to Use IF Function to Return A Text How to Use IF Function to Return A Value How to Use A Nested IF Function How to Use the AND / OR Function Formatting Cells Using the Format Cells Dialog Box How to Align Cell Data Vertically How to Wrap Text in a Cell How to Format Dates How to Change the Background Color of a Cell How to Add an Outline Border How to Add a Double Line Border How to Draw a Border Using the Mouse How to Format a Table Quickly Creating a Chart How to Insert a Chart How to Move a Chart How to Resize a Chart How to Change the Chart Type How to Add, Edit or Remove a Chart Data Source How to Swap Labels in the Legend with the Horizontal Axis How to Change the Order of a Data Series How to Move an Existing Chart to a New Worksheet Setting up a Page and Printing Setting up a Page How to Insert and Remove a Page Break How to Set and Clear the Print Area How to Change the Margin in the Page Layout View How to Change the Scaling How to Change the Paper Size How to Change the Page Margin How to Add A Header / Footer Validating, Protecting and Auditing Forms & Templates Using Data Validation and Tracing Invalid Data How to Validate Data Input How to Create an Error Alert Message Protecting Worksheet Styles, Contents and Elements How to Protect the Worksheet How to Unprotect the Worksheet How to Unlock Cells for Editing In a Protected Sheet A Range without a Password Protecting Workbook Contents How to Use the COUNTIF Function Using the Auto Filter How to Enable / Disable the Auto Filter How to Apply / Remove the Filter How to Define the Criteria Range How to Use the Advanced Filter Excel Advanced Course Working with Tables Creating Tables How to Create a Table How to Change the Style of a Table How to Create a New Table Style How to Show or Hide Table Elements How to Create a Calculation in a Table How to Insert and Delete a Table Row How to Resize a Table How to Convert a Table to a Range How to Sort the Data in a Table How to Perform Multiple Sorts How to Set Customize the Sort Order Using the AutoFilter How to Enable / Disable the AutoFilter How to Apply / Remove the Filter How to Customize the Filter Using the Advanced Filter How to Define the Criteria Range How to Use the Advanced Filter Using Simple Database Functions How to Find the Sum of Specific Records Using the Insert Function Button How to Find the Average of Specific Records How to Find the Maximum / Minimum Value of Specific Records Using the VLOOKUP Function How to Use VLOOKUP to Find Data How to Limit the Lookup Value for an Exact Match Creating a Pivot table and Analyzing Data Creating a PivotTable How to Create A PivotTable Updating a PivotTable How to Update the Information in a PivotTable How to Change the Layout of a PivotTable How to Add an Information Field to a PivotTable How to Arrange Information in a PivotTable How to Filter the Report in a PivotTable How to Filter Specific Records Working With Calculated Fields in a PivotTable How to Change the Calculated Field Value Settings How to Insert a Calculated Field How to Delete Calculated Fields How to Change a PivotTable Options Using Workgroup Features Using Comments How to Add a Comment into A Cell How to Show/Hide Comments Permanently How to Show/Hide Comment Indicators How to Inspect a Workbook How to Apply Password Protection to the Editable Cells Automating Routine Tasks with Macros How to Record a New Macro How to Run a Macro How to Create A Run Macro Button