- Видео 132
- Просмотров 28 482
Doc Richard
Добавлен 3 фев 2012
This channel will present videos on how to use both basic and advanced tools in Excel. These videos are available for free. This channel is presented as a service and will not seek to be monetized, even if the monetization criteria are met.
Using Solver for Prescriptive Analytics
Using Solver for prescriptive analytics makes a lot of sense. This linear programming tool that comes as an Add-In in Excel will allow you to identify the optimal solution to a multi-variable problem in seconds. #excel #solver #linearprogramming
To follow along with the video, you can download the Excel file at the link below:
cowboyaccountingdata.s3.us-east-2.amazonaws.com/Using+SOLVER+in+Excel.xlsx
To follow along with the video, you can download the Excel file at the link below:
cowboyaccountingdata.s3.us-east-2.amazonaws.com/Using+SOLVER+in+Excel.xlsx
Просмотров: 2
Видео
Auto Updated Pivot Tables Using Power Query
Просмотров 463Месяц назад
Using Power Query, you can create a folder of Excel workbooks that are related and that automatically update every time you add new workbooks to the folder. It makes life so much more efficient. Power Query will not only add the new data to our analysis, but it will also carry out any cleaning instructions that you used on the previous data. #excel #powerquery Download the following three files...
Combining Excel Worksheets Using Power Query
Просмотров 137Месяц назад
Combining Excel Worksheets Using Power Query is a powerful tool for making your work more efficient. Not only can you combine the data, but you can also do cleaning at the same time on ALL the data instead of doing each worksheet separately. #excel #powerquery #combining #worksheets You can follow along with this video by downloading the excel file at the link below:
User Defined Calculated Items in Pivot Tables
Просмотров 85Месяц назад
When trying to add a row of calculated data to a Pivot Table, you must use the Calculated Items tool under Fields, Items & Sets. It is really easy and adds another dimension to our Pivot Tables. #excel #pivottable #userdefinedfunction To follow along, you can download the Excel file at the link below: cowboyaccountingdata.s3.us-east-2.amazonaws.com/Pivot Tables - User Defined Calculated Items.xlsx
User Defined Calculated Fields in Pivot Tables
Просмотров 84Месяц назад
Often you will find yourself in need of additional columns in a pivot table that must be calculated and which are not in the original data. The easiest and most efficient way to add those additional columns (or FIELDS) is to add a User Defined Calculated Field using the Fields, Items, & Sets tool in Excel. #excel #pivottable #userdefinedfunction #fields You can follow along with this video by d...
Critical Table Skills in Excel That Most People Do Not Know
Просмотров 105Месяц назад
Tables are one of the best tools in Excel for organizing Data. Next to Pivot Tables, these may be the most frequently used tools in Excel and can improve your organizational efficiency many times over. #excel #tables To follow along with the video, you can download the Excel file from the link below: cowboyaccountingdata.s3.us-east-2.amazonaws.com/Create a Table in Excel.xlsx 0:00 - Intro 0:45 ...
Writing Formulas & Functions in Excel
Просмотров 462 месяца назад
When we write formulas or use functions in excel, there are several ways we can accomplish the task. Using CNTRL-A is a great way to open up a function dialogue box very quickly when filling in the various arguments that you will need for that function. 0:00 - Intro 0:20 - Simple Formulas 0:46 - Using Built-In Functions 1:38 - Using Fx 3:11 - Using Ctrl A
Named Ranges in Excel
Просмотров 432 месяца назад
In Excel, the capability to assign names to ranges of data creates efficiency when referring to variables in formulas. #excel #namedranges To follow along with this video, you can download the Excel file at the link below: cowboyaccountingdata.s3.us-east-2.amazonaws.com/Creating Named Ranges.xlsx
Naming a Table in Excel
Просмотров 632 месяца назад
The ability to name a table in excel greatly enhances your options when referring to a specific table or trying to locate a specific table in an otherwise crowded workbook in Excel. This video will show you quickly how to name a table and how to use that table name to improve your efficiency. #excel #tables #tablenames To follow along with this video, you can download the associate Excel file a...
Tricks & Shortcuts for Dates and Time
Просмотров 332 месяца назад
excel provides some wonderful tools to help you tag your files with critical dates and time stamps. To follow along with this video, click on the link below and download the excel file: cowboyaccountingdata.s3.us-east-2.amazonaws.com/Shortcuts for Dates and Time in Excel.xlsx Time Stamps: 0:00 - Intro 0:36 - Download the Excel File 1:09 - Setting the Last Date Modified 2:03 - Setting Today’s Da...
Transpose Data in Excel
Просмотров 462 месяца назад
What do you do when you finish inputting your data to a spreadsheet and suddenly realize that the columns should have been rows and the rows should have been columns!!!! Oh NO!!! Well, don't blow a gasket . . . all you have to do is learn how to use the TRANSPOSE function in Excel or in Power Query and your problems will be solved! #excel #transpose #analytics To follow along with this video, y...
Custom Data Sorting in Excel
Просмотров 402 месяца назад
When you want to sort the data in perhaps "unconventional" way, custom data sorting is the "magic bullet". #excel #customdatasort #analytics To follow along with this video, you can download the Excel file at the link below: cowboyaccountingdata.s3.us-east-2.amazonaws.com/Custom Data Sorting.xlsx
Simple Data Sorting in Excel
Просмотров 512 месяца назад
Sometimes the data you are analyzing needs to be sorted in order to see patterns or relationships that otherwise might go unnoticed. The Data Sort tool in Excel can help you do that. #excel #datasorting #analytics You can follow along with the video by downloading the Excel file at the link below: cowboyaccountingdata.s3.us-east-2.amazonaws.com/Simple Data Sorting.xlsx
Excel Workbook Navigation
Просмотров 812 месяца назад
Moving around y our Excel Workbook can be a challenge as the size of the workbook increases . . . sometimes geometrically! This video will provide a wide variety of tools to enable quick and efficient navigation. To follow along with this video, you can download the Excel file at the link below: cowboyaccountingdata.s3.us-east-2.amazonaws.com/GPT Sales.xlsx 0:00 - Intro 1:52 - Where Are We? 3:1...
Convert a Table to a Range of Data
Просмотров 442 месяца назад
There are times when you need to convert a Table of data in Excel to a range of data. The process if fairly simple . . . if you know where the command can be found! #excel #datarange #tables You can follow along with this video by downloading the Excel file at the link below: cowboyaccountingdata.s3.us-east-2.amazonaws.com/Convert a Table to a Range.xlsx
Excel in 90 Seconds: More QuickFill Tools
Просмотров 264 месяца назад
Excel in 90 Seconds: More QuickFill Tools
Excel in 90 Seconds: Using TRIM #excel #trim #datacleaning
Просмотров 745 месяцев назад
Excel in 90 Seconds: Using TRIM #excel #trim #datacleaning
Using Power Query to Extract Data from the Web
Просмотров 975 месяцев назад
Using Power Query to Extract Data from the Web
Using Power Query to Extract Data from an Excel Workbook
Просмотров 8185 месяцев назад
Using Power Query to Extract Data from an Excel Workbook
Filling Blank Cells Rapidly in Excel
Просмотров 645 месяцев назад
Filling Blank Cells Rapidly in Excel
Converting Formula Results into Values
Просмотров 535 месяцев назад
Converting Formula Results into Values
Recover Forgotten Excel Read Only Passwords
Просмотров 1606 месяцев назад
Recover Forgotten Excel Read Only Passwords
Hi Sir! I don't get it: if higher SGAI and LEVI contribute to probability of a firm being more manipulative, why these factors are included with negative coefficients in the M-Score, consequently reducing that probability?
You are the best
So helpful, thank you
I love your videos, can you do the same in google sheets?
Excellent explanation! Thank you!
Can Meneish's M Score be applied to small business via P & L statement to help determine fraud ?
The Beneish M-Score was developed by looking at US public companies between 1982 and 1992. As such it may not be effective when used on non-public companies. In addition, the M-Score may not apply to banks or insurance companies, as they were not included in Beneish's original sample. Finally, the M-Score assumes that the company is using accrual accounting. As some small businesses may use cash-basis accounting, the M-Score would certainly not apply in those situations.
Thank you so much for this video
Probably a good video, but the sound quality makes it impossible to watch. It sounds like beatbox
Thanks for the heads up. I will take a look at it.
This follow-up video may help those of you who have questions. ruclips.net/video/_RYgEFRXEXQ/видео.html
Great and useful tip!
Thanks for the excellent tip to open a password-protected tab. In Excel, I use passwords to protect the entire file - meaning you can't open the file without the password. Are my files secure, or can one use the same relatively easy method to open a file-protected password? If my files are not protected with a file password - any suggestions to better protect the Ecel files? Thanks again for this video and your response.
Actually, a version of this solution will work. I will do a video on this tomorrow and post it. The best solution is to encrypt all important files. I use an Ironkey flash drive that encrypts all files and has on-board, 256-bit hard encryption. What amazes me is that this technique is not widely known.
I am editing a video tonight that will answer your question. As it turns out, absent a 3rd party hacking tool, using a file open password is the safest way to protect your file. A password for opening your excel file cannot be broken using the techniques I describe on this channel.
i've install fuzzy lookup add-ins and specific install is "all users for this machine" under Program Files (x86), after that i can't see fuzzy lookup add-ins in my excel (options>add-ins)
"Promo SM" 🌷
Mind blowing!🔥
Thank you for the kind words. I will work on getting a data sample loaded up.
Great video. Would love to have a download sample so I can play with and link it to your video. Thank you!