In this video of this Free Excel Training, you will learn about the following TEXT formulas:

— LEFT function
— RIGHT function
— MID function
— LEN function
— LOWER function
— PROPER function
— UPPER function
— FIND function
— -REPLACE function
— SUBSTITUTE function
— TEXT function

This video is a part of my Free Excel course where I show you how to use Excel from the basics and also cover a lot of advanced topics.

You can find more details about this Free Excel Training + the download files here: http://bit.ly/2snelIX

You can also access the Full Excel Training on YouTube here: https://www.youtube.com/watch?v=UPABcYhugZk&list=PLm8I8moAHiH2kkq0S9XGvIbPODrHzXRp6

-~-~~-~~~-~~-~-
Find Amazing Excel Tips & Tutorials:

TrumpExcel.com | Online Excel Tips & Tutorials (with videos)

-~-~~-~~~-~~-~-

Let’s Connect:
Google+ ► http://bit.ly/2jWiOzU
Facebook ► http://bit.ly/2j9gyrO
Twitter ► https://twitter.com/TrumpExcel
Pinterest ► http://bit.ly/2jWm2mZ
Youtube Channel ► https://www.youtube.com/c/trumpexcel

View on YouTube

If you want to get good with Excel, Lookup and Reference formulas are something you must learn about. You don’t need to know each and every formula, but a basic understanding of these will help you a lot.

In this video, you will learn about the following LOOKUP and REFERENCE formulas:

— VLOOKUP function
— HLOOKUP function
— INDEX function
— MATCH function
— OFFSET function
— INDIRECT function
— ROW function
— ROWS function
— COLUMN function
— COLUMNS function

This video is a part of my Free Excel course where I show you how to use Excel from the basics and also cover a lot of advanced topics.

You can find more details about this Free Excel Training + the download files here: http://bit.ly/2snelIX

-~-~~-~~~-~~-~-
Find Amazing Excel Tips & Tutorials:

TrumpExcel.com | Online Excel Tips & Tutorials (with videos)

-~-~~-~~~-~~-~-

Let’s Connect:
Google+ ► http://bit.ly/2jWiOzU
Facebook ► http://bit.ly/2j9gyrO
Twitter ► https://twitter.com/TrumpExcel
Pinterest ► http://bit.ly/2jWm2mZ
Youtube Channel ► https://www.youtube.com/c/trumpexcel

View on YouTube

In this video of this Free Online Excel Training, you will learn about the following logical formulas:

— AND function
— OR function
— NOT function
— TRUE function
— FALSE function
— IF function
— IFERROR function
— IS function

This video is a part of my Free Excel course where I show you how to use Excel from the basics and also cover a lot of advanced topics.

You can find more details about this Free Excel Training + the download files here: http://bit.ly/2snelIX

-~-~~-~~~-~~-~-
Find Amazing Excel Tips & Tutorials:

TrumpExcel.com | Online Excel Tips & Tutorials (with videos)

-~-~~-~~~-~~-~-

Let’s Connect:
Google+ ► http://bit.ly/2jWiOzU
Facebook ► http://bit.ly/2j9gyrO
Twitter ► https://twitter.com/TrumpExcel
Pinterest ► http://bit.ly/2jWm2mZ
Youtube Channel ► https://www.youtube.com/c/trumpexcel

View on YouTube

All 7 files and folders with text files used in video are available in this zipped folder: http://bit.ly/2VQiE2k

Download file individually at class web site: http://bit.ly/2GF25Ni
pfd notes for Video #22: http://bit.ly/2VOExiE

