Podcasts about pivot tables

Join Roger Knecht and Microsoft MVP Jeff Lenning in this dynamic episode of Building the Premier Accounting Firm, where they delve into Excel mastery for accounting professionals.

In this episode, Sarah is sharing her favorite tool for quickly and easily transforming your basic data into actionable business intelligence - Pivot Tables.  From helping you recognize sales patterns and trends, to identifying issues and opportunities, and seeing your customer and sales channel profitability, pivot tables are truly a secret weapon for improving your business profitability and cashflow!   Tune into this episode to explore all of the valuable insights that pivot tables can provide and hear real world examples of how pivot tables helped Sarah's clients.  Learn more about our News Story: FI Spotlight: ReInventing a CPG Brand Join The Good Food CFO Community: Follow us on Instagram: @thegoodfoodcfo Connect on LinkedIn: @sarahdelevan Watch on YouTube: @thegoodfoodcfo Become a Member: BABOYOT

Kilowatt: EV Data Made Fun with Allison Sheridan PBS 173 of X: Getting Started with Submodules (Git) Take My Money! How to Sign Documents on macOS and iOS Without Saving Any Files Support the Show Security Bits — 24 November 2024 Transcript of NC_2024_11_24 Join the Conversation: allison@podfeet.com podfeet.com/slack Support the Show: Patreon Donation Apple Pay or Credit Card one-time donation PayPal one-time donation Podfeet Podcasts Mugs at Zazzle Podfeet 15-Year Anniversary Shirts Referral Links: Parallels Toolbox - 3 months free for you and me Learn through MacSparky Field Guides - 15% off for you and me Backblaze - One free month for me and you Setapp - One free month for me and you Eufy - $40 for me if you spend $200. Sadly nothing in it for you. PIA VPN - One month added to Paid Accounts for both of us CleanShot X - Earns me $25%, sorry nothing in it for you but my gratitude

#airtable #on2air #builtonair 10/22/2024 - BuiltOnAir Live Podcast Full Show - S20-E03 ___________________________ The BuiltOnAir podcast is a live weekly show highlighting everything happening in the Airtable universe. Check us out at BuiltOnAir.com/join. Join our community, join our Slack channel, and see what's happening. ------------------------ SPONSORED BY On2Air - Airtable Apps and Integrations to run your business operations in Airtable Start a free 14-day trial of On2Air Apps - https://on2air.com?via=podcast ------------------------ ___________________________ IN THIS EPISODE

#airtable #on2air #builtonair 10/22/2024 - BuiltOnAir Live Podcast Full Show - S20-E03 ___________________________ The BuiltOnAir podcast is a live weekly show highlighting everything happening in the Airtable universe. Check us out at BuiltOnAir.com/join. Join our community, join our Slack channel, and see what's happening. ------------------------ SPONSORED BY On2Air - Airtable Apps and Integrations to run your business operations in Airtable Start a free 14-day trial of On2Air Apps - https://on2air.com?via=podcast ------------------------ ___________________________ IN THIS EPISODE

Hector and Alicia explore the extensive capabilities of QuickBooks Online Advanced's modern reports and custom report builder. They walk through key features including dynamic column customization, Boolean filters, multi-level grouping, pivot tables, and interactive charts - demonstrating how these tools can transform raw data into actionable insights. The hosts share practical tips for leveraging related table data, creating KPI widgets, and maximizing the flexibility of the new reporting system, while also discussing how these features compare to classic QuickBooks reports.SponsorsZoho Expense - https://uqb.promo/zohoexpenseIgnition - https://uqb.promo/ignitionCoefficient - https://uqb.promo/coefficientSend your Questions/Comments (we could read/answer them on air) ask@uqapodcast.comLinks/Apps Mentioned in this episode:Enroll for Alicia's Nov-Dec QBO Complete Hands-On Training (HOT) at https://royalwise.lpages.co/qbo-complete/Intuit's 2024 Investor Day event: https://www.youtube.com/embed/8cJ9vqr6gYg?si=C3UD7Hsxu2QMtx4rHector's App - RightTool www.righttool.appAlicia's 1099 class: http://royl.ws/QBO1099Alicia's RoyalWise OWLS QBO Training - http://royl.ws/uqapodcastIntuit Connect Conference www.quickbooksconnect.comCheck out Alicia's step-by-step QBO Textbooks at http://www.questivaconsultants.comThe Comprehensive Guide to Converting from QuickBooks® Desktop (QBDT®) to QuickBooks® Online (QBO®) https://www.amazon.com/dp/B0D8L29Z5LQuickBooks Online: From Setup to Tax Time https://www.amazon.com/dp/B0CXZB1R95Sign up to Earmark to earn free CPE for listening to this podcasthttps://www.earmark.app/onboarding (00:00) - Welcome to the Unofficial QuickBooks Accountants Podcast (02:19) - Exploring Custom Report Builder Templates (05:22) - Visualizing Reports with Chart View (10:22) - Advanced Filtering and Boolean Logic (18:21) - Grouping and Subgrouping Data (22:20) - Leveraging More Columns for Detailed Insights (28:21) - Pivot Tables and Summary Reports (30:01) - Benefits of Pivot Tables (34:33) - General Options and Formatting (41:37) - Exporting and Sharing Reports (45:19) - Upcoming Classes and Events (48:05) - Conclusion and Final Thoughts

“I love Excel. It's helped me save so much time over the years, and when I began thinking about Excel more like an employee that I can delegate stuff to, it helped me save an incredible amount of time.” – Jeff LenningThe finer details of this episode:• Strategies for leveraging Excel to improve efficiency• Continuous learning and development in Excel• Common pitfalls and challenges in Excel usage• Mindset shift from "if" to "how" in using Excel• Role of AI in enhancing Excel skills• Structure and offerings of Excel University• Key Excel functions and features for accountants• Real-world applications and case studies using Excel• Importance of presentation skills in Excel reportingEpisode resources:● Summit Virtual CFO by Anders website: https://www.summitcpa.net/● If you have questions or would like to be a guest on the show, email us at mcpasuccessshow@anderscpa.com● Check out the Virtual CFO Playbook Course: https://vcfoplaybook.summitcpa.net/● Connect with Jeff here: https://www.linkedin.com/in/jefflenning/● Check out Excel University here: https://www.excel-university.com/tipsTimestamps:Introduction to the Episode (00:00:00)Overview of the podcast's mission to provide insights on innovative tools and strategies in accounting.Guest Introduction (00:00:22)Tom introduces Jeff, a Microsoft MVP and founder of Excel University, highlighting his career background.Why Excel University? (00:01:18)Jeff explains his passion for Excel and how it transformed his workflow efficiency.Continuous Improvement in Excel (00:02:27)Discussion on the iterative process of optimizing Excel workbooks for efficiency and accuracy.The "Last Year" Trap (00:04:06)Jeff addresses how accountants often stick to familiar methods without seeking improvements.Mindset Shift in Excel Usage (00:05:53)Jeff shares his approach of asking "how" instead of "if" when automating tasks in Excel.Learning with AI Tools (00:07:00)Jeff discusses the benefits of using AI to enhance Excel skills and troubleshoot formulas.Excel University Experience (00:09:02)Overview of the structured learning approach at Excel University, focusing on sequential knowledge building.Continuing Education Credits (00:11:44)Information on CPE credits offered through Excel University's programs.Focus on Presentation Skills (00:12:11)Discussion on improving both functionality and presentation of Excel reports for better client communication.Charting in Excel (00:14:16)Tom and Jeff discuss the challenges of formatting charts in Excel for effective presentations.Key Excel Functions for Accountants (00:15:25)Jeff highlights essential Excel functions that every accountant should master.Power Query's Benefits (00:16:59)Jeff explains how Power Query automates data processing, saving time and improving efficiency.Real-Time Data Refresh (00:18:07)Benefits of using Excel for live updates during client meetings, enhancing responsiveness.The Impact of Spreadsheets (00:19:01)Discussion on the historical significance of spreadsheets in making personal computers indispensable.Microsoft's Ongoing Investment in Excel (00:19:51)Discussion on Microsoft's continuous updates and new features in Excel.Learning Excel Functions (00:20:17)Importance of learning new Excel functions beyond the basics through courses and online resources.YouTube Channel Promotion (00:20:38)Jeff shares his YouTube channel for quick Excel tips and updates.Searching for Excel Functions (00:21:06)Common issue of not knowing advanced functions like Power Query and XLOOKUP.Benefits of XLOOKUP (00:22:00)Explanation of XLOOKUP as a more resilient alternative to VLOOKUP.Excel University Audience (00:22:28)Overview of diverse student demographics, including CPAs and accounting professors.Student Confidence Boost (00:23:49)Feedback on how Excel training increases students' confidence in interviews.Underestimating Excel's Importance (00:24:33)Discussion on college students' misconceptions about Excel's relevance in their careers.Using Excel for Client Projects (00:25:35)Example of using Excel to model client scenarios and decision-making.Introverts and Problem Solving (00:25:48)Jeff shares his enjoyment of solving problems with Excel as an introvert.Google Sheets vs. Excel (00:26:27)Comparison of Google Sheets and Excel for collaborative work.Sharing Documents in Google Sheets (00:27:39)Discussion on the ease of sharing documents in Google Sheets compared to Excel.Gateway Computers Experience (00:28:25)Jeff reminisces about working at Gateway Computers and its rapid growth.Gateway's Growth Challenges (00:29:28)Stories of Gateway's ongoing expansion and the challenges faced.Excel Training at Gateway (00:31:08)Jeff's initial experience teaching Excel at Gateway's training centers.Role of Excel in Career Progression (00:32:53)Discussion on how various roles contributed to Jeff's Excel expertise.Daily Excel Usage (00:34:38)Jeff explains his daily engagement with Excel and content development.Office Hours Collaboration (00:35:34)The supportive environment of office hours where students share and learn from each other.Learning from Peer Demonstrations (00:36:08)Reflections on how sharing simple Excel techniques can lead to broader learning.Pivot Tables' Impact (00:37:09)Discussion on the transformative power of pivot tables in Excel.Pivot Tables and Formatting (00:38:07)Discussion on the importance of pivot tables and their time-saving formatting features.Power Query Feature (00:38:32)Jeff highlights Power Query as the most impressive Excel feature in the last two decades.Using Tables for Efficiency (00:38:44)Tables help eliminate errors and automatically adjust ranges in Excel functions.Indirect Function Discovery (00:39:12)Tom shares how the INDIRECT function simplified his work with changing templates from multiple countries.Time-Saving with INDIRECT (00:39:52)Tom explains how the INDIRECT function dramatically reduced turnaround time for presenting data.Learning from Excel University (00:40:46)Tom expresses motivation to improve Excel skills and acknowledges the value of Excel University.Time Efficiency Gains (00:41:11)Jeff mentions the significant time efficiency benefits experienced by his students.

Welcome to another episode of Programmer Hour! This week, we dive into some exhilarating topics, including the future of software development as discussed by Chad Fowler at a tech conference. We explore bold claims about all software becoming open source, a blockchain-based token economy, and the role of AI in future coding. We also debate the practicality of these visionary ideas, particularly for fields demanding high security like banking. Plus, stay tuned for a hands-on tutorial on Excel PivotTables—learn to summarize and analyze data with ease. Don't miss out on our discussions about the gap between academia and the job market, and tips for aspiring developers. -- Chapters: 00:00 Introduction and Podcast Overview 00:44 Future of Software Development by Chad Fowler 16:59 Practical Advice for Tech Students 25:24 Job Market Realities and Self-Improvement 29:45 Introduction to Pivot Tables 38:14 Practical Examples and Use Cases 43:51 Filtering and Sorting Data 48:35 Conclusion and Future Tutorials

