New: hive-102332All contenthive-129948hive-196917krzzanhive-183959steemhive-180932hive-166405photographyhive-185836uncommonlabhive-150122hive-183397hive-144064bitcoinlifehive-188619krsuccesshive-124908hive-139150hive-101145hive-103599hive-184714hive-145157hive-109690TrendingNewHotLikersemrefurkanozshn (29)in hive-102332 • 3 years agoHow to Conduct Simple Regression Analysis on ExcelHi everyone, As I am a finance major, I had to learn how to conduct a regression analysis on Excel during my undergraduate studies, and I would like to explain how you can perform this simple…analise (39)in hive-102332 • 4 years agoVBA in ExcelI can write a macro for Excel for you. Сontact me - [email protected] Sub Macro() MsgBox "Hello, world!" End Subdernan (47)in hive-102332 • 4 years ago[QUESTION- HELP NEEDED] I can't set a date as the column header in a table? Hello - I am working on a table of data in an Excel spreadsheet, I am having some difficulty with the table headers as I am not able to set these as formulas or dates. Once I convert the data into…analise (39)in hive-102332 • 5 years agoГде писать макросы в ExcelХотите научиться писать макросы? Тогда подписывайтесь на мой канал и смотрите бесплатный курс! Сегодня в видео о том как найти макросы в книге Excel, открыть редактор кода VBAtheexcelclub (66)in hive-102332 • 5 years ago9 Tips for PowerBI UsersA big Hello to everyone at the Excel Club! I am thrilled and honored to share my learning from the Power BI world with you folks. In this post, I am going to share 9 awesome tips on DAX and Power…theexcelclub (66)in hive-102332 • 5 years agoWhy and how to Keep Dimensions & Facts tables separate - DAX modelingBefore you learn why and how to Keep Dimensions & Facts tables separate in a Power Pivot or Power BI model, it is important you understand the difference between Facts and Dimension tables. Facts…cmplxty (62)in hive-102332 • 5 years agoExcel fun: Charts!Hi fellow Steemians and Excel enthusiasts, Today I'm posting about some more Excel fun I've been having. It's been a few months since I've got to explore different aspects of Excel but I am…theexcelclub (66)in hive-102332 • 5 years agoThe Excel Club NewsletterWe have 3 videos for you this week covering different aspects and skill levels of Excel, Power Query, and DAX. One of which is the solution to last week's learn and earn activity. I hope you enjoy…theexcelclub (66)in hive-102332 • 5 years agoExcel - 3 videos and a blog you cant missWe have 3 videos and a blog for you this week covering different aspects and skill levels of Excel, Power Query, and DAX. You will also find our first DAX learn and earn activity I hope you enjoy…theexcelclub (66)in hive-102332 • 5 years agoDAX AND OR IN or syntax(&& ||) – Which one?AND, OR and IN are common statements used in DAX to create conditional logical tests. Most DAX functions work the same as their counterpart in Excel, however AND and OR work a little different in…theexcelclub (66)in hive-102332 • 5 years agoPaste Special in ExcelPaste in Excel is one of the most commonly used functions. You do it, I do it, everyone using excel will paste something during the day. But did you know that Excel has a paste special option? An…theexcelclub (66)in hive-102332 • 5 years ago6 DAX tips for Excel and Power BI usersDAX is quickly growing in popularity. Advanced Excel skills have moved beyond single table analysis with static data, to complex data modeling and analysis across multiple tables of data with live…paulag (73)in hive-102332 • 5 years agoSent some tips to Excel for All Beta TestersThis is just a quick post to let you all know I have distributed some tips to the wallets of those that helped with the first round of beta testing Excel for All. A big shout out and special…theexcelclub (66)in hive-102332 • 5 years agoFine Tune your Workbook with Print Options in ExcelThere is nothing worse than receiving an Excel workbook that looks the part, but then when you print it, tables and charts are split into different pages. Do people know there are print options…xlncad (46)in hive-102332 • 5 years ago4 Methods to create a Unique list of records in Excel4 different methods to create a Unique list of records in Excel are explained below. Pivot Table Array Formula Remove Duplicates Advanced Filter To create a unique list of…diazkongming (43)in hive-102332 • 5 years agoDiscussion: Modelling is for HumansHi everyone, this is my first beta test post. I thought I'd share a link to a video of a talk I did recently called: Modelling is for Humans. It covers all the aspects of the life of a professional…gikitiki (60)in hive-102332 • 5 years agoExcel VBA - Variables : StringsIf you think about almost everything you do in Excel, it involves some form of manipulating numbers or text. The same is true with VBA. In this post, I want to show you some simple manipulations…theexcelclub (66)in hive-102332 • 5 years agoDynamic Positioning of Totals using Dynamic ArraysIn the video above you learned how to create Dynamic Positioning of Totals using Dynamic arrays using Excels SEQUENCE function and some logic. This is an awesome trick that will give any…estherbennett (44)in hive-102332 • 5 years agoNew PostHello @paulag, i think I have managed to create a post :D. I have been outside Excel for All and I have found my way back, by selecting this community in the list. Now I will return back to your…jkpieterse (46)in hive-102332 • 5 years agoNew kid on the blockHi everyone, Introducing : Me! I'm Jan Karel Pieterse, Excel expert for over 20 years now. I share downloads and Excel articles on Some of you may have run into me on-line already :-)