Excel Helps
Excel Helps
  • Видео 91
  • Просмотров 85 877
New Excel Translation Functions
Two new excel translation functions have been released to the beta channel for testing from members of the Microsoft insider program. TRANSLATE and DETECTLANGUAGE will be useful for automating the translation or detection of foreign languages that your business may operate with. This can be a huge time saver if you are able to integrate these formulas with current translation practices with excel files.
More information regarding the Microsoft insider program can be found here :
techcommunity.microsoft.com/t5/microsoft-365-insider-blog/bg-p/Microsoft365InsiderBlog/label-name/Insider%20program
This excel file is available for download here :
excelhelps.github.io/ExcelHelps/ExcelDatasets.html...
Просмотров: 60

Видео

Using the Switch Function in Excel
Просмотров 3,4 тыс.21 день назад
The SWITCH function in excel allows you to replace multiple logic tests such as the IFS function by changing the output of one expression. This can help you to avoid mistakes and simplify the syntax. Check out my TikTok Channel for short length content. www.tiktok.com/@excelhelps1 Check out my Webpage for Practice datasets in Excel and resources for learning how to code! excelhelps.github.io/Ex...
Are Credit Cards Worth Using?
Просмотров 73Месяц назад
Credit Cards can have useful perks that will reward you based on how much you spend. This can be a tool to overspend and get in debt. Proper use of credit can help you gain the benefits with avoiding the negative aspects. Let me know if you would like any other videos covering credit topics! Check out my TikTok Channel for short length content. www.tiktok.com/@excelhelps1 Check out my Webpage f...
How to use Checkboxes in Excel
Просмотров 2062 месяца назад
Checkboxes recently released to the Current Channel on Excel. This means they are available for all users. This feature will help to simplify the creation and use of Excel spreadsheets in the future. Download a copy of the file used in this video here : excelhelps.github.io/ExcelHelps/ExcelDatasets.html#FT Check out my TikTok Channel for short length content. www.tiktok.com/@excelhelps1 Check o...
Essential Fantasy Football Spreadsheet Tips
Просмотров 7122 месяца назад
This video covers tips for working with data related to fantasy football cheat sheets and player stats. Working with this type of information will help you create better spreadsheets and can help with various other situations when using Excel and Google Sheets to import and analyze data. Link to Cheat Sheets : www.espn.com/fantasy/football/story/_/page/FFCheatSheetCent24-39970898/2024-fantasy-f...
Power Query to Combine and Import Files in Excel
Просмотров 2283 месяца назад
Combing files in excel is made easy with power query. Various Data files are compatible with power query such as Excel Workbooks, Text/CSV files, connections with a database, JSON and XML. This allows Appending and Merging of multiple files at once with built in features. Check out my TikTok Channel for short length content. www.tiktok.com/@excelhelps1 Check out my Webpage for Practice datasets...
New Excel Functions - Regular Expression "Regex"
Просмотров 3333 месяца назад
The three new Regex functions are covered in this video to introduce you to the concepts behind the newly released functions. As well as the tokens available to create patterns or sequence. Join the Microsoft Insider program Link : insider.microsoft365.com/en-us/join/windows Check out my TikTok Channel for short length content : www.tiktok.com/@excelhelps1 Check out my website for practice data...
Keyboard Shortcuts in Excel - Pt. 1
Просмотров 2114 месяца назад
Save time by learning the most used keyboard shortcuts in Excel. These features allow for easy cell navigation and manipulation. Link to download the file in the video : excelhelps.github.io/ExcelHelps/ExcelDatasets.html Check out my TikTok Channel for short length content. www.tiktok.com/@excelhelps1 Check out my Webpage for Practice datasets in Excel and resources for learning how to code! ex...
Beginner's Guide to VBA in Excel Part 3 : Introduction to Loops
Просмотров 2485 месяцев назад
Beginner's Guide to VBA in Excel Part 3 : Introduction to Loops
Intro to Joining tables with SQL (Postgresql)
Просмотров 2756 месяцев назад
Intro to Joining tables with SQL (Postgresql)
The Ten Most Popular Functions in Excel
Просмотров 6927 месяцев назад
The Ten Most Popular Functions in Excel
Crypto ETFs? Are they worth buying?
Просмотров 2387 месяцев назад
Crypto ETFs? Are they worth buying?
How to use Every available Chart in Excel
Просмотров 1,3 тыс.8 месяцев назад
How to use Every available Chart in Excel
Learn the Three New Excel Functions : GROUPBY, PIVOTBY, PERCENTOF
Просмотров 6 тыс.9 месяцев назад
Learn the Three New Excel Functions : GROUPBY, PIVOTBY, PERCENTOF
Best New Features Coming to Excel in 2024
Просмотров 3,9 тыс.9 месяцев назад
Best New Features Coming to Excel in 2024
The short history of AI & Computing
Просмотров 41610 месяцев назад
The short history of AI & Computing
Power BI : Build a dashboard with Excel file Data
Просмотров 5 тыс.10 месяцев назад
Power BI : Build a dashboard with Excel file Data
Get the Chat GPT integration with Excel
Просмотров 2,5 тыс.10 месяцев назад
Get the Chat GPT integration with Excel
How to Password Protect Excel Files
Просмотров 50910 месяцев назад
How to Password Protect Excel Files
Beginner's Guide to VBA in Excel Part 2: Introduction to Ranges
Просмотров 74211 месяцев назад
Beginner's Guide to VBA in Excel Part 2: Introduction to Ranges
Excel - Columns to Rows & (Rows to Columns)
Просмотров 41211 месяцев назад
Excel - Columns to Rows & (Rows to Columns)
The TOP 3 filtering functions for Excel
Просмотров 50411 месяцев назад
The TOP 3 filtering functions for Excel
Balance Sheet - Learn the basics
Просмотров 298Год назад
Balance Sheet - Learn the basics
How to use multiple parameters to change cell values using =IFS() + =AND() in Excel!
Просмотров 503Год назад
How to use multiple parameters to change cell values using =IFS() =AND() in Excel!
Beginner's Guide to VBA in Excel Part 1: Set up / Parts of VBA / Recording a Macro
Просмотров 1,7 тыс.Год назад
Beginner's Guide to VBA in Excel Part 1: Set up / Parts of VBA / Recording a Macro
How to find the project competition % from start and target dates!
Просмотров 852Год назад
How to find the project competition % from start and target dates!
Create better PowerPoint Presentations with 3D models
Просмотров 256Год назад
Create better PowerPoint Presentations with 3D models
Combine two or more tables in Excel using VSTACK
Просмотров 539Год назад
Combine two or more tables in Excel using VSTACK
The FASTEST way to find unique/distinct values of columns in EXCEL
Просмотров 1,6 тыс.Год назад
The FASTEST way to find unique/distinct values of columns in EXCEL
Text Functions you need to know in Excel (Join & Split Text)
Просмотров 497Год назад
Text Functions you need to know in Excel (Join & Split Text)