This podcast explores the transformation of healthcare marketing through AI, highlighting the shift from manual processes to automated solutions that enhance efficiency and decision-making. It discusses the integration of AI tools like GPT models for data management, the impact on workforce roles, and the importance of data quality in driving successful outcomes. The talk concludes with a vision for the future and a call to action for industry leaders to embrace AI to remain competitive in a digitally evolving landscape.Check us out at: mmm-online.com   Follow us:  YouTube: @MMM-online TikTok: @MMMnews Instagram: @MMMnewsonline Twitter/X: @MMMnews LinkedIn: MM+M   To read more of the most timely, balanced and original reporting in medical marketing, subscribe here.

#airtable #on2air #builtonair 5/14/2024 - BuiltOnAir Live Podcast Full Show - S18-E07 ___________________________ The BuiltOnAir podcast is a live weekly show highlighting everything happening in the Airtable universe. Check us out at BuiltOnAir.com/join. Join our community, join our Slack channel, and see what's happening. ------------------------ SPONSORED BY On2Air - Airtable Apps and Integrations to run your business operations in Airtable Start a free 14-day trial of On2Air Apps - https://on2air.com?via=podcast ------------------------ ___________________________ IN THIS EPISODE

Etienne is very happy to be sitting down with Matt Van Itallie, founder of Sema, a company that develops software to help engineering leaders manage AI in software development. As they delve into their shared experiences of learning to code on vintage machines, they explore Matt's journey from studying philosophy to founding Sema.The conversation takes a philosophical turn, discussing pragmatism in decision-making and the importance of clarifying outcomes, and Etienne and Matt also dissect the complexities of C-suite dynamics and the challenges of resolving conflicts within leadership teams. Matt shares insights on the significance of developer retention and the metrics that matter most on a CTO dashboard, and the discussion touches on the art of listening, empathy, and the power of effective communication within organizations.As they plan a session on pivot tables, Matt also emphasizes the value of community, highlighting the support and inspiration found in groups like 7CTOs. Tune in for a thought-provoking conversation on leadership, problem-solving, and the human side of technology!Time Stamps:[2:09] - Learn how Matt's academic journey expanded with a focus on law's evolution and late 19th-century pragmatism.[4:56] - Matt argues that our brains seek to make sense of things.[7:24] - Etienne reflects on navigating conflicting perspectives among C-Suite members, highlighting the challenge of coherence.[10:23] - Focus on critical outcomes, not just outputs.[12:25] - Matt emphasizes fostering understanding through clarifying outcomes and promoting inclusive dialogue and contributions.[15:58] - Matt suggests identifying underlying causes of communication issues and resolving conflicts promptly for organizational success.[16:40] - Hear how Matt prioritizes organizational goals over personal interests, advocating for a values-based decision-making approach.[18:46] - Matt explains how Sema goes about making decisions pragmatically.[21:07] - The opposite of pragmatism might be scrutiny, but pragmatism focuses on moving forward effectively.[24:45] - Mastering pivot tables symbolizes problem-solving prowess, transforming decision-making with raw data access.[28:03] - Discover how pivotal moments led to Sema's inception in 2015, spurred by tech challenges and leadership insights.[30:50] - Matt explains how, inspired by a Bloomberg article, he delved into tech research in 2015, seeking innovation.[32:25] - Matt pursued tech research, seeking licenses from 250 professors; one acceptance birthed Sema.[34:40] - Matt discusses developer retention, a pivotal metric, and how it holds 25 points on Sema's 100-point scale.[37:40] - Etienne shares a story in which a key developer's silence flagged a possible departure, highlighting the important role of product vision clarity.[39:16] - Matt asserts that effective people management discerns subtle shifts in participation, vital for organizational success and cohesion.[41:49] - Matt encourages us to prioritize listening qualitatively to one's team before relying solely on data-driven tools.[43:44] - Etienne agrees, adding that mastering listening is as complex as it is crucial, often underestimated despite its profound impact.We have 200+ CTOs in peer groups: Quick Testimonials VideoContact Etienne: Website / YouTube / LinkedIn / X / Instagram / The CTO Podcast WebsiteContact Matt: Sema Website / LinkedIn / XSchedule a meeting with Etienne on CalendlySee Privacy Policy at https://art19.com/privacy and California Privacy Notice at https://art19.com/privacy#do-not-sell-my-info.

Andrew's iMac is back.. again! Long live Intel? Sponsor, not a sponsor. We haven't chatted about movies in a while, and Jason almost still didn't get to. Martin brings some hyper-local "tech news" to the table for discussion! So many Mangos! Using Apple Podcasts? All notes can always be found here (https://listen.hemisphericviews.com/103)! Intel Inside 00:00:00 Audio Hijack (https://rogueamoeba.com/audiohijack/)

Dan is navigating the landscape of task management apps, and, shockingly, Merlin has some thoughts.

View in HD at . You can use a simple spreadsheet in Numbers to track your home or personal expenses. No formulas or calculations are required. Just record your expenses and then use a simple Pivot Table to see a summary of your expenses by category over months or years. Follow this step-by-step tutorial.

View in HD at . Dividing up your data among multiple tables across different sheets can make it difficult to perform calculations and organize. But by using filters or categories you can easily manage your data in a single table. You can also use Pivot Tables in some cases.

Amazon's new Sponsored Brands Attributed Purchase Report doesn't perform miracles like telling you which keywords directly led to which purchase, but it does move us closer in that direction because it offers a lens into how people interact with your creatives. Michael and Brent Zahradnik, of AMZ Pathfinder, explain everything you need to know about this new report, how to make the most of it, how it implicates Total ACOS, and more. We'll see you in The PPC Den!

Super short show this week with only 3 silent updates and zero published releases. This has never happened in the past 101 episodes we have done, but it was bound to happen eventually. Enjoy! Shoutout to our friends at @Lawrence Systems in this week's episode mentioning their studio setup. Check out that video here: https://youtu.be/vgIT96iiU70 Silent Releases Resizing Pivot Tables in Google Sheets Improved search results based on recent search activity in Gmail Share Google Docs, Sheets, and Slides files in Google Meet chat Published Releases Zero published releases this week Other Topics ChromeOS isn't ready for 120 Hz Chromebooks even though cloud gaming is Framework Chromebook has shipped! tabGeeks Resources

Steve is the Owner and Managing Partner of Evergreen CFO Group, offering fractional CFO and financial management services. His clients range from $500m divisions at Fortune 100 organizations to Silicon Valley tech startups - both of which Steve has had experience leading prior. In this episode of the Chief Future Officer, we are able to dig into how anyone can find success in both professional and personal spheres of life. Despite the workload of servicing varied clients, Steve finds the time to block out the weekend to go mountain biking with his family - and shares the systems that can recreate this flexibility. This episode is for all finance professionals puzzling over upgrading their career while still keeping a balance - hosted by the founder of Quolum, Indus Khaitan.

How can we pivot on spark?

