In this video of this Excel course, you will learn all about number formatting in Excel.

This video covers the following topics:

— How to access number formatting options
— Using number formatting options using a dialog box
— Using custom number formatting

Remember that formatting a number in Excel only changes how it’s displayed, but the underlying value remains the same.

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 use Excel tables.

Excel tables are amazing, especially if you plan to work with a lot of data/dashboards/models.

And now that new tools (such as Power Query and Power Pivot) are available, it has made Excel tables even more powerful.

In this video, I cover the following topics:

— Creating an Excel Table
— Excel Table features
— Structured references
— Table slicers
— Note that table slicers became available only from Excel 2013 -version onward.

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 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.

And this video will teach you exactly that.

It covers the following topics:

— Cell address nomenclature
— Selecting cell/ranges in Excel
— Copying and moving cells/ranges in Excel
— Using paste special
— Selecting special cells
— Using find and replace to select cells
— Adding comments and
— Using quick analysis

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

This video covers the basics of Data Entry, editing as well as 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. Once done, press the enter key to move to the cell below. 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 01/01/2020).

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.

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 information and 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

All 4 files used in video and homework are available in this zipped folder: http://bit.ly/2JnYkyT
Download file individually at class web site: http://bit.ly/2GF25Ni
pfd notes for Video #21: http://bit.ly/2JfGAW1

In this video learn key strategies and Power Query Transformation Methods for reducing the size of your Data Model, or Columnar Database or File size. This is an important part of Data Analysis and Business Intelligence when you have Big Data because it can help your solution to run more efficiently by creating smaller Data Model behind the scenes Columnar Databases that must be loaded into RAM. Apply concepts of how the Columnar Database stores data when deciding what tables, columns and transformations should be part of the final Data Model.
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. (01:11) Download HUGE CSV File.
3. (01:34) Talk about How Columnar Database works and how we can reduce size.
4. (03:11) Rules for Efficient Data Modeling
5. (06:07) Get Data From Government Web Site: http://bit.ly/2IYfRht
6. (07:18) Import CSV Text File
7. (07:46) Load Entire CSV File and look at Model Size.
8. (09:20) Filter Rows and look at Model Size.
9. (10:56) Remove Columns and look at Model Size.
10. (11:40) Reduce Cardinality of Columns with 1) Add Column for Time
11. (13:59) Reduce Cardinality of Columns with 2) Transform Columns and get Date Only
12. (15:21) Edit Time Column to Create only Hour and reduce size further.
13. (16:39) Edit Query can lead to trouble in subsequent steps. See how to fix the problem.
14. (17:28) Add Date Table
15. (18:28) Create Relationship
16. (18:44) Create Measure to Count Rows for Call Type. Use COUNTROWS DAX Function.
17. (19:16) Create Dashboard
18. (19:16) Create Pivot Table
19. (20:17) Filter to show Top 20, 911 Call Types
20. (20:45) Show Values As in Data Model PivotTable
21. (22:07) Sort Measure Biggest to Smallest
22. (22:15) Add Slicers
23. (23:05) Scrape Data form Web Site
24. (24:18) Summary

View on YouTube

Download Excel Start Files: http://bit.ly/2vh7HIn
Entire page with all Excel Files for All Videos: http://bit.ly/1kSFWvs

In this video learn how to use the DAX Function COUNTROWS to simulate COUNTIFS in an Excel Worksheet. Use COUNTROWS to count with one or more conditions.

View on YouTube