Excel intermediate Course
Excel Intermediate Course
January 6, 2018
Flutter
April 30, 2020
0
Excel advance Course

Netrut Excel Course for advance

These Excel training videos are made for you in Hindi and English language so that you can learn in the language of your chose. You can watch these videos at your convenience and on any type of device, be it desktop, laptop or mobile. The aim of these videos is to help you learn the topic of your choice in a fun manner and at your own pace.

Course Information

Estimated Time: 7 Days

Difficulty: Advanced

Categories:

Course Instructor

admin admin Author
 

Excel Advanced Course

₹99.00

Excel Advanced Course

 
Buy Now

Excel Advance Formatting

Conditional Formatting in Excel

Back to: Excel Advanced Course Back to Course Excel Advanced Course Next Lesson Text Functions

What will you learn in this Lesson ? Text Functions […]

Excel Text Functions

Text Functions

Back to: Excel Advanced Course

What will you learn in this Lesson ? Text Functions MS Excel: How to use the TEXT Function Excel Text Functions […]
How to use the Count function in Excel

Back to: Excel Advanced Course

What will you learn in this Lesson ? Using COUNT( ) Function in Excel how to count in excel What is […]
RIGHT function in Excel

Back to: Excel Advanced Course

What will you learn in this Lesson ? MS Excel: How to use the RIGHT Function Excel Text and String Functions […]
LEFT Function in Excel

Back to: Excel Advanced Course

What will learn in this Lesson ? MS Excel: How to use the LEFT Function LEFT Function in Excel Formulas with […]
MID Function in Excel

Back to: Excel Advanced Course

What will you learn in this Lesson ? Excel Text and String Functions: MID How to use the Excel MID function […]
Concatenate Function in Excel

Back to: Excel Advanced Course

MS Excel: How to use the CONCAT Function Concatenate function – join several strings into one text string Note: The concatenate function does […]
LOWER and UPPER Functions in Excel

Back to: Excel Advanced Course

What will you learn in this Lesson ? how to change lowercase to uppercase in excel How to capitalize words in […]
LEN Function in Excel

Back to: Excel Advanced Course

What will you learn in this Lesson ? How to use the Excel LEN function How to count the number of characters […]

Excel Data Tools

Convert Text to Columns in Excel

Back to: Excel Advanced Course

What will you learn in this Lesson ? How to separate data in a cell in Excel How to split a cell in […]
Removing duplicate values

Back to: Excel Advanced Course

How to remove duplicates in Excel Removing duplicate values – check for and delete specific cells with duplicate values

Previous Lesson Convert […]
Finding and Editing Records in Excel

Back to: Excel Advanced Course

What will you learn in this Lesson ? How to use the Excel FIND function How to search for a word in […]
Spelling Checker in Excel

Back to: Excel Advanced Course

What will you learn in this Lesson ? How to spell check in Excel How to turn on spell check in excel […]
Adding Worksheet Comments in Excel

Back to: Excel Advanced Course

What will you learn in this Lesson ? How to hide comments in Excel How to add a note to a cell in […]
Excel Copying Formats with the Format Painter

Back to: Excel Advanced Course

How to Use the Format Painter in Excel The Format Painter copies the formatting from one cell or range to another cell or […]
Copying Formats with Paste Special in Excel

Back to: Excel Advanced Course

What will you learn in this Lesson ? Using the Excel Paste Special Feature Effectively How to copy and paste in Excel […]
Validating Data Entry in Excel

Back to: Excel Advanced Course

How to create a validation in Excel To ensure that correct data is entered and stored in a worksheet, you can […]
Freeze Headers in Excel

Back to: Excel Advanced Course

How to freeze in excel To freeze a row in your worksheet, highlight the row where you wish all rows before […]
How to undo and redo changes in Excel

Back to: Excel Advanced Course

Where is Undo in Microsoft Excel 2007, 2010, 2013 and 2016 Learning Excel like any program is trial and error.  The […]

Excel Data Analysis

Compare two columns for match and differences in Excel

Back to: Excel Advanced Course

How to compare two Excel files or sheets for differences You can open two instances of Excel INSTEAD of multiple files […]
Excel Sorting

Back to: Excel Advanced Course

How to sort in excel Arranging data so it’s easy to analyze You can sort the data alphabetically, from highest to […]
Excel Filters

Back to: Excel Advanced Course

How to Filter Data in Excel The Filter is a quick and easy way to find and work with a subset of data […]
Excel Using Advanced Filtering

Back to: Excel Advanced Course

What will you learn in this Lesson? Filter and Advanced Data Filtering How to I filter multiple columns in Excel How […]
Microsoft Excel Table Tips and Tricks

Back to: Excel Advanced Course

How to create a data table Excel To make managing and analyzing a group of related data easier, you can turn a […]
Pivot Tables in Excel

Back to: Excel Advanced Course

How to Create a Pivot Table in Excel A Pivot table lets your arrange, sort, and filter a set of data […]
Inserting a chart in Excel

Back to: Excel Advanced Course

What will you learn in this Lesson ? Step-by-step guide to represent data in Chart Creating and Designing Charts What is […]
Pie Chart – Expense Distribution

Back to: Excel Advanced Course

How to Make a Pie Chart in Excel Highlight the Items column and the Total Expense Column (ctrl). Go to Insert tab. Select […]

Excel Dates and Times

Formatting cells with Dates and Times in Excel

Back to: Excel Advanced Course

How to change Excel date format and create custom formatting Right click on the cell and choose “Format Cells” From the […]
How Excel stores dates and times

Back to: Excel Advanced Course

What will you learn in this Lesson ? How to Microsoft Excel stores dates and times The Definitive Guide to Using […]
Time and Date in the same Cell

Back to: Excel Advanced Course

Excel separates date and time from one cell A cell can contain both a date and a time. The value of […]
Excel Date Arithmetic

Back to: Excel Advanced Course

Subtract dates in Excel & add days, weeks, months or years to date You can do arithmetic operations with dates. Add […]

Page Setup / Layout Print

Preview a Excel Workbook

Back to: Excel Advanced Course

How to Preview worksheet pages before printing – Excel Changing worksheet views Normal view Page Layout view Page Break Preview Page […]
Printing a Excel Workbook

Back to: Excel Advanced Course

How to print in Excel Print tab provides options for choosing what to print and how to print Printout includes only the […]

Excel Macro

How to Record a Macro in Excel – a Step-by-Step Guide

Back to: Excel Advanced Course

What will you learn in this Lesson ? What is the macro in Excel? What language is a macro written in […]
Recording a Macro in Excel

Back to: Excel Advanced Course

How to Automate tasks with the Macro Recorder in excel Recording a Macro In the Code group on the Developer tab, […]
Editing a Macro in Excel

Back to: Excel Advanced Course

What will you learn in this Lesson ? How to view a macro in Excel How to you edit a macro in Excel […]
Creating a Macro Button in Excel

Back to: Excel Advanced Course

How to insert a macro button to run macro in Excel In the Controls group on the Developer tab, click the […]
Saving Workbooks with Macros in Excel

Back to: Excel Advanced Course

How to save a macro in Excel On the Quick Access Toolbar, click the Save button Click No in the dialog box Save as […]
Opening a Workbook with Macros in Excel

Back to: Excel Advanced Course

What will you learn in this Lesson ? How to run a macro How to enable macros in a workbook How to enable macros […]
Hiding Worksheet Data in Excel

Back to: Excel Advanced Course

What will you learn in this Lesson ? Protecting and Hiding Information & Formulas How to hide a cell in Excel? How to […]