Show Resources Here were the resources we covered in the episode: Lead Gen Form Ads Reporting UTM live builder NEW LinkedIn Learning course about LinkedIn Ads by AJ Wilcox Contact us at Podcast@B2Linked.com with ideas for what you'd like AJ to cover.   Show Transcript I think B2B marketing and CRMs go together like chocolate and caramel. Today, we're diving into CRM reporting on this episode of the LinkedIn Ads Show. Welcome to the LinkedIn Ads Show. Here's your host, AJ Wilcox. Hey there, LinkedIn Ads fanatics! If you listened to the last episode about the cookiepocalypse, you know that conversion tracking as we know, it probably isn't going to be reliable in the future. Luckily, B2B and E commerce have something in common here. In E commerce, marketers will always have purchase data, whether or not it occurred, what the sale value was, etc. And no cookie can affect that. There's a very clear line all the way from ad impression to a purchase. In business to business. When someone fills out a form it goes into your CRM. So if you're doing it right, there's never a challenge in figuring out how many leads came from a specific effort. If someone filled out a form and submitted it, it's in the database, it's become increasingly important in business to business to make sure that we've got data available to us as marketers, so we can close the loop on reporting. That way, when a platforms conversion tracking is way under reporting, because cookie data is limited, or when a platform may be way over reporting because it's using some algorithm to calculate the estimated number of conversions, you can be totally carefree. On this episode, we're gonna dive into the connection between your ads efforts, and your CRM platform and show you what you can do with the day that to close that reporting. Another hat tip to Mark Bissoni for requesting this topic. And any of you out there who have a topic you'd like us to cover, please do reach out to us at Podcast@B2Linked.com. We are always looking forward to helping you become more super powered and hear about the topics that you're interested in. In the news, for you listeners who are attending HubSpot Inbound conference in Boston, I'm going to be speaking on Thursday there. So I'd love to get to connect if you're going to be in town. I heard a couple of weeks back that my session was totally filled up. So I hope you got registered early. But if not get there early to stand in the standby line, I speak at quite a few digital marketing conferences every year. And Inbound is by far the largest one that I speak at. And it's one of the ones I most look forward to every year. Okay, for the topic at hand, let's hit it. 2:27 What is a CRM? What is a CRM? First of all, we talk about it a lot in business to business, we may use the acronym, or we may say customer relationship management platform. But realistically, we're gonna say CRM, because the other one just hardly makes any sense. It's basically a database of your customers, your prospects, really anyone you'd want to keep track of. There are so many different types of CRMs out there. Really, anything can qualify as a CRM. If you just keep an Excel sheet, or a Google sheet of all of your current customers with some data about them, that is a really basic CRM. So don't be daunted when you hear the term if you haven't heard of it before. Some of the major CRMs that you've probably heard of before, are like Salesforce, HubSpot, Constant Contact. There's way, way, way too many to list all here. And all of them have their own personalities. Some are very tailored to sales, some are tailored more to marketing, some are better for email versus reps who are making calls. We B2Linked we actually went through several CRMs testing this, and we would have one that worked really, really well when we were doing outbound. And another that was much better with handling inbound. One connected to email really well and made it easier to do newsletters. And ultimately, you're gonna have to study all of the different capabilities based off of what you need your CRM to do. I would say most of our larger clients use Salesforce. And what's so cool about Salesforce is it's infinitely customizable. You can literally make it do whatever you want. But along with that customizability it means it's incredibly complex. Most of our clients who use salesforce.com have an internal Salesforce admin whose job it is just to keep the platform up and running. So if you don't want to hire a full time admin, there are certainly simpler CRMs. But it's great because you can make it do whatever you want. HubSpot has recently become a pretty great contender in the enterprise space. It offers the CRM functionality for free, but then the fees really start to kick in when you add on different marketing or different sales packages. I should say that HubSpot relationship with LinkedIn really makes it special. Because HubSpot and LinkedIn communicate really well. A lot of these integrations that we're going to talk about are done pretty much automatically. So as a marketer, why would you want to do this? Why should you care about a CRM? The simple fact is that your CRM extends your data, your ability to analyze, and your optimizations, beyond just those front end metrics. If all you do is rely on just LinkedIn's campaign manager, the deepest insights that you can get are things like a cost per lead, or a conversion rate, which as you'll remember from the last episode, those metrics are even getting muddy. So that means you can't actually get accurate lead counts, or number of qualified leads, or figure out your lead quality by campaign, or even solve the Holy Grail, which is calculating your ROI. You can't do any of this without involving your CRM. 5:26 Getting the advertising data into the CRM In order to connect your advertising data in with your CRM, you have to get the advertising data into the CRM. And there are two different ways to do that. The first is if you're using LinkedIn lead generation forms. If you want to know more about this, go back to Episode 17, where we did a deep dive on them. And these are really, really great, they tend to have super high conversion rates. But because that data actually lives on LinkedIn, you then have to get that data out. Of course, you could log into LinkedIn every day, and download the leads that have occurred in the past 24 hours, and then manually process them. But good heavens, if you are listening to this podcast, you are paid way too much for doing that activity. 6:07 Automation Okay, so let's figure out how to automate that. LinkedIn has partnered with several of these CRMs to allow you to just send that data directly into the CRM without any sort of human contact, Salesforce.com, HubSpot, Marketo, Eloqua, and quite a few others, I've included a link down below in the show notes so you can see all of the different integration partners with your LinkedIn Ads. But if you're not using one of the CRMs, that LinkedIn fully integrates with, don't worry about that, because you have a pretty cheap solution. Zapier.com, last time I checked, their $20 per month plan could get all of your LinkedIn lead gen formatted data directly into about any CRM or any workflow that you want. And $20 a month is definitely a cheap price to pay, compared to having to do that all manually. So that's LinkedIn lead gen forms. What if you're driving traffic to your website and you want the form on your website to pass into your CRM? That's definitely possible. We've all been doing that for years. And here's how that process works. First of all, when someone clicks on your ad and visits your landing page, the link that they visit, can and should have tracking information in it. We call these tracking parameters. So those tracking parameters are just sitting in the address bar when someone is there on your page. And then when they decide to fill out the form, the info that it asks for might be things like your name, your email, etc. And then they hit submit. But what they don't know is that before the form is submitted, the JavaScript of the page made note of the whole URL that was up in the address bar, and all of its tracking parameters that could have in it, and it sent them along into the CRM, along with those visible form fields. So the CRM now has data about who someone was, as well as a little bit of information about where that traffic came from, which is incredibly helpful to you as a marketer. So then your CRM needs to be configured to actually look for those parameters and how to recognize them. And it'll store them inside that lead record that was just created through that form submission. Since the vast majority of marketers out there are using Google Analytics, we should take some time to talk about UTM parameters. Now don't get confused by the acronym UTM. Hardly anyone knows what it means it doesn't really mean anything. It stands for urchin tracking module. Urchin was the company that Google acquired to actually turn it into Google Analytics. So it's just a brand name, you don't have to worry about it. But now we as marketers talk a lot about UTM parameters, because Google Analytics has a set of five standard parameters that it accepts natively. And those are source, medium, campaign, content, and term. The first three are required, you need to provide a source, a medium and a campaign, but content and term and then a whole bunch of other custom ones, they're optional. So I'll give you an example. If I was sending traffic from LinkedIn Ads into my website, my UTM parameter for source would probably be LinkedIn. It's the website or the channel that I'm using. For my medium, I like to identify the different ad formats I'm using. So if I'm sending sponsored content ads to my website, I would probably put SC for sponsored content in media. Then for campaign I like to actually include information about either the actual campaign within LinkedIn, or a description of the audience. And that way, if I go into Google Analytics, I can see all of my reporting by audience segment, which is really cool. Then we have content. And Google originally designed this to be a way that you could tell the difference between your AB tests that you're running. So when we create ads, every single ad has its own unique UTM content parameter. And because it absolutely has to be unique. By far the easiest way I've found to make something unique is to stick today's date in it because obviously today's dates not going to repeat itself. So one of our content parameters might look really daunting to someone who doesn't know what they're looking at. But it may say something like LI, short for LinkedIn, SC, short for sponsored content, and then a six digit number representing today's date. And then like 0102, an incremental digit for which ad this was that we were publishing. And what's so cool is because that content parameter includes all of that information, it allows us to go back and figure out the exact image, the exact everything that was associated with that ad later on. And we track that all internally with proprietary tools. So this is obviously a very proprietary way that we handle the UTM content parameter. But I hope just as an example, this was helpful or interesting to you. The last standard UTM parameter is term. And that was used to track the individual keyword from different search campaigns. But obviously, because we're dealing with paid social here with LinkedIn, we don't really bid by keyword. So term is just one of those ones that's leftover. You could use it for something if you want, but you don't have to. So whether you're using Google Analytics or not, you can still use Google's UTM parameters. Or you could really use anything else. For instance, if you use Adobe Analytics, which is very much used by those enterprise companies, they have a parameter called a CID parameter. And of course, it can be very customized. But this is oftentimes one parameter that represents everything that Google asked for five parameters to represent. When you're advertising on Google, on Google Ads, Google will automatically put something called a gclid, or a Google Click ID inside the URL. And a lot of people are able to grab that parameter and make it useful and identifying an individual click. Facebook has something similar, they call it the FBclid, or Facebook click identifier. And if you don't want to use any of these, you don't have to, you could do your own custom URL parameters. If you look at a URL, anything after the question mark doesn't usually change the content of the page or change the address of the page at all. It's just extra information for some system about that traffic. There are a few very technical exceptions here. But usually, when you look at a URL, the address of the page ends, right as soon as you hit the question mark, and then everything after that, you can change and make whatever you want. So the question mark becomes your first query parameter. And then if you have multiples, they are separated by the ampersand or the and sign. So you can have as many query parameters as you want, it's just the first one is going to start with a question mark. All the other ones after are ampersands. And there's absolutely nothing magic about the parameters that you choose, it just means that you're going to have to configure some system to recognize and identify them, and store them if you want to use them. So if you haven't built parameters before, especially if you're using Google Analytics, there are a whole bunch of free tools out there to build your UTM parameters and your URLs for you. We've linked to one down in the show notes called utmbuilder.com. But it's a very, very simple type of function. And so a whole bunch of different companies have evolved to do this for free. We actually do this all within Excel. We have an automatic URL builder that grabs things from all the different columns that we're building our ads inside of Excel with, and just concatenates them together in the right format. So there are a lot of options, you can really do this any way you want. And we're going to talk a lot about how this information makes it into your forms. But it's helpful to know that UTM parameters were originally designed just to tell your analytic solution, how to categorize the traffic that you're bringing in. So for instance, if you click on a post inside of LinkedIn, that takes you to someone's website, Google Analytics is going to see the referring URL as LinkedIn. And that's pretty much all it knows. And it knows that LinkedIn is a social platform. It's going to categorize that as an organic social referral, which is actually correct in this case. But what if you were running ads on LinkedIn, and you didn't put any sort of parameters in the URL, someone clicks from one of your ads and lands on your website. And now Google Analytics is categorizing it exactly the same, it thinks it was an organic referral from social. But if you put UTM parameters in your URLs, you're telling Google Analytics, this is how I need you to classify this traffic. This is not an organic referral. This is an ad click. And here's the audience that was targeting. And here's what ad type we were using all kinds of different information that you can pass to them be able to properly analyze your marketing efforts. They enable you to look inside of analytics and see website traffic behavior, broken down by any of the UTM parameters you set up. You can see things like average session duration, or pages viewed by campaign or audience or individual ad or ad type. Really, possibilities are nearly endless. Alright, here's a quick sponsor break and then we'll dive into the weaknesses of URL track. 14:52 The LinkedIn Ads Show is proudly brought to you by B2Linked.com, the LinkedIn Ads experts. 15:01 If you're a B2B company and care about getting more sales opportunities with your ideal prospects, then chances are LinkedIn Ads are for you. But the platform isn't easy to use and can be painfully expensive on the front end, at B2Linked, we've cracked the code to maximizing ROI while minimizing costs. Our methodology includes building and executing LinkedIn Ad strategies, customized to your unique needs, and tailored to the way B2B companies buy today. Over the last 11 years, we've worked with some of LinkedIn largest advertisers in the world, we've spent over $150 million dollars on the platform, and we're official LinkedIn partners. If you want to generate more sales opportunities with your ideal prospects, book a discovery call at B2linkedin.com/apply, we'd absolutely love to get to work with you. 15:49 Weaknesses of URL tracking Alright, let's jump into the weaknesses of URL tracking. So first off, since it captures only traffic that submitting forms, this is best suited for what we would call the trust stage. We tend to break our stages down into three different stages, your awareness, your trust, and your advocacy. So you could have tracking parameters in your URLs. But if no one ever fills out a form, it really didn't do much except communicate to your analytics solution where the traffic came from, but nothing is going to make it into your CRM. So you wouldn't be able to tell from your CRM, about view through conversions, or assists from other platforms. The cool thing though, is that your analytics platform can still track what you define as a conversion. And the analytics solution is going to attempt to track all of the activity of that user. Of course, if you listen to our last episode about the cookie pocalypse conversion tracking may not be all that reliable in the future. So we'll just kind of have to wait and see. 16:43 Tracking Parameters And then some web developer decided they wanted their URLs to look clean. And so they do something in JavaScript called a URL rewrite. And then the website can I have come across some websites that do some crazy stuff with URLs. So for instance, you might send a URL with all of the tracking parameters. And then some web developer decided they wanted their URLs to look clean. And so they do something in JavaScript called a URL rewrite. And then the website can automatically strip out your tracking parameters to try to make the site look really clean to your user. The problem is that when that URL gets rewritten, it destroys your tracking. It might be great for visual cleanliness. But the vast majority of users are not going to care that they have junk at the end of their URL, we're so used to seeing long URLs with stuff that we don't understand. Another weakness that we've come across is if someone lands on the page, and then has URL parameters in their URL, but then they click to a different page, those parameters are then lost. Your analytic solution knows that that traffic came in from those parameters. But if that second page is the one with the contact form, and it's trying to grab those parameters, they're not there and it's just going to send through blanks. So when advertising on LinkedIn, my recommendation is to land traffic on a landing page that has the form on that same page. Don't give them opportunities to click elsewhere. Otherwise, you'll lose a lot of this tracking data, we actually experienced this ourselves, we sent ad traffic to a page with a link to a contact form. And of course, we love when someone chooses to contact us. But then as soon as the user navigated to the page with the form, it dropped their URL tracking parameters and so we lost them. We still ask them the discovery call where someone heard about us. So we'll still get a little bit of data about which channels are performing and turning into appointments for us. But it's not nearly as reliable as if I had the UTM content parameter telling me exactly which ad drove that person. So you need to make sure that you configure your CRM to accept this data that you're giving. And this is all to make sure that when someone submits the form, and that data is passed into your CRM, it carries with it information about the source of that traffic. And that means that any lead that enters into your CRM that had tracking parameters in the URL when the form was filled out, would communicate that source information on that lead form. So now once you have the data in your CRM, we get to do some really cool stuff. As a disclaimer here, I'm going to talk you through the steps that I would take in Excel to do this. So if you're not already comfortable with Excel, this may sound a little bit like gobbledygook. But first off, you want to go and find out in your CRM, how do you generate a report for a specific timeframe? What this report should look like the first column should be the date. The second column should be some tracking parameter. For us, it would be the UTM content parameter, but you could put anything you want in there, the UTM campaign, it could be an Adobe ad CID, or anything else. And all subsequent columns would be a count of the number of records for each of the down funnel conversion steps that you want to track. So for instance, in standard B2B, we might have like an MQL for marketing qualified leads and an SQL for sales qualified leads. We might have number of proposals sent out Number of close deals that happened. And that means any of my tracking parameters that brought in a lead, or graduated to an SQL or graduated to a proposal or a closed deal on that date, it would have an incremental digit in one of those columns. You export this to Excel so that you can get ready to combine it with your spend performance data. I'm going to refer to this CRM data as CRM data from now on. Then you want to actually go to your LinkedIn ads reporting. So you go into LinkedIn Ads, it's very important, you want to make sure you've set your timeframe for your reporting as the same timeframe that you're looking at for your CRM data, then you want to export your ad performance data into Excel. Now, it's really important that you do choose the ad Performance Report, because that's the report that is going to have all of your click URLs in them. And your click URLs is where your UTM parameters or other tracking parameters are housed. You should generate this as an all time report. Otherwise, you might have a row for every single ad that ran for every single month or every single day that it ran. So generate that as an all time combined report and then you won't need to run an extra Pivot Table on your data later, which would be a pain. If you haven't listened to Episode 69 of the podcast all about reporting, you'll definitely want to make sure you do that. Then the next steps that I do is I will take the destination URL column, which houses all of the URLs with their tracking parameters and I make a duplicate of that column. And someone who's really good at Excel is about to tell me how dumb I'm doing this, I need to strip out just the tracking parameters that I care about into their own columns. And so I do this with the search and replace function inside of Excel. If I'm trying to isolate just my UTM content parameter. For instance, I'm going to do a search and replace on that column in Excel. I'm going to start with the asterisk, which is a wildcard in Excel. And then I'm going to put UTM underscore content equals and then I'm going to leave the replace blank. So what happens is Excel is looking for anything that comes before UTM underscore content equals and replacing it with nothing. So now on the left side of that URL, I have only the contents of my UTM content parameter. If there are other parameters that came after it, I can do the same thing by doing a search and replace for whatever comes after that maybe the first few characters or something with a wildcard after that. And then again, replace that with nothing. Now I have a column where just the values of my UTM content parameters are housed. If I care about the other UTM parameters, I can do the same thing to isolate source, medium, campaign, term, etc. So now you have a column for each UTM parameter that was associated with each ad. So now I can create a pivot table where the row is the tracking parameter and then my values are the columns that I bring in are things like spend, impressions, clicks, and any other ad performance data I care about. So this sheet that you're working with right now becomes your base data, as I call it. So you want to keep this sheet open. And I'm going to refer to this as your ads data from now on. So if you're tracking so far, we have a spreadsheet containing your CRM data. And we have this one that contains your ad data. So now you want to go and take your CRM data and paste it into a new sheet in your workbook. That way, it's one Excel file that houses all of your CRM and your ad performance data. Then once it's all in one sheet, you get to start doing the magic work, you can start combining your ads data with your CRM data to find insights. So in your ads data, I would then go and create a new column for each of the lead stages. So I might create a column for MQL, one for SQL, one for proposal, one for closed deal. And then to fill those columns up, I'm going to do a V lookup, which allows me to bring in the number of each type of those conversions by whichever tracking parameter was there within my ads. So if I were doing it, I would look for that ads individual UTM content parameter, that's my tracking parameter, then I would go to our sheet that contains the CRM data and pull in the number of MQLs associated with that UTM parameter. I'd go and do the same thing, another lookup to bring in the second stage, maybe SQL, another one to bring in proposals, and other to bring in closes. So now we don't even need that sheet with our CRM data anymore. We can do everything from right within the ABS data. Now highlight all of your ABS data and create a pivot table from there. And again, you want your tracking parameter to be the row and then for your values. You want to bring in all of your ad performance. So your spend your impressions your clicks, video views, whatever you want to bring in. And then what I do is inside of that pivot table, I go to create additional calculated columns. You can do it manually is kind of the lazy way. But it's a lot easier to do this as calculated columns. So I'll go and create calculated columns for click through rate and cost per click. I'll create one for conversion rate, that is essentially my MQLs divided by my clicks, or leads, divided by clicks, whatever you're using, I can create one for cost per conversion. But now because I have these columns in my data for number of MQLs, number of SQL, all those further lead stages, I can create a calculated column of my cost per MQL, my cost per SQL, my cost per proposal, my cost per closed deal. Extra credit if you're actually pulling in the deal value from your CRM, then you could actually do a calculation of my actual return on adspend, or my return on investment. I also like to create columns for my close rate, or my graduation rate from every stage of the funnel. So I could show my graduation rate from MQL to SQL. So now you're actually looking at a report making decisions about the ad performance, based on the performance all the way down the funnel. It allows you to make decisions like oh, my cost per conversion is cheap with this audience, but they convert to sales qualified lead at a really poor rate. So it's really not worth us running. And there are so many more steps here that just talking you through, it isn't going to work very well. So I would encourage you to come follow us on YouTube. And I'm going to do a walkthrough of a down funnel report, the whole build, in the coming weeks, so you can follow along. And you can see the link to our YouTube channel, just down in the show notes below. Make sure you're subscribed. 26:44 Nurturing Your Leads So let's get away from the geeky stuff. Now, what can you do to actually nurture your leads, once they're in the CRM? Well, remember, your CRM is basically just a database of the people that you've put in there. So you could export from your CRM, all current customers, and then upload that into LinkedIn as a matched audience, to target and show messaging to those who are your current customers, which could be really good for retaining them. And once you have that list, you can also exclude it from your other targeting, so that you're not showing prospecting ads to people who are already paying you money. Something else I really like to do from nurture, is download a list of active leads, especially the companies that who have become leads, but haven't yet closed the deal. And I can upload that into LinkedIn, and create a warming campaign just around trying to inspire those active leads to close. But of course, if this is done inside of your CRM, most of the time, this is able to be pushed out through your marketing automation workflow, or as an email list. So the same advertising you could do to people who are active leads, but haven't closed, you could also send them emails to keep them informed. Or maybe your marketing automation system does SMS or text messaging. If you have a list of emails, most ad platforms, at least the major ones, allow you to upload those lists of emails and target them with ads, just like LinkedIn. But Facebook, custom audiences can do it. Google can, Quora can, Twitter can. So there's a lot here that you can do across all of your different platforms. And just another note here on lead quality reporting, you could wait for sales to give you some sort of a lead quality or a lead score on the leads as they come in. But I find if I have enough leads coming in just my graduation rate from MQL to SQL, or SQL, which might be stage two to stage three, whatever comes next is going to be really effective at telling me the quality of the leads that are coming through. If they're not graduating to stage two or stage three in my sales process, chances are sales does not think those leads are very high quality. So for instance, if one campaign has a higher cost per SQL than another campaign, you can take action by lowering the bids or pausing that campaign entirely. Or if you have one ad that has a terrible graduation rate, you could pause that ad and go and try something else. 27:16 Pitfalls As you're setting up your CRM to be able to do everything that we're talking about, there are some pitfalls that you might come across. So let's go through a few of those. We have had a situation several times with our clients CRMs, where our point of contact will ask us to send over the tracking parameters in advance so that they can set the CRM up to recognize and watch for that parameter to occur. We don't want to do this, since it requires human work before every ad launch. And if you happen to launch ads before that work has been done in the CRM, then the CRM won't properly track that traffic, which is not great. So just know that whatever CRM you're using, it can be set up so you don't have to do this. What it does is it just dynamically grabs every parameter from the URL and inserts it in the lead record. So make sure you're set up to do that. I should note that hubs Spot does this really, really well, because of its integration with LinkedIn. As traffic comes in from LinkedIn to your website into HubSpot, I'm pretty sure this is already right out of the gate. Another pitfall that we've come across is multiple forms being filled out by the same user ends up overwriting the tracking parameters from the last time. So for instance, if I clicked on a LinkedIn ad, and filled out a form, and then came back three weeks later from a Google retargeting ad, and then filled out a different form, as they both go into the CRM, a lot of times what happens is the CRM goes, oh, we have an update on this user and so I'm going to delete the tracking parameters that say that they came from LinkedIn and update it as now they came from Google. And I'm sure you can see why this is a problem. If you're trying to track your LinkedIn performance, you don't want to lose those leads that are just taking further action with the website. So what you want to happen is you want to stack all of their tracking parameters. So every time a user comes through, and fills out a form, and they come up with new tracking parameters, it just keeps record of all of the steps that that user took in their journey. You might also have some logic that decides how to treat duplicate form fills. Some teams really care about net new leads. So sure, you're gonna drive traffic from LinkedIn. And the same person over a two month period maybe has filled out a form twice so there's two conversions. But if the team says we only care about net new conversions, they might treat that just as a single conversion. I get asked a lot about different attribution models. Do we recommend first touch attribution, last touch, W shaped multi touch? Well, I definitely have an opinion here. But I don't have a blanket opinion that boosts one model up over another. The model I care about is what I call any touch attribution. Since we're managing only one ad channel, but our clients, our points of contact, they need to judge the performance over multiple channels that they oversee, they're going to need to select the attribution model that they care about and want to use. And we do of course, hope that it's one that fairly attributes the performance across all the channels. So that's attribution done by the manager. But I suggest every individual channel owner gets access to every single lead that was touched by their channel. And I call this any touch attribution. What this means is when we go to do reporting on LinkedIn ad performance, every ad and every conversion that was driven, I can then link up to spend that occurred on the platform. So we have a precise calculation for the cost per lead, and their cost per qualified lead, etc. And ultimately, if the manager decides that they want to give the credit for a deal, partially or fully to another channel, I don't care. What I care about is getting as much data about which of my ads and campaigns are driving actions. So I can then go and optimize towards those data points and make the LinkedIn account better. So as a recap here, managers over multiple accounts should be using a general attribution method. But individual channel owners should be running off of any touch attribution, because you're definitely going to want as much data about performance down funnel as possible to help improve your ad creative. 30:53 All right, I've got the episode resources for you coming right up. So stick around. Thank you for listening to the LinkedIn Ads Show. Hungry for more? AJ Wilcox, take it away. 33:29 We mentioned lead gen form ads on LinkedIn, that's episode 17, so go and make sure you've listened to that. Also, Episode 69 is all about reporting so make sure you've caught up on that. To build UTM parameters onto your URLs, that's just utmbuilder.com, You can see the link in the show notes as well. There's also a link to our YouTube channel where you can see future reporting breakdowns that I'm gonna do. If you or someone on your team is looking to learn more about LinkedIn Ads, definitely pass them the course you'll see the link down below. It's the LinkedIn Learning course all about LinkedIn Ads that I'm the author of. It's by far the least expensive and the most in depth training that you can find on LinkedIn Ads right now. So check that out. Also, look down at your podcast player right now. If you haven't already, hit subscribe, and everything I'm sharing with you absolutely is free. But I hope you'll consider going to actually leave us a review in your podcast player. It is the biggest way that you can say thanks for us putting these episodes together with any questions, tips, tricks, suggestions, anything like that, hit us up at Podcast@B2Linked.com. And with that being said, we'll see you back here next week. Cheering you on in your LinkedIn Ads initiatives.

