Excel Courses How To Find A

You will also learn intermediate and advanced techniques such as how to find a value with VLOOKUP, create and format PivotTables, record basic Macros and more.

Study Time 3h 12m Video Duration data-triggerhover data-template data-placementauto right.

Study Time 2h 08m Video Duration data-triggerhover data-template data-placementauto right.

Study Time 3h 47m Video Duration data-triggerhover data-template data-placementauto right.

Excel Courses Download The Example

Module 2 - EXCEL ESSENTIALS Lesson 6 - Introduction to Excel Tables Click here to download the example Excel file In this video of this Free Online Excel Training, youll learn how to use Excel tables.

You dont need to sign-up or do anything to get access to the course.

Just scroll down and start watching the videos to learn Excel.

To make the most of this free training, please go through these Excel training videos in the sequence in which they have been listed.

NOTE: In case the video looks a bit blurry, you can change the video quality to 720p (by clicking on the settings gear icon on the bottom right of the video screen) In case youre an intermediate or advanced user, feel free to pick the lessons you want to watch.

Also, in case you have any questions or any feedback for me, kindly leave it in the comments area (at the bottom of this page).

In case you find the videos useful and would like to support me, you can buy me a coffee Modules Covered in this Free Excel Training MODULE 1 - EXCEL BASICS (for Beginners) Lesson 1 Getting Started with Excel This video is meant for Excel beginners.

In this video, I will show you the different parts of Excel working area.

In this video, youll learn about the following topics: Structure of the Excel working area, How to navigate in Excel, Ribbons and tabs, Quick Access Toolbar (QAT) Dialog Box Task Panes, Customizing ribbons and QAT, What is an active cell How to use ALT shortcuts Related Excel Articles: Creating Groups in Quick Access Toolbar Lesson 2 - Data Entry, Data Editing, and Number Formatting Once you know are comfortable with the layout of Excel, the next step is to learn how to enter and edit data in Excel.

You can enter three types of data in Excel numeric, text, and formulas.

To enter data in any cell, just select the cell and start typing.

In case you are entering dates, enter it in a format that Excel recognizes as a date (such as 01-01-2020 or 01 Jan 2020 or 01012020).

This video will show you how to enter data in Excel and edit already added data (such as deleting data, modifying existing data and replacing data).

Apart from this, it also covers the auto-fill in Excel as well as number formatting.

Related Excel Articles: Fill Numbers in Cells without dragging 10 Excel Data Entry Tips for Beginners Excel Data Entry Forms (Advanced) Custom Number formatting in Excel (Advanced) Lesson 3 - Data Formatting Click here to download the example Excel file This video covers the basics of data formatting in Excel.

You can format data in Excel to make it look better and to highlight some data points.

For example, if you have data-set and you want to highlight the negative numbers, you can simply highlight it in red color to it.

Here are some of the common formatting I use to make my data look better and more readable Applying borders to all cells Making headers bold Giving a background cell color to headers.

Center align the headers You can find these options in Home tab in the Font category.

Related Excel Articles: 5 Useful Excel Formatting Shortcuts How to Remove Cell Formatting in Excel Lesson 4 - Working with Cells and Ranges in Excel Click here to download the example Excel file In this video of this Free Online Excel Training, youll learn how to work with cells and ranges in Excel.

Since a worksheet in Excel is made up for cells, if you want to become proficient in Excel, you need to know how to best work with cells and ranges.

It covers the following topics: Cell address nomenclature Selecting cellranges in Excel Copying and moving cellsranges in Excel Using paste special Selecting special cells Using find and replace to select cells Adding comments and Using quick analysis Related Excel Articles: Find and Replace in Excel How to move Rows Columns in Excel Insert New Columns in Excel Excel AUTOFIT: Make RowsColumns Fit the Text Automatically Lesson 5 - Managing Worksheets Click here to download the example Excel file In this video of this Free Online Excel Training, youll learn how to manage worksheets in Excel.

It covers the following topics: Navigating through worksheets in Excel Changing worksheet name and color Addingdeleting worksheets HidingUn-hiding worksheets Movingcopying worksheets Comparing worksheets side by side Splitting worksheet into panes Freeze panes Saving and opening workbooks Related Excel Articles: Freeze Panes in Excel Hide Worksheets in Excel In case youre looking for advanced Excel training, please check out my other Free Online Excel training.

I currently have the following three courses: Dashboard Course, VBA course, Power Query Course.

Free Excel Courses For Mac