![Excel Insights](/img/default-banner.jpg)
- Видео 174
- Просмотров 951 440
Excel Insights
Филиппины
Добавлен 2 июл 2020
We feature educational content that suits people looking for skills that can improve their efficiency in the workplace, including MS Excel skills, Grammar Skills, Leadership concepts, and so on.
Generic Surface Keyboard (from Shopee) Review
This video reviews the features and differences of a generic Microsoft Surface Pro keyboard versus an original MS Surface keyboard. It is a bluetooth keyboard therefore, you need to pair it and charge it instead of it getting power from the tablet.
It is good as an alternative if you want a cheap option for keyboard for Microsoft keyboard that also has a pen compartment. There are slight differences like how the Escape button works.
It is good as an alternative if you want a cheap option for keyboard for Microsoft keyboard that also has a pen compartment. There are slight differences like how the Escape button works.
Просмотров: 55
Видео
Format Cell if Date is 30 Days To Go or About to Reach the Deadline
Просмотров 2414 дней назад
This video shows how you can have a cell that warns or prompts if the date is already less than 30 Days (or any number of days just change the 30 to whatever number of days you need to have a warning on) by using the IF formula or using conditional formatting New Rule option. This can be applied on problems about reaching deadlines, or items about to expire, or countdowns.
Compare Data Between Tables
Просмотров 3821 день назад
This video shows how to compare two tables from different tables, sheets, or files using one criterion or condition. This can be used to check if a data or row exists in the other table to check if that data has been removed or if there are new data in the other table or if there are changes or difference between files. This uses COUNTIF or COUNTIFS to check for similar data.
Group Dates into Months and Quarters in Pivot Tables
Просмотров 67Месяц назад
This video shows how to group dates into months and quarters or days in a Pivot Table in Excel. This also shows the solution when dragging dates into a PivotTable to change the automatic grouping into a different time interval.
Remove Background from an Image in PowerPoint
Просмотров 9Месяц назад
This video shows how to remove background from an image in your PowerPoint slide or presentation using the background removal tool. The video also shows how to correct the part of the image that will be removed when PowerPoint fails to detect the background correctly.
Use Emojis in Excel Formulas
Просмотров 57Месяц назад
This video shows how to use emojis in Excel using the shortcut key Windows and dot (.). The video shows that you just need to enclose the emoji in quotation marks so that you avoid an error when using emojis. You can even refer to other cells with emojis and use them in formulas. Finally, the video will show that you can also use emojis in tools like Conditional Formatting so that you can assig...
Remove Background in Canva
Просмотров 36Месяц назад
This video shows how to remove background in Canva by using the BG Remover Tool. This will further discuss how to modify the result of Canva removing the background by itself and that is with the use of Erase and Add tool. However, this is a paid feature. If you do not want to subscribe to Canva, you can use other programs like PowerPoint or other online tools.
Create Transparent PNG using PowerPoint
Просмотров 145Месяц назад
This video shows how to create transparent PNG image file in PowerPoint by using the Remove Background tool and inserting the image as a fill to the shape. This technique does not use any other programs but the file can be used in Photoshop or Canva or others.
Lookup Two Values under Two Separate Columns in a Table in Excel
Просмотров 82Месяц назад
This video shows how to lookup two values or criterion in Excel and search for them under two separate columns without the need to create extra columns. This maximizes how INDEX and MATCH utilizes arrays for its search column.
Lookup Two Values in Separate Columns in a Matrix in Excel
Просмотров 38Месяц назад
Lookup Two Values in Separate Columns in a Matrix in Excel
Control Page Contents when Printing in Excel
Просмотров 36Месяц назад
This video shows how to control which range of cells print in certain pages when printing in Excel. This is done by using Page Break preview and how to add new pages or reset pages or manage which cells goes to which page.
Add a Password to Specific Cells
Просмотров 53Месяц назад
This video shows how to add a password to specific range of cells in Excel, different from the password assigned to the worksheet. This can help prevent unauthorized editing to certain cells in the worksheet so that you can control who can edit specific cells only.
Display Texts in the Pivot Table Values Area Redo
Просмотров 341Месяц назад
This video is a remake of the previous video I created which has an error in the recording. This video shows how to input texts within the values area of the Pivot Table by writing an IF statement in the calculated field and using the Custom Format to assign a value to positive and negative values in the column.
Set a Deadline for a Shared Excel File to be Accessible
Просмотров 542 месяца назад
This video shows how to share a link to your Excel file directly from Excel (but you still need OneDrive account) and set a deadline until when the link can be used to access the file.
Find Last Value using LOOKUP Function
Просмотров 652 месяца назад
Find Last Value using LOOKUP Function
Create a SUMIFS like Measure in Power BI
Просмотров 1502 месяца назад
Create a SUMIFS like Measure in Power BI
Convert Vertical Data into a Table using WRAPROWS Function
Просмотров 953 месяца назад
Convert Vertical Data into a Table using WRAPROWS Function
Change Chart or Visual with Button Click in Power BI
Просмотров 1,5 тыс.3 месяца назад
Change Chart or Visual with Button Click in Power BI
Mail Merge Send Multiple Data from Excel to One Page in Word (for IDs, Certificates, etc.)
Просмотров 5604 месяца назад
Mail Merge Send Multiple Data from Excel to One Page in Word (for IDs, Certificates, etc.)
Rotate Multiple Icons Animation Effect in Canva
Просмотров 654 месяца назад
Rotate Multiple Icons Animation Effect in Canva
Perform FOREX or Currency Exchange in Excel using Currency Tool and the STOCKHISTORY Function
Просмотров 1304 месяца назад
Perform FOREX or Currency Exchange in Excel using Currency Tool and the STOCKHISTORY Function
Remove Empty Rows in VSTACK Result using FILTER Function
Просмотров 1,4 тыс.5 месяцев назад
Remove Empty Rows in VSTACK Result using FILTER Function
Count Dates if it Belongs to a Certain Month
Просмотров 2,9 тыс.5 месяцев назад
Count Dates if it Belongs to a Certain Month
Sort the Results of TEXTSPLIT Function using SORTBY Function
Просмотров 815 месяцев назад
Sort the Results of TEXTSPLIT Function using SORTBY Function
Use SUMX and RELATED Function in Power BI to Multiply Values from Different Tables in the Model
Просмотров 2,3 тыс.6 месяцев назад
Use SUMX and RELATED Function in Power BI to Multiply Values from Different Tables in the Model
Apply Conditional Formatting in PowerBI Visuals
Просмотров 7036 месяцев назад
Apply Conditional Formatting in PowerBI Visuals
Combine Data from Excel and Google Sheets
Просмотров 1647 месяцев назад
Combine Data from Excel and Google Sheets
OMG! Problem solved!! :D maraming salamat po sir :)
Finally! Lifesaver!! Thank you, Sir! :>
What If the time in is blank? which means that people didn't come, how do I go about that formula
please data source
This is incredible, thank you so much!
Boga
Can you do the Planned vs. Actual Cummulative.
ruclips.net/video/mMdK61o2HeA/видео.htmlsi=Q7kLzpJyMdCrtlQ8
Thanks for an easy to follow tutorial. Is it a 2 way link? Can I edit the content in Excel and push the changes to Google Sheets?
No, it is only a one way link
Thanks but This is not updating real time data.if i made any change in the sharepoint excel file then it don't reflect any solution pls
Hi, PowerBI does not update on its own. You have to Refresh the report in PowerBI desktop for it to pick up changes. If your report is published, you have to republish after Refresh to update the published version. You can schedule Refresh to simulate an "auto update" in the Pro version by going to the PowerBI online published version and look for Scheduled Refresh
so you cant really cut them out. you just make it seem like it's cut out
too bad the content i have under is not an image.. so ig there's no way to cut out shapes?
Amazing solution. It worked so well for me. Thank you!!!!
hi thanks for this. i tried it on google and i get error "The result of the array was not expanded because it would replace data in cell F4." any ideas?
Nice that is clear and easy learn for basis Power BI.
This is very helpful. How about the computation of 1 hr lunch break from 12nn to 1pm and, the 1hr breaktime will not deduct for the employee reported for half day and undertime work hours? Thank you
Hi, Christian, this solution in the video is only to deduct lates. If you need to deduct lunch time, you can less 60 minutes from the result. It is best to have another column do this because: what if the employee arrived 11AM? Will the person take lunch time still? Consider that as well
informative!!!
Thank you well done
Paano po gwin yang maliit na table na may yellow sa taas?
Hindi Yan "ginagawa". Meron Ka na Nyan dapat.
Best video yet on explaining this. Most videos don't explain Delimiters vs Fixed Width, they just automatically tell you to use Delimited. Thank you for this video.
Thank you! Glad you like it!
Still don't understand. Then again I am dumb
How beautiful u have explained is marvelous. Gbu
Glad it helped!
does it work on columns with formula?
Yes, it does.
thank you king
CAN u do it with 3 values. so lets say 2 in the columns, and one in the row. so imagine if in your data you also had a date function as a column. Where you need to find specific product in location ON A SPECIFIC DATE
Hope this helps: ruclips.net/video/d6r2ViI9t5M/видео.htmlsi=56ssT9fNzbU-ZCcB
Why cant use on table. If our array source is non-table, i can get the return value. But if i click Ctrl+T on that array source, it officially become table, and cant use this function anymore 😢 Is there any way?
do i need to complete all the actual start and finish date to generate the report? because i have set the baseline but the date are not complete yet as the project is ongoing, when i generate the report all the cummulative value in excel is 0
Hi, here's a video if the project is still ongoing: ruclips.net/video/4XjJ8lbAw14/видео.htmlsi=lfH7AV4-EVHUFWfR
Hi, This works really well for what I need. However, for some reason if I choose a range down the whole column it wants to count a blank cell as December. Do you know why that is?
you can also copy/paste your chart from sheets, when you paste on slides it asks you if you want to link it.
Thanks, boss!
thanks kuya this helped
great help! Thanks!
THANK YOU SO MUCH SIR
Thank you so much. Since Excel 2016 Perpetual License does not have a stock ticker price function but Google Sheets does(=googlefinance(ticker)), I am trying to use your method of linking the spreadsheets to routinely pull stock prices into Excel. As such I am not converting the Google Sheet to a csv because I want to keep the formulas live in the Google Sheet cells. Thanks for pointing me in the right direction. Before discovering your solution I spent hours looking for free Excel Add-ins without success and the queries of financial data web sites are too cumbersome to use in a constantly changing environment.
Thanks.
This was very useful ! Thank you
Glad it was helpful!
yo dawg, i heard you like xlookup
Very helpful, thanks!
This is a great video. Deserves way more views and Likes
amazing! thank you!
Great! Thank you for perfect coaching So how can we have both earliest Scurve and latest Scurve as envelope.
I eventually got it, but at least in excel 2007, you need to not include that first column (as you say), but include the row in the array (which you don't say. Strange. Thanks for the explanation!
Thank you, helping a lot
nice function, what if you wanted to take it further and capture P for only John as an example
You have to use COUNTIFS ruclips.net/video/NJUWO9xWUfk/видео.htmlsi=FcBuBMunC6lH4wgl
@@ExcelInsights oh thanks for the reply i actually already changed your counta to countif with the value size measured from a common value and changed the second value which you had to start down on that common value in the front. =countifs(offset(Roster!$F$1,match(A31,Roster!F:F,0),match(CasualTracker!$B$1,Roster!$G$1:$1,0),COUNTif(Roster!$B:$B,A31),14),"dropped")
any way to find hours and minutes?
lol manually making the third axis
Hi sir, from available fields from visual reports, i dont have baseline cumulative work and cumulative work to add to selected fields.. what to do sir..?
Thank you !!! I was looking for a video that taught me how to do those indentions for the last 30 minutes 😅 . I've got a college assignment to develop 100 tasks in excel to transfer it into MS project later . I will follow your format for the WBS ✌️
Thank you for this video...
Easy and straight forward
Really helpful! Thanks
bad video, too complicated, just make easy example for 2 or 3 rows only
Will the formula change if it is just 2 rows or 3 rows?