View in HD at . If Pivot Tables in Numbers seem intimidating, watch this tutorial to see how easy they are to use. You can get a lot of information without ever needing to using functions or formulas.

How To Use #PivotTable in #Excel | Excel 2019 | #MSExcel | #DataManagement Function and formulas are really #important in excel, let us check out some of them with the help of #examples. A pivot table is one such feature in excel that can be used to analyze data effectively. BPA Educators offer Basic and advanced courses in taxes and accounting, which helps you run your business properly and manage your business wisely. Linked videos: https://youtu.be/G-kjhJHm12c Popular videos: How to use a pivot table in excel https://www.youtube.com/watch?v=zuPy6zuZT2E&t=3s KEY FEATURES 1 Live project A Certificate of Professional Training after the completion of course. OJT Certificate. OJT(On the Job Training). To get more updates join VIP COMMUNITY OF BPA EDUCATORS- https://www.facebook.com/groups/bpamastery/ Expert advice Call: +91-8512851249 Address: F-17/175-176, Sector-7, Rohini, Delhi-110085 Website: www.bpaeducators.com Instagram: https://www.instagram.com/bpaeducator/ Facebook: https://www.facebook.com/bpaeducator Twitter: https://twitter.com/EducatorsBpa LinkedIn: https://www.linkedin.com/company/bpa-educators/ Shortcut keys are very important to work faster. Do watch our video to learn about the 10 top shortcut keys of excel Do give your takeaways in the comment section if you liked this video. Don't forget to follow us on Facebook, Instagram Instagram:https://www.instagram.com/bpaeducator/ Facebook:https://www.facebook.com/bpaeducator #bpa #bpaeducators #bestinstituteinrohini #Excel #Exceltips #exceltricks #spreadsheets #workhacks #tutorial #Bpamastry #pivot #pivottables #pivot_table #pivots #exceltutorial #pivotanalysis #pivotchart #exceltips #exceltutorialinhindi #learnexcel #excel_hacks #excel_easy #excel_learning #excel_hindi #Excel_2022pivot table interview questions and answers