In this video learn about how to import a CSV Text file with server computer downtime, create the Data and Time Dimension Tables using DAX Table formulas and DAX Calculated Columns, Create Relationships and Measures to then build a Dashboard with Visualization for server downtime by year, month, day and hour. Learn about Custom Visualizations that you can download, and see the Word Cloud Visualization.
Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.
Topics:
1. (00:15) Introduction
2. (00:43) Import Large CSV File
3. (00:58) Look at Final Power BI Visualization
4. (01:36) Import Large CSV File
5. (02:00) Data Modeling on Fact Table with Power Query, including extracting date and time values from a single date-time column and filtering rows base on an Upper and Lower Date.
6. (04:20) Create Date Dimension Table with DAX Formulas. See the CALENDAR DAX Function and more. See how to use FORMAT DAX Function to get a Day Data Attribute with Day Name. See how to Sort By Column to get Data Attribute Columns to sort correctly in visualizations.
7. (08:20) Create Time Dimension Table using DAX Formulas. Learn about the GENERATESERIES DAX Function and more.
8. (09:16) Create DAX Calculated Column for Serial Time.
9. (10:00) Create Time Category using FORMAT Function. See two methods. Sort By Column to get Times to sort correctly in visualization.
10. (11:50) Hide Columns
11. (12:37) Create Measure for Total Server Downtime
12. (13:05) Create Relationships
13. (14:20) Create Line Chart with Year, Month, Day and Hour is the horizontal axis
14. (14:45) Learn about Drill Down in Power BI
15. (16:05) Create Matrix for Reason Server Computer is down
16. (16:30) Create Measure using SELECTEDVALUE DAX Function to use in a Card to show what Machine is being analyzed.
17. (17:20) Word Cloud Visualizations
18. (17:42) Download Custom Visualization in Power BI
19. (19:28) Summary

View on YouTube

In this video of this free Excel course, you will learn about tools that can help you when working with data in Excel.

In this lesson, I cover the following topics:

— AUTOFILL: This allows you to quickly fill data in contiguous cells. For example, you can have ‘Jan’ and ‘Feb’ in two adjacent cells and then you can use Autofill to get the other month names

— CUSTOM LISTS: Custom lists allows you to create your own lists that you can use in Autofill. For example, if you have 20 names, you can create a custom list and then use Autofill to get all the names by just dragging the mouse

— FLASH FILL: Flash fill is a new feature in Excel 2013 and allows you to identify a pattern in data and perform data slice and dice based on the pattern.

This video is a part of my Free Excel course where I show you how to use Excel from the basics and also cover a lot of advanced topics.

You can find more details about this Free Excel Training + the download files here: http://bit.ly/2snelIX

-~-~~-~~~-~~-~-
Find Amazing Excel Tips & Tutorials:

FREE Online Excel Training – Video Course for Beginners

-~-~~-~~~-~~-~-

Let’s Connect:
Google+ ► http://bit.ly/2jWiOzU
Facebook ► http://bit.ly/2j9gyrO
Twitter ► https://twitter.com/TrumpExcel
Pinterest ► http://bit.ly/2jWm2mZ
Youtube Channel ► https://www.youtube.com/c/trumpexcel

View on YouTube

In this video, you’ll learn how to manage worksheets in Excel.

This video will teach you a lot about working with worksheets.

For example, if you’re working with large datasets, you can use the functionalities such as splitting the worksheet or freeze panes to be more efficient.

It covers the following topics:

— Navigating through worksheets in Excel
— Changing worksheet name and color
— Adding/deleting worksheets
— Hiding/Un-hiding worksheets
— Moving/copying worksheets
— Comparing worksheets side by side
— Splitting worksheet into panes
— Freeze panes
— Saving and opening workbooks

This video is a part of my Free Excel course where I show you how to use Excel from the basics and also cover a lot of advanced topics.

You can also get this training and more resources here: http://bit.ly/2snelIX

-~-~~-~~~-~~-~-
Find Amazing Excel Tips & Tutorials:

FREE Online Excel Training – Video Course for Beginners

-~-~~-~~~-~~-~-

Let’s Connect:
Google+ ► http://bit.ly/2jWiOzU
Facebook ► http://bit.ly/2j9gyrO
Twitter ► https://twitter.com/TrumpExcel
Pinterest ► http://bit.ly/2jWm2mZ
Youtube Channel ► https://www.youtube.com/c/trumpexcel

View on YouTube