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

I have two great things to report about Excel. First, the old Tool Tabs in the Ribbon have become smaller. I love the new style and it makes perfect sense. Second, I have a bit of a rant about the questionable Microsoft Search box that is now dominating the Title Bar in Excel. Who is using this? Why are they making it so large? Great news part 2: If you plan to never use the Search box, minimize it to a tiny icon.

View on YouTube

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

In this video learn how to change Excel Option Setting so that new columns and rows in an Excel Table are automatically added to the Excel Table Object:
Options setting: File, Options, Proofing, Autocorrect Options, AutoFormat As You Type, check the textbox named “Included New Rows and Columns in Table”.

View on YouTube

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

In this video learn how to create a random table of text and number data that has a variable for number of rows using the INDEX Lookup Function and the Office 365 Dynamic Array Function RANDARRAY.

View on YouTube