One of the biggest challenges of financial modelling is creating models that are accurate and realistic. Financial modellers need to have a good understanding of all of the different formulas and functions in order to create an accurate model. Many people, even experienced modellers, use less than 5% of the functions available. Excel models need to be properly structured too so that others can easily validate them, and they can be checked for errors. There are lots to learn about, and many tips and tricks that can make your life much easier. That's why Myles Arnott and Giles Male set up Full Stack Modeller. In this episode, Kevin Appleby chats to Miles and Giles to discover more about the challenges of building great financial models in Excel and how the Full Stack Modeller training and community of members can help you. We teach financial modelling basics in GrowCFO's finance team training, but if you want to develop really deep specialist modelling skills Full Stack is the place to go. If you want to join Full Stack Modeller's next cohort this coupon code will give you 15% off: GROWCFO15AUG. Registration opens on 8th August. Full Stack Modeller will give you: Excel Mastery. From core function knowledge and confident use of Excel Tables and Pivot Tables, to a truly unique way to develop your shortcut and navigation skill mastery. the major modelling standards, setting you up for more advanced modelling exercises to come further on in your journey.Advanced Financial Modelling. Covering the fundamentals of three statement modelling, valuations, scenarios & sensitivities, and more. Data Visualisation & Analytics. How to use Power BI to analyse data, and we help you understand how best to share your insights with others. These are skills that are rare to find, even amongst very talented and experienced modellers. Listen to the full episode to find out more. Links Giles Male on LinkedInMyles Arnott on LinkedInKevin Appleby on LinkedInGrowCFO for Finance TeamsFind out more about Full Stack Modeller (use coupon code GROWCFO15AUG to get 15% off at checkout) Timestamps 01:04 About Full Stack Modeller 03:37 What are financial models used for? 04:50 Don't most people teach themselves how to use Excel? 07:30 Power Query 09:48 What about apps that replace Excel? 11:40 What bad habits do self-taught experienced modellers generally have? 13:12 The problem of too much data 15:05 Data visualisation 18:55 How do you teach modelling when there are so many different applications of models? 20:40 Trapping errors in models 26:34 What are the 5 or 6 key things we really need to know? 29:11 The danger of a single Excel guru in a company

Array Cast - July 8, 2022 Show Notes[01] 00:01:15 Dyalog Problem /solving Contest https://contest.dyalog.com/?goto=welcome[02] 00:01:35 Dyalog Early Bird Discount https://www.dyalog.com/user-meetings/dyalog22.htm[03] 00:02:40 Jeremy Howard wikipedia https://en.wikipedia.org/wiki/Jeremy_Howard_(entrepreneur) Fastmail https://www.fastmail.com/ Optimal Decisions Group https://www.finextra.com/newsarticle/18047/choicepoint-acquires-insurance-analytics-firm-optimal-decisions[04] 00:04:30 APL Study Group https://forums.fast.ai/t/apl-array-programming/97188[05] 00:05:50 McKinsey and Company https://en.wikipedia.org/wiki/McKinsey_%26_Company[06] 00:10:20 AT Kearney https://en.wikipedia.org/wiki/AT_Kearney[07] 00:12:33 MKL (Intel) https://en.wikipedia.org/wiki/Math_Kernel_Library[08] 00:13:00 BLAS http://www.netlib.org/blas/[09] 00:13:11 Perl BQN https://mlochbaum.github.io/BQN/running.html[10] 00:14:06 Raku https://en.wikipedia.org/wiki/Raku_%28programming_language%29[11] 00:15:45 kaggle https://www.kaggle.com/ kaggle competition https://www.kaggle.com/competitions/unimelb/leaderboard[12] 00:16:52 R https://en.wikipedia.org/wiki/R_(programming_language)[13] 00:18:50 Neural Networks https://en.wikipedia.org/wiki/Artificial_neural_network[14] 00:19:50 Enlitic https://www.enlitic.com/[15] 00:20:01 Fast.ai https://www.fast.ai/about/[16] 00:21:02 Numpy https://numpy.org/[17] 00:21:26 Leading Axis Theory https://aplwiki.com/wiki/Leading_axis_theory[18] 00:21:31 Rank Conjunction https://code.jsoftware.com/wiki/Vocabulary/quote[19] 00:21:40 Einstein notation https://en.wikipedia.org/wiki/Einstein_notation[20] 00:22:30 GPU https://en.wikipedia.org/wiki/Graphics_processing_unit[21] 00:22:55 CUDA https://en.wikipedia.org/wiki/CUDA[22] 00:23:30 Map https://en.wikipedia.org/wiki/Map_(higher-order_function)[23] 00:24:05 Data Science https://en.wikipedia.org/wiki/Data_science[24] 00:25:15 First Neural Network https://en.wikipedia.org/wiki/Frank_Rosenblatt[25] 00:28:51 Numpy Another Iverson Ghost https://dev.to/bakerjd99/numpy-another-iverson-ghost-9mc[26] 00:30:11 Pivot Tables https://en.wikipedia.org/wiki/Pivot_table[27] 00:30:36 SQL https://en.wikipedia.org/wiki/SQL[28] 00:31:25 Larry Wall "The three chief virtues of a programmer are: Laziness, Impatience and Hubris." From the glossary of the first Programming Perl book.[29] 00:32:00 Python https://www.python.org/[30] 00:36:25 Regular Expressions https://en.wikipedia.org/wiki/Regular_expression[31] 00:36:50 PyTorch https://pytorch.org/[32] 00:37:39 Notation as Tool of Thought https://www.jsoftware.com/papers/tot.htm[33] 00:37:55 Aaron Hsu codfns https://scholarworks.iu.edu/dspace/handle/2022/24749[34] 00:38:40 J https://www.jsoftware.com/#/[35] 00:39:06 Eric Iverson on Array Cast https://www.arraycast.com/episodes/episode10-eric-iverson[36] 00:40:18 Triangulation Jeremy Howard https://www.youtube.com/watch?v=hxB-rEQvBeM[37] 00:41:48 Google Brain https://en.wikipedia.org/wiki/Google_Brain[38] 00:42:30 RAPIDS https://rapids.ai/[39] 00:43:40 Julia https://julialang.org/[40] 00:43:50 llvm https://llvm.org/[41] 00:44:07 JAX https://jax.readthedocs.io/en/latest/notebooks/quickstart.html[42] 00:44:21 XLA https://www.tensorflow.org/xla[43] 00:44:32 MILAR https://www.tensorflow.org/mlir[44] 00:44:42 Chris Lattner https://en.wikipedia.org/wiki/Chris_Lattner[45] 00:44:53 Tensorflow https://www.tensorflow.org/[46] 00:49:33 torchscript https://pytorch.org/tutorials/beginner/Intro_to_TorchScript_tutorial.html[47] 00:50:09 Scheme https://en.wikipedia.org/wiki/Scheme_(programming_language)[48] 00:50:28 Swift https://en.wikipedia.org/wiki/Swift_(programming_language)[49] 00:51:10 DragonBox Algebra https://dragonbox.com/products/algebra-12[50] 00:52:47 APL Glyphs https://aplwiki.com/wiki/Glyph[51] 00:53:24 Dyalog APL https://www.dyalog.com/[52] 00:54:24 Jupyter https://jupyter.org/[53] 00:55:44 Jeremy's tweet of Meta Math https://twitter.com/jeremyphoward/status/1543738953391800320[54] 00:56:37 Power function https://aplwiki.com/wiki/Power_(function)[55] 01:03:06 Reshape ⍴ https://aplwiki.com/wiki/Reshape[56] 01:03:40 Stallman 'Rho, rho, rho' https://stallman.org/doggerel.html#APL[57] 01:04:20 APLcart https://aplcart.info/ BQNcrate https://mlochbaum.github.io/bqncrate/[58] 01:06:12 J for C programmers https://www.jsoftware.com/help/jforc/contents.htm[59] 01:07:54 Transpose episode https://www.arraycast.com/episodes/episode29-transpose[60] 01:10:00 APLcart video https://www.youtube.com/watch?v=r3owA7tfKE8[61] 01:12:28 Functional Programming https://en.wikipedia.org/wiki/Functional_programming[62] 01:13:00 List Comprehensions https://docs.python.org/3/tutorial/datastructures.html#list-comprehensions[63] 01:13:30 BQN to J https://mlochbaum.github.io/BQN/doc/fromJ.html BQN to Dyalog APL https://mlochbaum.github.io/BQN/doc/fromDyalog.html[64] 01:18:15 Einops https://cgarciae.github.io/einops/1-einops-basics/[65] 01:19:30 April Fools APL https://ci.tc39.es/preview/tc39/ecma262/sha/efb411f2f2a6f0e242849a8cc8d7e21bbcdff543/#sec-apl-expression-rules[66] 01:20:35 Flask library https://flask.palletsprojects.com/en/2.1.x/[67] 01:21:22 JuliaCon 2022 https://juliacon.org/2022/[68] 01:28:05 Myelination https://en.wikipedia.org/wiki/Myelin[69] 01:29:15 Sanyam Bhutani interview https://www.youtube.com/watch?v=g_6nQBsE4pU&t=2150s[70] 01:31:27 Jo Boaler Growth Mindset https://www.youcubed.org/resource/growth-mindset/[71] 01:33:45 Discovery Learning https://en.wikipedia.org/wiki/Discovery_learning[72] 01:37:05 Iverson Bracket https://en.wikipedia.org/wiki/Iverson_bracket[73] 01:39:14 Radek Osmulski Meta Learning https://rosmulski.gumroad.com/l/learn_machine_learning[74] 01:40:12 Top Down Learning https://medium.com/@jacksonbull1987/top-down-learning-4743f16d63d3[75] 01:41:20 Anki https://apps.ankiweb.net/[76] 01:43:50 Lex Fridman Interview https://www.youtube.com/watch?v=J6XcP4JOHmk Deep Talks #54 https://www.youtube.com/watch?v=n7YVlPszaWc0

How to Consolidate ALL of your Search Term Data into a single Pivot Table00:00 PPC Pivot Table Search Term Hack00:42 The Ads dashboard01:38 All reports should have the same format02:20 Opening up Excel04:01 Creating connections06:08 Get data06:16 Combine craze and append06:57 Power Query editor08:13 Creating a pivot table08:55 Selecting match type09:26 Customer search terms11:30 Average ACOS12:30 Combining search terms together

The post Pivot Tables appeared first on Moore Solutions Inc.

What do business intelligence tools do? Coffee Break Session Host Alexa Cook catches up with Strategic Treasurer's Managing Partner, Craig Jeffery, to discuss this topic. They cover what business intelligence tools do and how treasury can leverage them. Listen in and learn a little bit about business intelligence tools.  

