Global Excel Summit的动态

Across social media, you've probably seen that neat-looking text staircase layout that people use in their posts. Although this can be achieved manually, it's easier to use a web-based generator like the one shown in the video (see first comment for link). There are four variations: 'Short to long', 'Long to short', 'Pyramid', and 'Chevron'. Can these be replicated in Excel? Absolutely. In the example, 20 country names are housed in A2:A21, and this reference is used in each style's formula. ?????????? ???? ???????? =SORTBY(A2:A21,LEN(A2:A21)) LEN obtains the character length for each country so SORTBY can return the countries in ascending order. ???????? ???? ?????????? =SORTBY(A2:A21,LEN(A2:A21),-1) The same formula as 'Short to long' is used, except -1 is included in [sort_order1] to sort in descending order. ?????????????? =SORTBY( SORTBY(A2:A21,LEN(A2:A21),-1), -2^SEQUENCE(COUNTA(A2:A21)) ) The 'Long to short' formula is wrapped inside SORTBY to combine two sorting stages. This is then sorted by an array of numbers that alternate between exponentially decreasing negative ones and exponentially increasing positive ones: {-2;4;-8;16;-32;64;-128;256;-512;1024;-2048;4096;-8192;16384;-32768;65536;-131072;262144;-524288;1048576} The end result is the longer values are placed in the middle and the shorter ones at the ends. ?????????????? =SORTBY( SORTBY(A2:A21,LEN(A2:A21)), -2^SEQUENCE(COUNTA(A2:A21)) ) The only difference with this formula compared to 'Pyramid' is the removal of -1 in the nested SORTBY function. Ascending order is necessary for the shorter values to be in the middle and the longer ones at the ends. ?--- By Andrew Moss #exceleration #excel #globalexcelsummit

Webinar recording: Be Understood: Data Visualization For Marketers @serpstat #seotools #seotips #Marketing #digitalmarketing #socialmediamarketing #marketingtips #contentmarketing #OrganicTraffic #InfluencerMarketing #seo #seomarketing #seoservices #seoproblems #seoexpert #seoagency #seoconsultant #seostrategy #seobaby #seocompany

Our redesigned website is finally out! Besides learning more about Valiotti’s services and results, don’t miss out on a chance to unlock some valuable data analytics insights in our Blog. Check it out and let me know what you think! valiotti.com

Previously, we talked about how to optimize the meta data of your pages in Optimizing Pages for Building Designers, Part 1: Meta Data. Today, we're talking about how to #optimize the page content: https://lnkd.in/ehSarDK

3 basic custom columns I like & I think you will too! ???????????????? ?????????????? ?????????????????????? Perfect to quickly glance at to see if you're on track to hit your conversion goals for the month: Conversions_by_conv_time.between_dates(month_start, yesterday) + (Conversions_by_conv_time.date_range(last_7_days) / 7) * (day(offset_days(offset_months(month_start(), 1), -1)) - day(today())) ???????????????? ?????????????? ?????????? Pacing your spend properly can be time consuming, this custom column lets you see again, at a glance what you're expected to spend for the month: Cost.between_dates(month_start, yesterday) + (Cost.date_range(last_7_days) / 7) * (day(offset_days(offset_months(month_start(), 1), -1)) - day(today())) ?????????????? ?????????? ??????????: Check to see if you're utilising your full daily budget on average over a period of time: Cost.between_dates(report_range_start, report_range_end) / report_days_count() These are just 3 of loads of custom columns you can implement, so I'll give a shout out to Denie Geertzen ??, Arjan Schoorl & Miles McNair for compiling a list of over 75 custom columns that you can find here: https://columnlibrary.com/ ???????? ???????????? ?????????????? ?????????? ?????? ??????????????????? ??

#Day 20 of 28 Eye-Opening Website Statistics: Is Your Website costing You Clients? Follow us for daily insights: https://lnkd.in/gGjw86xJ #skyfishdev #InternetUsers #Population #world #tools #websitedesign #websitedevelopment #uidesign #uxdesign #statistics #ClientSuccess

Marketers! Are you in that end-of-month–crunch-mode writing client reports? We know it needs to be done, but lets face it, it’s no-one’s favourite part of the job. If you spend the end of the month getting bogged down extracting data from channels like Meta and copying it over into client reports then let’s chat about how Papermill can make life easy for you, saving you time whilst delivering fast accurate reports to your clients. #Marketing #Reporting #PerformanceMarketing

Ever noticed those search results with star ratings, prices, and eye-catching images? That's the magic of rich snippets! These visually enhanced listings make your products stand out and entice shoppers to click. ? The Rich Snippet Advantage ? ● Boost Visibility: Stand out in search results and grab attention. ● Build Trust: Showcase ratings and reviews to build credibility. ● Inform & Convert: Give shoppers key details like price and availability for faster decisions. ? Product-Specific Rich Snippets ??? ● Product: Basic details like name, description, image, price, and brand. ● Offer: Highlight special deals and discounts. ● Review: Display customer ratings and reviews. ● AggregateRating: Showcase your average product rating. ? Implementing Rich Snippets: Easy Does It! No coding is needed! Use schema markup (special code) to "label" your product data. Tools and plugins simplify the process. ? Share Your Rich Snippet Wins! ??? Have you used rich snippets? What results did you see? Share your experiences below! ?? #RichSnippets #EcommerceSEO #SchemaMarkup #ProductSchema

Shout out to Dominic Legg from Motion By Design and his really insightful short course that I recently completed. Jam-packed full of sage and practical advice including a host of downloadable templates that have already streamlined a number of my processes. Highly recommended! #creative #smallbusiness #strategy #research #advertising #data #businessimprovement #processimprovement #agency

?? ?????????????? ?????????????? ???????????????????????? ??????????????????! This time, I worked on ???????????? ???????? tracking with both ????????????-???????? and ????????????-???????? tracking, plus event ??????????????????????????. The biggest challenge? My client wanted an ?????????? ?????????? ?????????????? ?????????? ?????????? ??! ?? ?? ????????’?? ???????? ?? ?????? ?????? ???????? ??????????????: ? Connected ???????????? ?????? ?????????????? with: ? The iframe form ? The website ? Scraped form field information like: ? First name ? Last name ? Email ? Phone, etc. ...using custom ???????????????????? ???????? to store everything in ????????????????????????. ? Set up server-side tracking using a Stape server. ? Configured ???????? events for: ? Meta Pixel ? GA4 (Google Analytics 4) ...with event ?????????????????????????? to ensure accuracy. ?? ?????????? ????????????: The Event Match Quality score hit ??.??! ?? I’m happy, and most importantly, my client is happy. ?????????? ???????????? = ?????????? ????! ?? ?? What do you think about my work? I’d love to hear your thoughts! ????