Комментарии

  • @jevvandegrift3862
    @jevvandegrift3862 19 дней назад

    Switch is great, I'm glad they finally added it to excel as I've used switch or case statements in programming for decades. However, I feel like I would use a lookup function with a list for this example. I think switch is best used to replace situations where the only good solution previously was nested if statements.

  • @ravikiran2345
    @ravikiran2345 19 дней назад

    Very easy compared to IF function, thanks

  • @sonnelification
    @sonnelification 28 дней назад

    how to disable it

    • @ExcelHelps
      @ExcelHelps 28 дней назад

      Hello! You can disable the Alt key navigation by pressing the Alt key down again. Thanks for the comment!

  • @ExcelHelps
    @ExcelHelps Месяц назад

    How many credit cards do you currently own?

  • @hectorjimenez742
    @hectorjimenez742 Месяц назад

    Is there a friendlier/simpler excel/google sheets explanation video? I’m new to excel and think this can be a fun way of learning this program… (I didn’t understand the formula part of the videos)

    • @ExcelHelps
      @ExcelHelps 28 дней назад

      Hello! I do plan on making an overview to learning excel. This may not be the most beginner friendly guide since some of the concepts are more intermediate. I think a good option to start learning would be by practicing a few formulas and seeing how they interact with the various cells! Thanks for the comment! Let me know if you need any help with anything specific to your learning of excel.

    • @hectorjimenez742
      @hectorjimenez742 28 дней назад

      @@ExcelHelps Thank you! I thought learning Excel would be fun using it by organizing and analyzing something I am really into, Fantasy Football.

  • @jessebaird2289
    @jessebaird2289 Месяц назад

    Is there any way to use conditional formatting on the draft board to make certain positions color coded

    • @ExcelHelps
      @ExcelHelps Месяц назад

      Absolutely, that's a great idea! You could create lists of the players by position on a new sheet and create a conditional rule for each position list to check whether the player in the draft board is included in any of those lists. Something like a formula MATCH( {draftboardCell} , {PositionList}, 0 {exact match} ) > 0 . This would match against the position list and select the format. Doing a new condition for each list would search all positions and return the desired format. Then the format can be copied to every cell in the draft board. Let me know if you have any questions about how that set up would work. Thanks!

  • @ExcelHelps
    @ExcelHelps 2 месяца назад

    Will you be using this feature in your spreadsheets?

  • @darthrevan6861
    @darthrevan6861 2 месяца назад

    I always got this error: ERROR: invalid byte sequence for encoding "UTF8": 0xed 0x70 0x75 Even when I change the encoding to WIN1250 (which is the encoding my Excel file has) Any suggestions anyone?

    • @darthrevan6861
      @darthrevan6861 2 месяца назад

      I've realised what's the problem, i'll write it down if somebody has the same problem in the future: You have to change the encoding of the database itself as well (which is UTF8 by default), selecting the encoding only in the Import/Export panel won't be enough.

  • @KensGems8955
    @KensGems8955 2 месяца назад

    I need help making a live sheet keeping track of transaction fees for trades

    • @ExcelHelps
      @ExcelHelps 2 месяца назад

      Hello! You can email me with any specific questions regarding creating this type of sheet. excelhelps1@gmail.com - Thanks!

  • @ExcelHelps
    @ExcelHelps 2 месяца назад

    I released a new updated 'Essential Fantasy Football Spreadsheet Tips" Check it out here : ruclips.net/video/sXXXs-bTN_M/видео.html

  • @ExcelHelps
    @ExcelHelps 2 месяца назад

    Download a Copy of the Excel or Google Sheets Draft Boards here : excelhelps.github.io/ExcelHelps/ExcelDatasets.html#FT

    • @KensGems8955
      @KensGems8955 Месяц назад

      I did and the players are not coming up to pick. Soo trying to fill in the draft boards is not responding unlocked the Google sheets

  • @nishitagoel1154
    @nishitagoel1154 2 месяца назад

    Thanku so much

  • @minhtrietquach1519
    @minhtrietquach1519 2 месяца назад

    Thanks a lot!!! I'm from your "how to import an excel file into postgresql" video. This will help me with my practice a lot. Truly appreciated it. Hope you have a lovely day!

  • @sbagnell510
    @sbagnell510 3 месяца назад

    How do you import the draft board if you’re using google sheets?

    • @ExcelHelps
      @ExcelHelps 2 месяца назад

      Hello! It's not quite a straight forward answer as in Excel. The easiest way is importing into excel and then converting over to a google sheets format. Another option is taking the following steps : Upload the PDF to Google Drive. Right-click on the PDF and select Open with. Select Google Docs. Copy the table or data you want to import. Open a new Google Sheets file and paste the data into a cell and select split text by delimiter. Another option is using the IMPORTHTML function and finding a webpage with a table of data. I'm working on an updated video for fantasy football spreadsheet tips that will help. It should be out soon. Thanks!

  • @ExcelHelps
    @ExcelHelps 3 месяца назад

    I will leave an update when these functions get released out of the beta channel into standard versions of Excel! Thanks for watching!

  • @joelnelson6400
    @joelnelson6400 3 месяца назад

    what is the name of your website

    • @ExcelHelps
      @ExcelHelps 3 месяца назад

      Hey Joel, The website is excelhelps.github.io/ExcelHelps/index.html and the link to the practice datasets is excelhelps.github.io/ExcelHelps/ExcelDatasets.html . Have a great day!

  • @ExcelHelps
    @ExcelHelps 4 месяца назад

    Leave a comment if you're interested in seeing more keyboard shortcuts in Part 2!

  • @mycheaplife1900
    @mycheaplife1900 4 месяца назад

    how can i import the file with the columns my dataset have 36 columns and its tiring writing it down

    • @ExcelHelps
      @ExcelHelps 3 месяца назад

      To still import it in this way, I would recommend using Excel to format the column names and data types in a separate file to copy them into the Query! Thanks for the comment!

  • @JoviSatriaadam
    @JoviSatriaadam 5 месяцев назад

    thanks for the knowledge

  • @shubhamkumarseth9001
    @shubhamkumarseth9001 5 месяцев назад

    How can i get ur Excel data sheet?

    • @ExcelHelps
      @ExcelHelps 3 месяца назад

      Hello! It is available for download on my website! excelhelps.github.io/ExcelHelps/ExcelDatasets.html

  • @M78ST
    @M78ST 5 месяцев назад

    Learnt more of use from this than in about 3 hours of a Udemy 'course'!! Excellent and thanks!!

  • @ExcelExplorers786
    @ExcelExplorers786 5 месяцев назад

    Your work is genuinely exceptional! Would you be willing to offer feedback?🙂🙏

    • @ExcelHelps
      @ExcelHelps 3 месяца назад

      Your doing great! Keep it up!

  • @ExcelHelps
    @ExcelHelps 5 месяцев назад

    Thanks for watching! Have a great day!

  • @parthshete772
    @parthshete772 6 месяцев назад

    Thanks

  • @jsanders775
    @jsanders775 6 месяцев назад

    Movies does not show up on my data types in excel

    • @ExcelHelps
      @ExcelHelps 6 месяцев назад

      It looks like they ended the support of Excel Data Types with Wolfram. This included the different data type drop down within excel. It's a shame and hopefully Microsoft will work on bringing new data types in! Here's a link of the article support.microsoft.com/en-us/office/excel-data-types-with-wolfram-end-of-support-faq-9ac0876c-b8cb-4c8e-bed6-207d0d675bfe

  • @PeterBornAgain
    @PeterBornAgain 7 месяцев назад

    I won 250K in 2022 I also lost it plus more thats the nature of gambling.

  • @TheFlairRick
    @TheFlairRick 7 месяцев назад

    what about state lotteries (both number games and scratchers)?

    • @ExcelHelps
      @ExcelHelps 6 месяцев назад

      Hello! Scratcher and number games typically have the odds available on the back of the game (scratchers) or if you look the number game up on google it should typically take you to a state/company website outlining the odds of winning. Thanks for the comment!

  • @TheFlairRick
    @TheFlairRick 7 месяцев назад

    If a certain state were to outlaw gambling, the right would scream "communism", etc.... but there's a piece of me that thinks of the whole "cost/benefit analysis" idea and it could make it better. I'm not saying this is the greatest idea, obviously, but for those that don't want to risk their own futures getting caught with illegal gambling and being prosecuted for engaging in it, I think it could be a benefit. I'm not the biggest fan by any means of anything that takes freedom away, etc..., but look at seat belt laws. Many lives have been saved. Well, gambling being outlawed would cause many financial lives to be saved. I'm torn with the idea to begin with. If my state and several surrounding states were to outlaw gambling, that would make it so anyone willing to really be serious in gambling be forced to travel several states to gamble, and then in that process re-consider.

  • @johnobrien8398
    @johnobrien8398 7 месяцев назад

    Casinos are the shittiest place you could ever spend an hour of your life you will just lose anything you have it’s a hell hole

  • @zerobits4763
    @zerobits4763 7 месяцев назад

    2:10 on BJ with card counting and perfect basic strategy and its deviations, on BJ pays 3:2, dealer hitting on 16, standing on soft 17 and no automatic shuffler you can turn the edge on your favor by around 1.5%

  • @lonniemaye-r4t
    @lonniemaye-r4t 7 месяцев назад

    We are thinking we can just abruptly win randomly at any point in time. The casino determines if they will let you will win or not. A big regular gamer that spend alot of their $$$ is a casino favorite and give them more wins over an average poorer gamer. The casino for example this morning. I had a free $30 bet just to prevent me from winning they will make the shooter lose betting 100's just to get me out of the game realizing that is all I have that $30 free bet coupon. Dude shot a #9 and the next roll they bought that #7 wiping us all out but I had no more so their doing things like that FEARING I will win and go to the $5 Computer crap table and win really not wanting to monitor me closely and I end up winning $150 from $30 and they are not trying to hear that in 2024! So it's easier to take me out the game ASAP causing me to lose that 1 bet! Causing the other players to lose at the very same time but they will keep going on betting till they lose their lil $$ we all walking out with no money!!

    • @HecMan-kp8jm
      @HecMan-kp8jm 7 месяцев назад

      That was painful just to try comprehend what you are trying to say. No sintax man

    • @lonniemaye-r4t
      @lonniemaye-r4t 7 месяцев назад

      The casino DECIDE who they will LET WIN each BET whether it's a FREE BET, or you bring your own money, or play for someone else with their money. it's no luck, or it's not random it's their CHOICE and most of the time they allow you to lose!! You think you or him or her is a skilled DICE SHOOTER the casino let you think that but THEY ARE NOT. Cause soon as the casino turn that eletro magnetic computer linked system on it controls the outcome of the roll how they land which #'s will come up making you lose over and over!! When it's off folk are able to control the dice appearing as Mike Jordan playing basket ball in his prime as a good dice shooters making alot of points during them temp turning it off making folk think they really control the outcome to spend more of their $$$. But they keep it on most of the time draining everyone preventing wins making the dice go all around the #'s you chose to bet on and after 5 more rolls of not winning anything seeing those other same #'s coming you then BET on them and the next roll a #7 comes wiping 10 people out all at once! it's easy to tell when they turn that eletromagnetic computer linked system on the so called best shooters in the house end up looking like a bad loser!!! going right out over and over not able to get 1 or 2 points for the fire bet regardless how they try to set the dice the computer won't let their numbers come up being countered blocked like a hockey goalie, or soccer goalie ! you can't win being drained being cheated by the casinos using technology for their benefit

  • @lonniemaye-r4t
    @lonniemaye-r4t 7 месяцев назад

    Gambling at Casino's and lotteries has always been RIGGED don't matter how you look at it!!! A battle of crookes trying to out smart the other side TAKING THE MONEY by manipulation, deception and cheating. These day's TECHNOLOGY has given Casino owners and lottery businesses a HUGE EDGE over the game player. They determine the outcome in advance like in Slots, roulette, Cards, CRAPS, SICBO turning them all into ELECTRONIC COMPUTER LINKED SYSTEMS able to manipulate the outcome able to CONTROL the roulette spins, card delivery, able to control the DICE to COUNTER the numbers you bet on going all around them and then force you to BET more and soon as you do BAM they bring the #7 like clock work causing 10 people at one time to lose like $70 to $100 that roll session. (smaller level gamblers $5 to $10 bets). So the cycle repeat, pattern repeat after 8 times we lost $800 min for that 1 visit. The repeating cycle and patterns are the yellow Banana on the table WE SEE!! Telling the Casino and gaming commission that Banana is rotten and is causing us to get sick; lose over and over it's CHEATING US. Instead of them replacing that rotten Banana on the Table putting a ripe yellow banana to FIX the people from getting sick. AFTER OUR COMPLAINT. They tell us your not looking at a Banana but a green Watermellon on the table. Your just tired, your just having a bad day. But that is a Watermellon you see right there not a banana TRUST US it's nothing RIGGED, no Wifi, no bionic, no electromagnetic. We are not manipulating the DICE in anyway, there is no pattern or cycle you are seeing it's just the green watermellon on the table. Verbally speaking is the furthest they go and leaving it on that note you just having a bad day, While i'm ASKING THEM to go to the CRAPS TABLE by my side so I can PROVE to them that I see a banana and they see the same banana too, same as her or him right there. But THEY REFUSE!!! They are not trying to prove to me that they see a watermellon in any way expecting me to just ACCEPT I am crazy calling a banana a watermellon and NOTHING IS BEING done to fix, change or prove anything that it isn't rigged. They won't allow me to prove it's a banana sitting on that table, they won't prove it's a watermellon as they say it is. your just having a bad day. How am I having a bad day the last 50 visits since Dec 2021 at your casino not winning 50 visits in a row seeing that banana over and over same outcome being drained losing over and over. They turned up the electro magnet level up to a level 5 or 6 from a level 2 or 3 before Dec 2021 was able to win from time to time can't even complain back then but AFTER Dec 2021 ME, and THOUSANDS of regulars at their CRAP TABLES lost over and over to this very day 2024! All someone has to do is CHECK the winning frequency at this casino before Dec 2021 and watch how drastically it dropped the last 3 years overrall after them changing their TABLES Dec 2021 with stronger TECH to manipulate getting the outcome they wanted. These State and fed leaders,Casino owners, gaming commisioners sat down and decided the new wave, form of Gambling forcing it on consumers to accept this way going forth!!! Having no regards, cares about our outcome which is we all losing frequently over and over there. They removed the FUN, the surprise element of winning knowing you will lose to them in advance because they are controlling the dice and countering the numbers we bet each and every roll deciding if they will allow you to win or NOT!! And most o the time if you are not FRESH MEAT you will be drained by this casino determining your ending outcome placing limits on us on what they will allow us to win. So if I come with $500 they will drain it down to like $75 FAST controlling the DICE mainly by waiting till you bet multiple numbers at once across the board and BAM bring the #7 wiping us out within those cycles and patterns. You have $75 left this casino will then let you go back and forth SEESAWING from $5 to that $75 for HOURS never letting you get beyond that $75 so they pretty much is giving you the opportunity to take that $75 and RUN!!! But we don't thinking we can REACH that $500 to $1800 range seesawing over and over but then after 4 or 5 times of going back and forth and you chose to stay then they WIPE YOU OUT fully!! Dec 2021 I used to can take one of their FREE BETS of $50 and turn it into like $450 to $1,000. But NOW the casino places limits on us with free bets, the $$$ we bring to bet; you can double that free bet but can't go any higher this is where the DICE control comes in for 8 hours they kept me from getting over $30 from a $15 free bet. Going back and forth from $5 to $25, back down to $8 go back up to $20 doing this for 8 hours how is that even possible if the dice is free falling and random no magnets, no computer, no manipulation at all they SAY!!! While I'm seeing them countering my numbers over and over going around them. When I bet like #4, #5,#6#8, and #10 leaving the #9 unbetted the very next roll that #9 I didn't bet comes like clock work regardless if you left the #5 out instead of the #9 that #5 will come I seen this like 30 times over and over in a visit. Trying to understand how is this keep happening over and over but I finally realized a computer program is going to do what it's programmed to do until it's turned off! These people are ROBBING THE FUCK out of us!!! Acting if everything is fair and balanced no cheating on their part. Taking our $$$ away from us making us think we have a chance to win a big prize randomly, unexpectedly when it's all pre determined by the first 10 mins they will let you win on a slot machine do you think after driving from 40 mins your going to just leave after winning $150 you going to end up staying and end up losing that $150 and more of your $$$$ getting you hooked thinking you can win something and now they gotta ya SUCKER!!! Give me your MONEY!!! This is a stick up!!! So these day's GAMBLING is you knowing you are dealing with a corrupt system your STUPID enough to just hand over your $$$$ to the Casino and lottery. You don't have to come here!!! But the SEESAWING going back and forth causes us to think we can still win but the seesawing is only when you down to your last. Long as you come out your pockets, and go to the ATM it's no seesawing back and forth your losing non stop till you reach your last amounts and accesses. To stop this madness, it's no addiction you are being TRICKED and manipulated into thinking you can win a big prize over and over randomly. Tell yourself you are a STUPID FUCK for giving your $$$ to a RIGGED OPERATION and that you will not keep being STUPID in messing your life up getting in debt, behind on bills, can't do the things you need to do with your $$$. Your not fresh meat anymore, so they are draining you dry causing you to mess your lively -hood up. Being hostage to their deception and tricks dictating your life selling you a dream!!! Tell yourself your not STUPID and is wise and smart and deserve better by leaving those casinos, lottery alone. let them keep draining the foolish, stupid folk but no longer YOU!!! You woke up now

    • @lonniemaye-r4t
      @lonniemaye-r4t 7 месяцев назад

      yesterday I got a good roll on computer craps for the 1st time in MONTHS I guess after complaining recently of always losing they turned the electro magnetss off!!! I reached the 5th FIRE BET point trying to get a#10 as that 5th point having a number #9 left to win $5k. The pit boss didn't say a word the first 4 numbers was over on the other side but while i'm trying to get the #10 my fifth number he comes start trying to talk to me and standing right up on my NECK behind me!!! I could feel his breath on my neck standing over me and sure nuff very next roll I threw a #7 he did that intentionally and I think they should be checked for that!!! Most likely they turned the electromagnets back on also They all are crookes doing anything to prevent a decent win.

  • @SieanElpidama
    @SieanElpidama 7 месяцев назад

    whats the difference with ssms and postgresql also is it needed to be a CSV when you import it to postgres?

    • @ExcelHelps
      @ExcelHelps 6 месяцев назад

      Hello! SSMS is similar to Postgresql or pgAdmin which is the database management system for Postgresql. And the data does typically need to be a CSV/text or binary for importing into the database. Thanks for the comment!

  • @Cruen_Media
    @Cruen_Media 7 месяцев назад

    Hey! What can I do when I got accents in names in the csv's?

    • @ExcelHelps
      @ExcelHelps 7 месяцев назад

      Hey Christopher! VARCHAR allows different types of characters to be used.

  • @NetSOEUNG
    @NetSOEUNG 7 месяцев назад

    sorry, how to have these function in excel ? can you guide me?

    • @ExcelHelps
      @ExcelHelps 7 месяцев назад

      Hello! They are currently only available in the Beta version of Excel! You will need to sign up to be a Microsoft insider for access to the beta channels!

  • @ExcelHelps
    @ExcelHelps 8 месяцев назад

    Are you planning on buying any Crypto ETFs?

  • @AlcaponeDota
    @AlcaponeDota 8 месяцев назад

    Hello, thanks for video 😊, I have an commas on my voters table like 38,333 . And i tried to import it but it doesn't worked. It's giving syntax error and i have description table which has more words and this one also giving error. Can you help me please, how should i create these column properly ?

    • @ExcelHelps
      @ExcelHelps 6 месяцев назад

      Hello! Saving the file as a Text(tab delimited file) can help with avoiding the unwanted comma separation. And for the description you can create a varchar() data type with more characters allowed such as varchar(150) or varchar(200). Thanks for the comment!

    • @AlcaponeDota
      @AlcaponeDota 6 месяцев назад

      @@ExcelHelps Thanks !

  • @christosmylonas
    @christosmylonas 8 месяцев назад

    You should have mentioned that this is not available.

    • @ExcelHelps
      @ExcelHelps 8 месяцев назад

      They are only available in the Beta testing versions of Excel! Sorry for the confusion! I'll make a video when they are released on all versions of Excel!

  • @muhammadazhariqbal2647
    @muhammadazhariqbal2647 8 месяцев назад

    Improve video quality

  • @ExcelHelps
    @ExcelHelps 8 месяцев назад

    Level up your Visualizations in Excel! Comment any content you're interested in seeing! Thanks for watching!

  • @Polaynka_Bolgarka
    @Polaynka_Bolgarka 8 месяцев назад

    The simple and clearly. Thank you

  • @joukenienhuis6888
    @joukenienhuis6888 8 месяцев назад

    Great functions and they kinda replace the pivot function, which you have to update each time when something changes. My question is when are they going to apply this new function in the official version? Nice to use for yourself, but I think hard to pass on to someone with no beta functions

    • @ExcelHelps
      @ExcelHelps 8 месяцев назад

      Agreed! It's unfortunate that they can't be used unless someone is enrolled in the insider program. My hope is to at least give a solid preview before release, and give an update when the function is available on all Versions. And for release date, it depends on how well the Beta Tests go. I would think they can at least roll it out by end of year. But that may be hopeful thinking for such a large company haha

  • @birasafabrice
    @birasafabrice 8 месяцев назад

    which version of excel are you using?

    • @ExcelHelps
      @ExcelHelps 8 месяцев назад

      Hello! I currently have Version 2402. I am signed up for the Microsoft 365 Insider Program which allows running the Beta Channel for early access to new Excel features.

  • @abhishekshishodia7767
    @abhishekshishodia7767 9 месяцев назад

    can you help me with this type of error : missing values in particular column type???

    • @ExcelHelps
      @ExcelHelps 9 месяцев назад

      I believe this would happen if a JOIN can't find matching values in the tables, or if a column has NULL values. Maybe try to do something like [ UPDATE table_name SET column_name = 'some value' WHERE column_name IS NULL; ] and retry executing the query. Let me know how you go about fixing the error! Thanks for the comment!

    • @ExcelHelps
      @ExcelHelps 9 месяцев назад

      If is from a JOIN then it could be that the JOIN is not compatible with the two Tables/Columns selected.

    • @abhishekshishodia7767
      @abhishekshishodia7767 9 месяцев назад

      @@ExcelHelps well idk but still face the issue? can you please tell me whats wrong and how to correct it in this dataset : drive.google.com/file/d/1sn_kc312omvWv2_QBMaWmYV0ulRMJCdA/view?usp=sharing

  • @abhishekshishodia7767
    @abhishekshishodia7767 9 месяцев назад

    thanks buddy! keep it up

  • @olukoniseun
    @olukoniseun 9 месяцев назад

    This was exactly what I needed thanks!!!

  • @arifuzzamansumon6865
    @arifuzzamansumon6865 9 месяцев назад

    Please provide practice file.

    • @ExcelHelps
      @ExcelHelps 9 месяцев назад

      I've added a link in the description to download a copy of the file. Have a great day!

  • @ubaidillahmuhammad20
    @ubaidillahmuhammad20 9 месяцев назад

    Amazing job. Please put excel file in the description video

    • @ExcelHelps
      @ExcelHelps 9 месяцев назад

      I've added a link in the description to download a copy of the file. Thanks for the comment!

  • @ExcelHelps
    @ExcelHelps 9 месяцев назад

    Thanks for watching! Have a great day!