Welcome to Plano Library Speaks, the podcast of Plano Public Library!   In this episode, your hosts, Rachel and Bob chat with library staff about a variety of topics, including using littleBits to make fun circuits, maintaining and upgrading professional skills and more. See our show notes below for details and links. Learning & Leading   We speak with Development Coordinator Kristin Linscott about ongoing professional skill-building. Some resources and programs mentioned in this segment: LinkedIn Learning – provides online training courses that cover a variety of topics (including business, design, web development and multimedia skills) and software (Microsoft Office, Adobe Creative Suite and open source applications) Topics worth searching for on LinkedIn Learning: § Teamwork § Communication § Marketing § Time Management Skills   Upcoming Programs Microsoft Excel: Basics – Learn the basics of Microsoft Excel Haggard Library, Tuesday, March 8 at 6:30pm Microsoft Excel: Formulas & Functions – Learn the basics of Microsoft Excel Formulas and Functions and their uses Haggard Library, Tuesday, March 15 at 6:30pm Microsoft Excel: Budget Basics – Apply formulas and functions to the basics of budgeting in Microsoft Excel Haggard Library, Tuesday, March 22 at 6:30pm Microsoft Excel: Pivot Tables – Learn how to create and use Pivot Tables in Microsoft Excel Haggard Library, Tuesday, March 29 at 6:30pm   Create Your Elevator Speech (Adults) – Communicate your idea, who you are, or how you can benefit a company or organization in a way such that any listener can understand it in a short period of time. Learn how to design your pitch to get a positive response. Presented by Andrella Thomas from Capital One Virtual, Friday, March 4 at 2pm – Register   Career Trends with Business Source Complete (Teen, Adult) – Use EBSCO Business Source Complete to research industry trends. Sort industry information by career, location and potential earnings Virtual, Monday, March 7 at 1pm – Register   What Story Are You Telling? (Teen) – How others perceive you depends on your choice of words, actions, and even your appearance. If you're not intentional in telling your story, you may not have the influence or image you desire. Learn the importance of establishing a strong personal brand and the five steps you can take to achieve one. Presented by Debra Austin, Chaos2Results Business Coaching & Consulting Virtual, Monday, March 14 at 2pm – Register   Kids & Family We speak with Library Services Representative Amy Belotte about the upcoming littleBits Challenge program. littleBits Challenge (All Ages) – Explore circuits through different challenges Haggard Library, Saturday, April 2 at 3pm Check out our littleBits Synth Kit in our STEAM Kit collection (as mentioned by Bob) from the library. Search for it in the catalog to place a hold.   Did You Know? We speak with Librarian Caitlyn Tipps about the Digital Creation Spaces and the technology available. Recently added software includes:   § Unity – game coding software; free open-source § Visual Studio Code – coding software; free open-source (Needed to work with Unity) § Soundbridge – a complete digital audio workstation (DAW) works with DCS MIDI sound mixer; free open-source § UnReal Engine 4 – 3D design software; free open-source   Upcoming Programs Unreal Engine: Basics (Teen, Adult) – Learn the basics of the Unreal Engine software and its potential uses for animation, video game development, lighting and more! All skill levels welcome Virtual, Wednesday, March 9 at 1pm – Register Photoshop: Headshots (Adult) – Learn about headshot photography and editing using Photoshop. Virtual, Monday, April 18 at 6:30pm – Register   Audition: Podcast Editing (Teen, Adult) – Learn the basics of audio editing in Adobe Audition for Podcasting Virtual, Tuesday, April 26 at 6:30pm – Register   Meet the Staff We speak with Library Services Representative Evan Gan about the variety of programs and tasks does at the library. Some of The Write Workshop classes have been taught virtually and are recorded: · Oh, I Have An Idea! – Have an idea for a story, but need help getting started? Join Plano Public Library to brainstorm your next short story or best-selling novel! Check out resources on the blog. · The Construction of Space – Learn how to construct a literary space for your story using characters, object details, and a film-like lens. Check out resources on the blog. · The Manipulation of Time – How does time work in narratives? Learn how to manipulate the difference between a reader's experienced time and the story's fictionalized time to strengthen your narrative. Check our resources on the blog. · Check out our other National Novel Writing Month (NaNoWriMo) blog posts for additional resources on finding your voice, building characters and your final draft.   Evan also helps select and catalog the World Languages Collection for Chinese materials. The majority of this collection is at Haggard and Davis libraries, though you can place holds to get this collection at any of our locations. You can also access many books in Chinese through the Libby app. Evan selected and cataloged materials for the 2020 Texas Book Festival Collection Enhancement Grant, awarded to Schimelpfenig Library to add books in Chinese to the collection.

I love podcasts, woo woo woo! I love podcasts, how 'bout you? Here's episode 181, with jessamyn and I contemplating the idea of a week and a month and talking about misc. MetaFilterian stuff. Runs about 90 minutes.Helpful LinksPodcast FeedSubscribe with iTunesDirect mp3 downloadMisc - my penance for being late getting this up is reusing last months experimental horn version of the original podcast theme even though it hurts to listen to now - rabbit rabbit, apparently - 181 is a palindromic prime - I haven't gone back to figure out if I started doing the podcast at episode 34 or earlier, but god it's been a while either way - Jessamyn, when the reference didn't land Projects - The year I won a year's supply of cheese by jessamyn - The Rocinante, my hand-painted ship model from The Expanse by rachaelfaith - The 885 films I saw and reviewed in 2021 by growabrain - Birdsong Audio Separation by kaibutsu - So I made a Wordle clone (with some extra features) by RustyBrooks - Return to the Planet: a Zine Celebrating the 25th Anniversary of FFVII by subdee MetaFilter - "Life's hard enough, and I'm looking to make people feel better" by jessamyn - WKRIP by guiseroom - No More Waiting For The End Of Time by chavenet - Up to 30 stitches per inch! No bobbins! Quiet! by metaquarry - What came first? Or last, or in between? by brainwane - A Brief History of Windfuckers by oulipian - Ex-NM labor official shares real world experience: capitalism sucks by wenestvedt - "There are as many forms of love as there are moments in time." by oulipian - JEOPARDAMY! by Going To Maine - Look at the quality of this 3D animation by They sucked his brains out! - "It's like people who try to clone their dogs" by jessamyn - Free thread! by cortex - Free Thread Returns by cortex - Free Thread Forever by cortex - Free Thread & Robin by cortex Ask MetaFilter - HELP, there's an elk in my freezer! by MonkeyToes - What was that music video with the giant blue butt sculpture? by mermaidcafe - what's that song? by peppercorn - What's that weird instrument: The Beatles: Get Back edition by 2N2222 - When was Van Halen's 1984 album released? by Short End Of A Wishbone - Help identify this mystery object? by scody - What do they call a stupid SOB in your neck of the woods? by Gotanda - Rock music puns? by OrangeVelour - Do I need a bank with a real building I can go to? by DMelanogaster - Parsing Amazon reviews by Cozybee MetaTalk - Introduce yourself! by cortex - Our favorite under-loved comments of 2021 by MonkeyToes - a comment by kimberussell

Pivot Tables in Numbers Tutorial on ScreenCastsOnline $20 heyday Moulded Tip Bluetooth Earbuds – by Caleb Fong Why I Don't Use Spaces on macOS Tesla Tech - First-hand Experience with Full Self-Driving Beta Tiny Tip – Animated Memoji for Login by Marty Jencius Join the Conversation: allison@podfeet.com podfeet.com/slack Support the Show: Patreon Donation PayPal one-time donation Podfeet Podcasts Mugs at Zazzle Podfeet 15-Year Anniversary Shirts Affiliate Links: Parallels Toolbox Affiliate - get 3 mos free Learn through MacSparky Field Guides Backblaze One Free Month

The Franzia himself, Chistopher, joins us for this extra fun episode. Slapping the bag. What is analyze? A shitheaded approach to economics. Icebreaker death memes. The minds are lost via public speaking. Hardcore Excel pussy hounds. Post apocalypse endowments. Bath house wiener etiquette. We have phonecall with Jason, then someone called Brendon an asshole. "Money Machine" - 100 gecs "Meet Me At Our Spot" - The Anxiety, WILLOW, and Tyler Cole "Puppy and a Truck" - Jenny Lewis

Let's Talk Apple #97 Joplin Tutorial on ScreenCastsOnline Pivot Tables Come to Apple Numbers! Tiny Tip – Per-App Accessibility Changes in iOS 15 – by Rick from Baltimore Taking a Break from Facebook A Couple of iOS Dictation Tips Join the Conversation: allison@podfeet.com podfeet.com/slack Support the Show: Patreon Donation PayPal one-time donation Podfeet Podcasts Mugs at Zazzle Podfeet 15-Year Anniversary Shirts Affiliate Links: Parallels Toolbox Affiliate - get 3 mos free Learn through MacSparky Field Guides Backblaze One Free Month

View in HD at . Watch as I take an in-depth look at using the new pivot tables feature in Mac Numbers. Learn how pivot tables can be useful for visualizing data and lots of tips and tricks.

CCATP #700 – Bart Busschots on PBS 126 of X - Introducing Phase 2 iOS 15 – These are a Few of My Favorite Things Tom Mattock on PopSocket for MagSafe Security Bits — 1 October 2021 Join the Conversation: allison@podfeet.com podfeet.com/slack podfeet.com/facebook Support the Show (Affiliate Links): Patreon Donation PayPal one-time donation Parallels Toolbox Affiliate - get 3 mos free Learn through MacSparky Field Guides Shop Podfeet Shirts Backblaze One Free Month

RewindApple Updates Pages with Screen View, Numbers with Pivot Tables, Keynote with Live Video, and MoreCARROT Weather 5.4: XL Widgets, Time Sensitive Notifications, Complication Customization, Themes, Icons, and MoreSafari Extensions for iOS and iPadOS 15: A Roundup of Our FavoritesHow iPadOS 15 Ruined Chris Welch's iPad Home ScreenClub MacStoriesMonthly LogFederico on Marvis ProJohn on setting up devices from scratchJohn published the latest Macintosh Desktop Experience column all about his Loupedeck Live workflowsMacStories WeeklyCraftFederico shares a Working Copy Shortcut for managing hidden folders on iOS and iPadOSJohn has an iPhone drag and drop tipClub Member JC shares their work setupAppStoriesAppStories, Episode 242 – iPad mini: Small WonderUnwindFederico's Picks:Lucifer, Season 6Lifeforms by Angles & AirwavesFollow us on TwitterFederico ViticciJohn VoorheesFollow us on InstagramFederico ViticciJohn Voorhees

We go in-depth on our iPad mini review, discuss the big improvements of the iPhone 13 Pro camera, highlight more iOS Safari extensions, and share our Focus Mode tips. Follow our hosts @stephenrobles on Twitter @Hillitech on Twitter Sponsored by: Masterclass: Get 15% off an annual membership to Masterclass when you visit: masterclass.com/appleinsider Support the show Support the show on Patreon or Apple Podcasts to get ad-free episodes every week, access to our private Discord channel, and early release of the show! We would also appreciate a 5-star rating and review in Apple Podcasts Links from the show iPad mini 2021 Review: Delightfully Small - YouTube iPad mini 2021 review: Delightfully small with few caveats Apple dismisses iPad mini 'jelly scroll' issue as normal behavior iPhone 13 Pro: Hands on with the best new features ‘Float' - Filmed in Cinematic mode 16-inch MacBook Pro power adapter out of stock ahead of expected revamp Tweaks for Twitter Mobile Super Agent for Safari PiPifier Vidimote for Safari GoodLinks Safari Extensions for iOS and iPadOS 15: A Roundup of Our Favorites Keynote, Pages, Numbers 11.2 updates with new collaboration options Apple Updates Pages with Screen View, Numbers with Pivot Tables, Keynote with Live Video, and More More AppleInsider podcasts Subscribe and listen to our AppleInsider Daily podcast for the latest Apple news Monday through Friday. You can find it on Apple Podcasts, Overcast, or anywhere you listen to podcasts. Tune in to our HomeKit Insider podcast covering the latest news, products, apps and everything HomeKit related. Subscribe in Apple Podcasts, Overcast, or just search for HomeKit Insider wherever you get your podcasts. Podcast artwork from Basic Apple Guy. Download the free wallpaper pack here. Those interested in sponsoring the show can reach out to us at: steve@appleinsider.com

View in HD at . The latest version of Mac Numbers adds a new Pivot Table feature. You can now quickly and easily create pivot tables based on the data of another table. Use pivot tables to visualize information in different ways.

The post Get Your AR Data in a Pivot Table appeared first on Moore Solutions Inc.

American Fans Discuss The Global Sport

