Hi [[ session.user.profile.firstName ]]

MrExcel Webinar: New Year, New Excel Tips

Welcome to a new year with insightsoftware! We will continue to revolutionise your financial reporting through inviting you to some exciting webinars showcasing reporting tips & tricks from a variety of solutions that we offer.

Kick off 2019 by advancing your Excel skills! Join Bill Jelen a.k.a, MrExcel as he talks about the amazing new features announced for Office 365 editions of Microsoft Excel.

Finance and accounting professionals or anyone interested in improving their Microsoft Excel skills are encouraged to attend.
Recorded Mar 13 2019 57 mins
Your place is confirmed,
we'll send you email reminders
Presented by
Bill Jelen - a real-life Excel expert. Bill has over 29 years of spreadsheet experience.
Presentation preview: MrExcel Webinar: New Year, New Excel Tips

Network with like-minded attendees

  • [[ session.user.profile.displayName ]]
    Add a photo
    • [[ session.user.profile.displayName ]]
    • [[ session.user.profile.jobTitle ]]
    • [[ session.user.profile.companyName ]]
    • [[ userProfileTemplateHelper.getLocation(session.user.profile) ]]
  • [[ card.displayName ]]
    • [[ card.displayName ]]
    • [[ card.jobTitle ]]
    • [[ card.companyName ]]
    • [[ userProfileTemplateHelper.getLocation(card) ]]
  • Channel
  • Channel profile
  • Higher Ed Reporting: Fast, Easy, Accurate – All in Excel Jul 14 2020 1:00 pm UTC 51 mins
    Sue Maloney, Senior Solution Engineer at insightsoftware
    With business Unusual, there’s no time for slow, inaccurate reporting. insightsoftware’s Spreadsheet Server is the solution that gives you Excel-based access to real-time data that refreshes at the click of a button, providing drill-down to journal-level detail. Do away with manual, time-consuming reporting processes. No more relying on IT, manually dumping data into spreadsheets, or back and forth between your ERP and Excel.

    In this session, you will learn how to:

    - Eliminate manual reporting
    - Connect directly to your ERP data right in Excel
    - Drill down to see the data behind any number
  • Empower Your Remote Finance Team with Excel Based Reporting Recorded: Jun 25 2020 19 mins
    Kevin Gibson, Senior Solution Engineer
    Finance teams are needing to provide answers to challenging questions which often require new reports and the ability to analyze data in new ways. Working remotely has added a layer of complexity as many finance users rely on IT to build new reports and drill to the information they need.

    Now, more than ever, you need the right tools to be successful. See how to:

    - Access real-time data from your ERP using Excel
    - Build your own refreshable reports without IT help
    - Quickly provide answers to today’s (and tomorrow’s) questions
    - Drill down to the detail you need to answer key questions
  • CFO Panel | How to Navigate Your Business Through This Uncertainty Recorded: Jun 10 2020 45 mins
    David Woodworth – CFO, insightsoftware
    As global concern about the COVID-19 outbreak continues, businesses around the world are under tremendous additional pressure to adapt to a quickly shifting situation. Watch our on-demand webinar where you’ll hear from leading Finance executives and advisors about how they’re managing their businesses through this period and what advice they have for other businesses facing similar challenges. Topics include:

    - What should CFOs be doing to maximize their effectiveness and influence?
    - How do the impacts of COVID-19 compare to prior crises?
    - How do you put scenario models into action?

    Panelists include:

    - David Woodworth – CFO, insightsoftware
    David is the chief financial officer at insightsoftware. Most recently, he held CFO roles at Trilliant and M Modal after beginning his career at Ernst & Young. He focuses on driving value in strategic direction, operational organization, and financial recapitalization.

    - Brian Shaw – CFO, Discovery Education
    Brian is the chief financial officer at Discovery Education. Most recently, he held senior finance roles at Red Ventures and Time Warner Cable after beginning his career at Ernst & Young.

    - David Coles – Managing Director, Alvarez & Marsal
    David is a managing director with Alvarez & Marsal North America Commercial Restructuring. He has more than 25 years of financial restructuring experience and has deep experience working with executive teams in senior advisory and interim C-suite roles.

    - Gary Michel – Strategic Advisory Board, Genstar Capital
    Gary is a member of Genstar’s Strategic Advisory Board, working with portfolio companies to improve financial leadership and operational performance. Previously, he held CFO roles at TravelClick and Register.com.
  • 5 Ways to Knockout Time from Your Oracle Subledger Reporting Recorded: Dec 17 2019 51 mins
    Gregg van der Westhuizen
    Do you feel like your Oracle E-Business Suite (EBS) financial and operational reporting is more complex and time-consuming than it should be? Are even supposedly simple drill-downs unnecessarily manual and difficult?

    If this sounds like you, watch this webinar where you can experience how Excel4apps Wands knocks Oracle reporting out in a head-to-head comparison of common financial and operational reporting tasks. See how you can easily reduce your reporting time by up to 70% and improve your data accuracy and security with a direct connection between Oracle EBS and Excel.

    Join Gregg van der Westhuizen, senior solution engineer, as he takes you through five rounds of easy productivity gains with examples from Procure to Pay and Invoice to Cash:

    Round 1 – Drill down to a live Account Analysis report in Excel to analyze subledgers
    Round 2 - Reconcile Accounts Payable trial balance to General Ledger
    Round 3 - Drill down to detail and compare transactions between General Ledger and Accounts Payable
    Round 4 - Use pre-built report templates to create refreshable intuitive Accounts Payable and Accounts Receivable dashboards in Excel
    Round 5 - Deployment of reports to allow for team collaboration

    This is one show you won’t want to miss!
  • What’s New in Excel for Financial Professionals Recorded: Dec 12 2019 57 mins
    Microsoft has announced several new calculation functions for Excel, from a better XLOOKUP function to new dynamic array functions SORT, FILTER, UNIQUE, and SEQUENCE, to a new geography and stock function FIELDVALUE. While these functions are already in Excel for Office Insiders, you should expect them to arrive in your subscription of Office 365 soon.

    During this one-hour webinar, Mr Excel will demonstrate:

    •How XLOOKUP is faster and less error-prone than VLOOKUP
    •XLOOKUP's ability to return all 12 months in a single formula, which is exciting enough to make the INDEX/MATCH people switch
    •How to return geography and stock price information using FIELDVALUE
    •Sort and filter with a formula using SORT, FILTER, and UNIQUE
    •How the lowly SEQUENCE function will super-charge all calculation functions in Excel.

    Register today to save your seat an learn how to excel in these new releases.
  • Business partnering: Delivering strategic value & empowering careers Recorded: Nov 27 2019 48 mins
    Ernie Humphrey
    The role of financial professionals is changing at an incredible speed thanks to new technology such as automation and artificial intelligence. Repetitive and low-value tasks are disappearing, meaning that new opportunities are opening for finance personnel to shape their own professional life.

    In this webinar, we will talk about how to best prepare for the future and flourish in the new role using business partnering and your unique knowledge of the business to drive through change and make a difference.
  • Lucy Group: Transforming reporting processes in Hyperion and OneStream Recorded: Nov 18 2019 27 mins
    Guy Hill, Group Reporting Manager at Lucy Group
    Do you feel the panic as the end of the month approaches? Does your team turn into shadows of themselves, working night and day to manage the month-end close?

    That was the situation for the British multi-national Lucy Group. The team were trapped in repetitive and manual reporting processes. The financial function felt more like report creation on auto-pilot with no time to add value to the business with in-depth analysis. They were creating 100-page static reports that were sent by post to their business units abroad.

    But times have changed at Lucy Group and now they create reports with just a mouse-click, and all their old reports have transformed into dynamic dashboards. Reports are sent to the business units abroad digitally within seconds.

    Learn more about Lucy Group’s journey to automated reports with drill-down capabilities and real-time updates in this 30-minute-long webinar.
  • 5 Reasons to Love Your JD Edwards Reporting as Much as You Love JDE Recorded: Nov 13 2019 32 mins
    John Brooks
    Do you love JD Edwards for it's flexibility and ease-of-use? But, do you wish its reporting was just as flexible and easy?

    Don't miss this webinar to discover 5 ways that Hubble, insightsoftware's purpose-built JDE reporting solution, can give you the reporting you've always dreamed of:
    •Day one time-to-value with an extensive library of JDE-specific content
    •Drillable, real-time data instead of static snapshots in Excel
    •Freedom from JDE silos, with multiple data views
    •An end to manual data mapping
    •IT independence and governed reporting

    Register today to see how Hubble's JDE smarts can help you hit your strategic goals.
  • Challenges with Oracle BI - 5 Ways to Resolve the Gaps Recorded: Oct 22 2019 61 mins
    Malcolm Hewlett
    Are you an Oracle BI user? Have you experienced challenges with the changes recently announced? Or, are you trying to get the most out of your Oracle BI products? Join us for this hour-long conversation with two Oracle experts to help resolve five big challenges with Oracle BI.

    Sign up for "Challenges with Oracle BI - 5 Ways to Resolve the Gaps" to learn:
    •How do all the Oracle products interface with one another
    •What some challenges with Oracle BI reporting are, including not real-time and heavy reliance on IT to build reports
    •How you can resolve Oracle BI gaps easily and inexpensively
  • Leveraging Excel in Financial Reporting to Deliver Data Truth Recorded: Oct 17 2019 46 mins
    Ernie Humphrey
    Is it possible to achieve data truth with Excel? 

    Join us for a webinar to discuss what it means in theory and how it works in practice. What are the challenges financial professionals face in their day-to-day life to guarantee accurate data? Hours spent on gathering data to make sure they have the latest numbers; resulting in too much preparation and too little time to do the analysis. 

    In this webinar you will get some hands-on tips and tricks to help you champion your next month-end close.
  • Top 10 Steps to Adopting Financial Technology Recorded: Sep 24 2019 58 mins
    Chris Walsh
    New software can be both expensive and time-consuming to implement. Once in place, they are, normally, with you for a long time.
    Therefore, it’s important to do the research and ground work before deciding what solution to choose. Identifying your pain points, achieving your ideal solution and evaluating possible providers, it’s all easier said than done. That’s why we want to share our expertise and provide you with some important advice along the way.
    Check out our easy-to follow top 10 steps to implement financial software to help you migrate to a successful software adoption.
  • Are you using Unsupported Oracle Discoverer? Recorded: Sep 10 2019 60 mins
    Robyn White and Gregg Van Der Westhuizen
    With Oracle Discoverer being discontinued, do you have an alternative solution in place yet? If you're still looking for an answer, join our free webinar to learn about two incredibly powerful alternatives for Oracle Discoverer: insightsoftware's Hubble and Excel4apps Wands.

    During this webinar, Oracle expert Gregg Van Der Westhuizen will walk you through the features and benefits of Excel-based reporting and web-based dashboards. You'll learn about:

    - How customers have saved time and successfully moved from Discoverer
    - How these tools complement your existing OBIEE or BI strategy
    - What your Discoverer reports will look like for each solution
    - Analyzing and consolidating your Discoverer reports before converting them to a new solution
  • Bringing Your Financial Data to Life Recorded: May 30 2019 54 mins
    Bill Jelen
    Bill Jelen aka MrExcel shows finance users how to bring your financial data to life with these 6 Excel tips.
  • Are ERPs moving you further from decision-making with all those spreadsheets? Recorded: May 23 2019 60 mins
    Lance Rubin
    Are you still faced with more spreadsheets post-ERP implementation than promised? If yes, then you are not alone. ERPs do solver some - but not all - of your financial reporting problems, are more often than not, result in users creating more spreadsheets to close the reporting gap that hasn't been fulfilled. Join Lance Rubin - Financial Modelling expert - as he discusses how these issues can be resolved with the right tools for your finance team.
  • Unlock you Oracle data abyss by leveraging Sub-Ledger Accounting Recorded: May 23 2019 55 mins
    Gregg van der Westhuizen
    Sub-Ledger Accounting (SLA) has a reputation for being complex and rigid, but there are so many ways you can make it work for you.
    Lean how to configure SLA to improve your financial reporting, and explore how SLA updates feed into your reporting and drill-downs.
  • Hubble vs. JD Edwards Reporting Tools Recorded: May 21 2019 33 mins
    John Brooks
    Are you frustrated with your current JD Edwards reporting tool? Are you tired of waiting for IT to make updates? Have you had enough of waiting for reports to run in batch?

    If so, join our Product Specialist, John Brooks, for a 30-minute webinar on October 10, to discover why Hubble offers you a better way of reporting against JD Edwards.

    Hubble provides:
    •Hundreds of pre-built templates that allow you to immediately access unlimited amounts of JDE data, any way you like
    •A solution built for end-users so you don't need IT's help to build reports
    •A faster way to build reports, even against larger transactional data volumes
    •JDE integration with your existing security and allows you to drill-down in real-time from summaries to transactions to fix data integrity and reconciliation issues immediately
    You'll see live demonstrations, customer examples, common issues JDE customers experience with OVR and why Hubble is your ultimate alternative.
  • Accelerate Your Month-end Close with GL Wand Recorded: May 2 2019 41 mins
    Ugesan Pillai
    Oracle reporting can be cumbersome and inefficient. Closing month-end, performing ad-hoc analysis, reconciling and other reporting tasks are becoming increasingly difficult. Join us for a webinar demonstrating how GL Wand for Oracle E-Business Suite can alleviate your reporting pains!
  • Turbo Charge your Power BI Dashboards Recorded: Apr 25 2019 42 mins
    Andrei Stefan
    Using Dynamics 365 with Power BI? Frustrated by slow query response times? Struggling to report against transactional data?

    If so, don’t miss our next webinar: “Turbo Charge your Power BI Dashboards with Atlas”.
    During this webinar, our solutions specialist will show you how Atlas for Dynamics:

    •Provides live, record level reporting against D365 data with access to 45+ additional transactional data entities – opening up a whole new world for Power BI
    •Massively speeds up D365 query response time with incremental caching – see how queries that took hours now refresh in seconds … delivering snappy Power BI visualizations that keep your business users happy
    •Combine multiple data sources to create Power BI dashboards that span D365 and on-premise legacy data
    •Improve your financial and operational reporting with real-time reporting in Excel with drill-down into journals, balances and sub-ledgers
    … and more!
  • Dynamic EPM Reporting in 15 Minutes Recorded: Mar 28 2019 26 mins
    Dan Phillips
    Do you feel like your group financial data isn't telling a clear story? Are you spending too much time creating dull, static reports and dashboards, and then recreating them each time the data changes?

    I'd like to introduce you to CXO Software. Specifically for executives and the enterprise organisations they manage, CXO Software has demonstrated significant ROI at organisations including Mercedes-Benz, McDonalds, Sage, G4s, and many others.

    Join the CXO VP of North American Sales, Dan Phillips, on 28 March for a 15-minute webinar demonstrating how CXO Software enables you to build dynamic, interactive dashboards and reports directly from your EPM data.
  • MrExcel Webinar: New Year, New Excel Tips Recorded: Mar 13 2019 57 mins
    Bill Jelen - a real-life Excel expert. Bill has over 29 years of spreadsheet experience.
    Welcome to a new year with insightsoftware! We will continue to revolutionise your financial reporting through inviting you to some exciting webinars showcasing reporting tips & tricks from a variety of solutions that we offer.

    Kick off 2019 by advancing your Excel skills! Join Bill Jelen a.k.a, MrExcel as he talks about the amazing new features announced for Office 365 editions of Microsoft Excel.

    Finance and accounting professionals or anyone interested in improving their Microsoft Excel skills are encouraged to attend.
Revolutionizing Financial Reporting and EPM
insightsoftware is on a mission to help companies turn their financial & operational data into better business outcomes that drive growth and ROI. Through their innovative, turn-key reporting and performance management solutions, insightsoftware provides users with real-time access to data-driven insights in an efficient, cost-effective and secure manner. Featuring integration support for over 130 tier 1 and tier 2 ERP systems, as well as full integration into Microsoft Excel, the company has the experience and flexibility to help business leaders unlock the power of their business data so they can understand, manage and optimize their business with ease. More information about insightsoftware can be found at www.insightsoftware.com.

Embed in website or blog

Successfully added emails: 0
Remove all
  • Title: MrExcel Webinar: New Year, New Excel Tips
  • Live at: Mar 13 2019 11:00 am
  • Presented by: Bill Jelen - a real-life Excel expert. Bill has over 29 years of spreadsheet experience.
  • From:
Your email has been sent.
or close