Join Now For Only $1: https://myexcelonline.com/academy/one-dollar-trial/ You have only a few hours to join our Academy online course for only $1 and get access to: ✔️ Our Excel Beginner, Intermediate & Advanced Courses! ✔️ Learn from 1,000+ quick video tutorials on Formulas, Macros, VBA, Pivot Tables, Power Query/Pivot/BI, Dashboards, Financial Modeling, Word, PowerPoint, Access, OneNote, Teams PLUS MORE! ✔️ Get Excel Certified! ✔️ Access our Teacher support! Join Now For Only $1: https://myexcelonline.com/academy/one-dollar-trial/  

After a very long active beta, the new custom report builder is finally here, and HubSpot went and surprise us with what many have been asking for for years... pivot tables!

Data analyst Excel Q5 What is a Pivot Table and what are the different sections of a Pivot Table? --- This episode is sponsored by · Anchor: The easiest way to make a podcast. https://anchor.fm/app

Data analyst Excel Q1 Can you make a Pivot Table from multiple tables? --- This episode is sponsored by · Anchor: The easiest way to make a podcast. https://anchor.fm/app

It is a special day here at MyExcelOnline as we have just launched our 3rd Excel E-Book: 101 Best Excel Tips & Tricks! This downloadable PDF E-Book has the following cool features: Learn the BEST Microsoft Excel Tips & Tricks EVER, ranging from Formatting, Layout, Formulas, Tables, Pivot Tables, Working with Data plus Many More! Easy to Read Step by Step Guide with Color Screenshots Downloadable Practice Excel Workbooks for each Tip & Trick Interactive & Searchable PDF E-Book to find any Excel Tip & Trick with ease New Excel Tips & Tricks for Microsoft Office 365 We are discounting this E-Book by $10 but only for a limited time only to celebrate this launch.  Click below to get your copy & ADVANCE your Excel level: https://www.myexcelonline.com/115-123.html

Pivot Tables Field lists can be hard to find the field you are after. Since 2013 Microsoft added a search bar in the Pivot Tables Field List area. YouTube Analir Pisani. If you still can't find it drop us a line by visiting our web site http:azsolutions.com.au. If you get really stuck AZ Solutions Pty Ltd customised Microsoft Office training sessions.

Pivot tables are one of Excel's most powerful features. A pivot table allows you to extract the significance from a large, detailed data set. Creating Pivot Table in Advance Excel 1. Select any cell in the source data table. 2. On the Ribbon, click the Insert tab. 3.In the Tables group, click Recommended PivotTables. 4. In the Recommended PivotTables window, scroll down the list, to see the suggested layouts. Click on a layout, to see a larger view. 5. Click on the layout that you want to use, then click OK. #advanceexceltutorial #pivottableinexcel #pivottableoption BPA Educators has been established with a vision to aid students and professionals in achieving their goals. We at BPA Educators understand the aspirations of young students and professionals. Our sole aim is to reduce the hassle that one can encounter while choosing the right career option. We have striven hard for the past 10 years and trained over 1000+ students till date. Our team of counselors is qualified and experienced, consisting of CA's, CMA's, CS, LLB, and MBA's who have exposure to practical training with hands-on experience in the industry, having experience of 10 to 15 years and growing strong with a commitment to transform the career of students with better opportunities amongst various age groups. Linked videos: Cost Center in Tally | Use of Cost Center in Tally- BPA Educators - https://www.youtube.com/watch?v=cFUbqlM0aEo Popular videos: How to use pivot table in excel - https://www.youtube.com/watch?v=zuPy6... Data validation in excel - https://www.youtube.com/watch?v=xDVHt... KEY FEATURES Live projects A Certificate of Professional Training after the completion of course. OJT Certificate. OJT(On the Job Training). Expert advice Call: +91-8512851249 Address: C-8/13, Sector-7, Rohini, Delhi-110085 Email: info@bpaeducators.com Website: www.bpaeducators.com Instagram: https://instagram.com/bpaeducator?igshid=b1rskij5lfc8 Facebook: https://www.facebook.com/bpaeducator Twitter: https://twitter.com/bpa_educators LinkedIn: https://www.linkedin.com/in/bpa-educators-627052190/

In this audio we will learn about the Pivot Table . We can create Pivot Table in Google Sheet.

This week I talk about Pivot Tables and their value for DFIR investigations

What's PowerShell? "Those who don't automate are doomed to repeat themselves" Brief origin of PowerShell PowerShell going open source https://github.com/PowerShell/PowerShell Introduction about me Avri Chen-Roth https://www.linkedin.com/in/avritech/ Just for fun exercise Open a PowerShell on your computer Win/Linux/Mac And run: Invoke-RestMethod https://www.automator.show/rss PSAvalonia - Avalonia bindings for PowerShell https://github.com/ironmansoftware/psavalonia UDForge "Native" Electron apps running Universal Dashboard https://ironmansoftware.com/udforge-build-desktop-apps-with-universal-dashboard/ Snek - PowerShell wrapper around Python for .NET to invoke Python from PowerShell https://github.com/adamdriscoll/snek PSKoans - The goal of the PowerShell koans is to teach you PowerShell by presenting you with a set of questions. Each kōan (each question) is represented by a failing Pester test (Unit test) https://github.com/vexx32/PSKoans ImportExcel - This PowerShell Module allows you to read and write Excel files without installing Microsoft Excel on your system. No need to bother with the cumbersome Excel COM-object. Creating Tables, Pivot Tables, Charts and much more has just become a lot easier. https://github.com/dfinke/ImportExcel Building Lambda Functions with PowerShell https://docs.aws.amazon.com/lambda/latest/dg/powershell-programming-model.html Bash command completers for PowerShell https://github.com/rjmholt/PSUnixUtilCompleters Posh-git is a PowerShell module that integrates Git and PowerShell by providing Git status summary information that can be displayed in the PowerShell prompt https://github.com/dahlbyk/posh-git Selenium-powershell The Selenium PowerShell module allows you to automate browser interaction using the Selenium API. You can navigate to pages, find elements, click buttons, enter text and even take screenshots. https://github.com/adamdriscoll/selenium-powershell Making music

The post February 2020 Pivot Tables appeared first on Moore Solutions Inc.

In this episode of the MGMA Insights podcast, we receive an overview of MGMA20 | The Financial Conference from Craig Wiberg and hear from Tom Campanella on finding opportunity in healthcare disruption. Wiberg is a Sr. Editor for MGMA and serves as the lead content strategist for MGMA’s live events. Campanella — who will be a featured speaker at The Financial Conference, March 5-7 in Nashville — has nearly 30 years of industry experience and is currently a health economics professor and the director of healthcare business programs at Baldwin Wallace University in Ohio. MGMA’s Financial Conference is an industry-leading event designed to arm healthcare professionals with the education and tools needed to run a more profitable and efficient practice. Year after year, The Financial Conference brings together leading financial experts from across the healthcare spectrum to dig deep into pertinent topics like payer contracting, business intelligence and revenue cycle management. To learn more about MGMA20 | The Financial Conference or take advantage of early bird registration, visit mgma.com/TFC20. Don’t quite have time to listen to the entire episode? No worries. We’ve compiled a few highlights from Wiberg’s and Campanella’s interviews for your convenience: • (15:48) “Things are changing so quickly, and there’s so many new sets of tools that it really is super important to take this time to develop yourself as a leader and as a worker.” – Craig Wiberg • (35:09) “Disruption is, in effect, upending the apple cart, if you want to say, of the status quo system of healthcare.” – Tom Campanella • (52:50) “Change can be uncomfortable. I don’t care if it’s personal life or work life. I think they [listeners of the podcast] need to embrace this new world and recognize that it can’t be business as usual, but also recognize that this is a tremendous opportunity, both for them and their organization.” – Tom Campanella Here are some links and reference related to this week’s show: • Navigating the unknowns of an underperforming revenue cycle (bit.ly/36TU9ng) • The upside of downside: Innovative strategies for protecting downside risk (bit.ly/30lOgwC) • Taking the fear out of new codes and embracing eConsults (bit.ly/35Nu9IM) • Riding The Disruption Wave In Healthcare (bit.ly/2tUKrm3) • Largest disruptors in healthcare from the past year (bit.ly/2RfT42j) If you like the show, please rate and review it wherever you get your podcasts. Subscribe on Apple Podcasts (apple.co/368IdOB), Google Play (bit.ly/2paMqAJ), Spotify (spoti.fi/2Nwu59p), Stitcher (bit.ly/2NmAF1M) or countless other platforms to make sure you never miss an episode. We love hearing from listeners about the show. If you have topics you’d like us to cover or experts you’d like us to interview, email us at podcasts@mgma.com or reach out to MGMA Sr. Editor and podcast host Daniel Williams on Twitter at @MGMADaniel. MGMA Insights is presented by Decklan McGee, Rob Ketcham and Daniel Williams. Additional Resources Microsoft Excel’s Pivot Table feature is a fast and powerful way to analyze and consolidate large amounts of data and quickly extract critical knowledge. You can learn how to integrate pivot tables into your medical practice at an MGMA online seminar, Jan. 28-29. During this workshop, presenter Nate Moore will provide a hands-on demonstration and answer questions on how to use this essential tool to analyze your organization’s revenue cycle. For more information or to register, search “pivot table” at mgma.com/store.

The post November 2019 Pivot Tables appeared first on Moore Solutions Inc.

Clear your schedule and set aside some time to listen to this week’s episode of The Get Automated Podcast hosted the smartest man in small business automation Kelsey Bratcher. We drop Episode 63 this week and are joined by smartest man in spreadsheet education Ben Collins Founder of The Collins School of Data. Ben and Kelsey show the path to rapid leveling up with data science using Google Sheets and Google Apps Scripts. Learn what you really need to focus on to get your messy data cleaned up or what need to do to start tracking the metrics important to your business. Pivot Tables, Vlookups, Concatenation, Array Formulas are just some of the important functions that get covered this week. So grab this awesome episode today.

The king of spreadsheets, Matt Modlin, shares three great tips using Google Spreadsheets. He shows us vlookup, translates, and pivot tables. Make a copy of Matt's spreadsheet: https://docs.google.com/spreadsheets/d/1uWyxXX7HP0cRiI9jf98UMW2FqZYeW1lvRewslUCv6Og/copy End of the video is at one of our favorites South Bend restaurants, Crooked Ewe: https://crookedewe.com/ Matt Modlin’s Twitter: https://twitter.com/mmattmodlin Matt Modlin’s LinkedIn: https://www.linkedin.com/in/matt-modlin-4679a84/ Please Subscribe to this YouTube Channel Seth’s Twitter: https://twitter.com/SethPonder Seth’s LinkedIn: https://www.linkedin.com/in/seth-ponder109/ Seth’s Email: sethtponder@gmail.com Seth’s Website: https://sites.google.com/sbcsc.k12.in.us/sethponder/home EdTechHeroes Website: https://www.edtechheroes.com I am always looking for new guests, please contact me on Twitter or email. Thanks for watching.

Show Notes Buffer Overflow: This Pivot Table is Bananas B-A-N-A-ROW NOT FOUND Episode 68 Cell SIM Fraud, Steve Google’s Cloud Conference, and Pentagon War Clouds Hosts Ned Bellavance, Director of […] The post Episode 68: This Pivot Table is Bananas B-A-N-A-ROW NOT FOUND appeared first on Anexinet.

In this week's episode of Ask SME Anything: 1. I have a formula in Excel that has names instead of cells. How did they do that? 2:25 2. A lot of times when I paste something from another place, it looks different and I always have to reformat it. Why does that happen and how can I fix it? 11:59 3. How can I easily see and get rid of duplicates in Excel? 21:43 4. I have some excel files that are still in xls format. What should I be ready to fix if I convert them to .xlsx format? 31:16 5. My coworker always talks about Pivot Tables and how great they are. What is a Pivot Table? 39:09

Today we are launching our latest online Excel course called "The MyExcelOnline Academy Online Excel Course". This online Excel course covers all the best Excel features like Formulas, Macros, VBA, Pivot Tables, Power Query, Power Pivot, Charts, Analysis plus much more! You can access this course today and lock in our special Grandfathered Pricing ($20 a month or $200 a year) FOREVER by going to our course page: 

I do a quick overview of a pivot table in Excel. Honestly Googling instructions and reading through them with pictures or watching a video is going to be more beneficial to you and listen to this. Also my throat hurts so I'm talking pretty quiet, sorry.

I do a quick overview of a pivot table in Excel. Honestly Googling instructions and reading through them with pictures or watching a video is going to be more beneficial to you and listen to this. Also my throat hurts so I'm talking pretty quiet, sorry.

Pitch Talks Live Panel "Analytics, Biomechanics, and Drummers with Pivot Tables" with Carson Cistulli, Mike Sonne, and Nick Dika  Live from the April 5th Pitch Talks Event at The Royal Cinema

Kalani Leifer is a former high school history teacher and the founder of COOP, a fast-growing non-profit that supports cohorts of 1st generation undergrads entering the workforce. Together, he and Monica Guzman, Program Manager and alum of Cohort 1, are evolving a model aimed at supplementing skills that prepare students for high tech jobs. Who knew that basic software remediation might be what stands in the way for many. But the biggest difference for 1st gen students they say? "Literacies" that are social above all else. If you like this episode, subscribe to No Such Thing on iTunes, Stitcher, and Google Play. If it's not available on your favorite player, let me know through our shownotes site, nosuchthingpodcast[dot]org. Already a subscriber? Please rate and review us, and tweet the showpage--https://shows.pippa.io/nosuchthing--to your network with #nosuchthingpodcast. See acast.com/privacy for privacy and opt-out information.

Excel Webinars are a great way to learn the different features within Microsoft Excel for free! These Excel webinars are usually about 60 minutes long (great for lunch time learning), you can ask questions via the chat box & get your answers directly in your inbox! At MyExcelOnline we have free Excel webinars on Pivot Tables and Power Query/Get & Transform!  These have been viewed by more than 20,000 people and have helped them get better at Excel! You too can join our free Excel webinars by clicking on the link below and receive your bonus cheat sheet:

Ben Lindbergh and Jeff Sullivan talk to 17-year-old Jack Dumoulin, the first American winner of the Microsoft Excel World Championship, about how baseball stats helped him get good at spreadsheets, his high-school baseball career, how he won the championship, and his dream of working for an MLB team. Then Ben and Jeff answer listener emails […]

Derek and Sean talk through some complex SQL before they examine the calluses developed from years of writing software on OS X. Press 1 for Lobby Ransack EXTRACT Pivot Tables crosstab Derek's crosstab Query Window Functions Set Returning Functions Uninstall All Installed Gems on OS X

In the 54th session of Chandoo.org podcast, let's make you awesome in Pivot Tables. What is in this session? In this podcast, Quick updates Top 10 pivot table tricks Adding same value field twice Tabular layouts GETPIVOTDATA & 2 bonus tricks Relationships & data model One slicer to rule them all Show only top x values Relative performance Show unique count Spruce up with conditional formats Not so ugly pivot charts Resources & Show notes for you The post CP054: Top 10 Pivot Table Tricks for YOU appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

Scott explains how using Excel pivot tables makes it so much easier to get insights about your data. The TCV of our users with a grade of F is higher then people with a C grade. So there's opportunity there!

In this Excel Pivot Table tutorial you will learn the Top 10 Tips when using a Pivot Table for Microsoft Excel 2013, 2010 or 2007  - for Beginners or Advanced users.   I am using Excel 2013 in this tutorial but you can also apply what I teach in Excel versions 2010 and 2007.DOWNLOAD THE FREE EXCEL WORKBOOKS FROM THIS VIDEO: http://1drv.ms/1GgFEL8  SIGN UP TO OUR FREE WEEKLY EXCEL LESSON PLANS TO GET BETTER AT: Formulas, Pivot Tables, Charts, Analysis, Shortcuts plus more here: http://myexcelonline.com/blog/signupTo access more than 200+ Excel Pivot Table tutorials click to view my comprehensive Pivot Table Online Course: http://www.myexcelonline.com/107-2.htmlIn no time you will be able to analyze lots of data and tell a story in a quick and interactive way, learn how to build stunning Excel Dashboards and get noticed by top management & prospective employers.You can jump to the following sections within this Excel Pivot Table tutorial by clicking on the time links below:1:19  *** TIP #10 - EXCEL TABLES ***  5:30 *** TIP #9 - AUTO REFRESH ***7:37 *** TIP #8 - COUNT TO SUM ***9:59 *** TIP #7 - NUMBER FORMATTING ***11:44 *** TIP #6 - DRILL DOWN IN A PIVOT TABLE ***13:17 *** TIP #5 - SORT FIELD LIST FROM A TO Z ***14:40 *** TIP #4 - FORMAT PIVOT TABLE ERRORS ***16:16 *** TIP #3 - FORMAT PIVOT TABLE EMPTY CELLS***17:41 *** TIP #2 - LOCK COLUMN WIDTHS ***18:37 *** TIP #1 - SHOW REPORT FILTER ON MULTIPLE SHEETS ***23:51 *** BONUS #1: FREE WEEKLY EXCEL TIPS NEWSLETTER ***http://myexcelonline.com/blog/signup24:59 *** BONUS #2: XTREME EXCEL PIVOT TABLE ONLINE COURSE ***http://www.myexcelonline.com/109-2.htmlMyExcelOnline BLOG (200+ FREE Excel tutorials): http://www.myexcelonline.com/blogMyExcelOnline PODCAST: http://www.myexcelonline.com/podcastGet the Excel Insights From The Excel Experts!If you have any questions, please email me at john@myexcelonline.com

The Xtreme Pivot Table online course is my flagship Excel course which has 14 different chapters, over 200 short video tutorials and around 10 hours of content. I discuss the different topics that are covered in this course and the benefits that you get and I also provide a special discount coupon for you!

Pivot Tables, Excel improvements, dynamic charts, highlight numbers

In this Excel Pivot Table tutorial you will learn how to build an Excel Dashboard using a Pivot Table, Pivot Chart and Slicers in under 3 minutes!Watch more free videos and view my comprehensive Excel Pivot Table course which has 200+ tutorials: http://www.myexcelonline.com/109-2.htmlThis tutorial can also be used in Excel 2013 and Excel 2007 (Slicers not available in Excel 2007 and Excel for Mac)Download Excel Dashboard Workbook: http://1drv.ms/1GgQaRLSIGN UP TO OUR FREE WEEKLY EXCEL LESSON PLANS TO GET BETTER AT: Formulas, Pivot Tables, Charts, Analysis, Shortcuts plus more here: http://myexcelonline.com/blog/signupMyExcelOnline PODCAST: http://www.myexcelonline.com/podcastGet the Excel Insights From The Excel Experts!Email me: john@myexcelonline.com

In this Excel Pivot Table 2010 tutorial you will learn the basics of building a Pivot Table to more advanced Pivot Table commands like creating a Dashboard with Slicers and Pivot Charts.DOWNLOAD EXCEL WORKBOOK: http://1drv.ms/1ElBsULWatch more free videos and view my comprehensive EXCEL PIVOT TABLE COURSE which has 200+ tutorials: http://www.myexcelonline.com/109-2.htmlAfter this free tutorial you will be a able to use Excel Pivot Tables confidently at your work, make insightful business analysis and create interactive Management Reports & Dashboards.  This  will make you more important and extend the reach of your work to a lot more people than before, which means a greater opportunity for a promotion.This Excel tutorial can also be used in Excel 2013 and Excel 2007 (Slicers not available in Excel 2007 and Excel for Mac)Jump to the Pivot Table tutorial topic you want to view by clicking on the numbers below:  2:40  CREATE A PIVOT TABLE;14:20  FORMAT A PIVOT TABLE;18:00  SUMMARIZE WITH VALUES;20:30  SHOW VALUES AS YTD & DIFFERENCE FROM   PREVIOUS MONTH;28:10  GROUPING;35:15  SLICERS & PIVOT CHARTS & DASHBOARDS;46:00  PIVOT TABLE TIPS;55:40  XTREME PIVOT TABLE COURSE STRUCTUREDownload Course Syllabus: http://myexcelonline.com/descargas/xtreme-pivot-table-course-syllabus.pdfSIGN UP TO OUR FREE WEEKLY EXCEL LESSON PLANS TO GET BETTER AT: Formulas, Pivot Tables, Charts, Analysis, Shortcuts plus more here: http://myexcelonline.com/blog/signupMyExcelOnline PODCAST: http://www.myexcelonline.com/podcastGet the Excel Insights From The Excel Experts!Email me if you have any Excel queries: john@myexcelonline.com 

There is a free site that will help you develop your support and resistance levels. When calculating pivot points, the pivot point itself is the primary support/resistance level. This means that the largest price movement is expected to occur at this price. The other support and resistance levels are less influential, but may still generate significant price movements. Pivot points can be used in two ways. • The first way is for determining the overall market trend. If the pivot point price is broken in an upward movement, then the market will be bullish and vice versa. Keep in mind, however, that pivot points are short-term trend indicators, useful for only one day, then you need to be recalculate for the next trading session.

In the 18th session of Chandoo.org podcast, lets loose your Pivot table virginity. Note: This is a short format episode. Less time to listen, but just as much awesome. What is in this session? Pivot tables are a very powerful & quick way to analyze data and get reports from Excel. But surprisingly, not many use them. Today, lets bust your pivot table virginity and understand the concepts like pivoting, values, labels, filters, groups and more. In this podcast, you will learn, Announcements What is a Pivot Table? Example of business data & reporting needs Key pivot table terms to understand Creating your first pivot table Learning more about pivot tables The post CP018: Dont be a Pivot Table Virgin! appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

In this episode, after Net News Wire's sad decline, we look at RSS app replacements, we also look at a free alternative to MobileMe and, with Snow Leopard on the horizon, we give you some top tips to help you prepare for the upgrade. BackBites Evernote Address Book to have Social networking integration? LogMeIn iFooty notifications iPhone photo fiasco ChatBites MailRaider Fruux Organizing Apps on Your iPhone Software Review Vienna NewsFire Google Reader Fluid Icon from Flickr Fluid group Send to Evernote from Google Reader Save a Google Reader story as a PDF Newsstand for the iPhone (iTunes link) Google Reader for the iPhone Google Reader - Mobile version Elaine's System Build Checklist Feedback & Comments Thanks to everyone else who commented on Twitter and contacted us via the website Competition Win a copy of BusyCal Events The next MacBites Live event is on 27th August (20:00 BST) when Mike's going to be showing you some practical examples of Pivot Tables in Excel. See http://www.digital-iq.co.uk for details of this and all our other events. To attend the event go to http://www.macbites.co.uk/live We're having a social event on 17th September. This will take place at The Old Pelican Inn, Manchester Road, on the Sale/Timperley border.

In this episode Outlook comes to the Mac, shelving comes to the iMac, we take an indepth look at the OSX address book. And we announce the winner of our Voila competition BackBites LogMeIn (Anthony uses Rescue for break fix and Remote for servers) Screen sharing in Skype Exploding iPods iFooty InfoPanel in BusyCal ChatBites BackPack for iMacs Outlook for the Mac Snow Leopard nearing release? iPhone banking app Software Review Address book A to G Importing Google contacts into Address Book O2M Feedback & Comments Thanks to everyone else who commented on Twitter and contacted us via the website Competition Congratulations to isabelle304 who has won a copy of Voila Events The next MacBites Live event is on 27th August (20:00 BST) when Mike's going to be showing you some practical examples of Pivot Tables in Excel. See http://www.digital-iq.co.uk for details of this and all our other events. To attend the event go to http://www.macbites.co.uk/live We're having a social event on 17th September. This will take place at The Old Pelican Inn, Manchester Road, on the Sale/Timperley border.