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

Excel Charting, Graphing and Data Visualisation

Standout in your next meeting and bring your reports to life using icon sets and colour scales! Learn how to efficiently make charts and graphs in Excel, using just one keystroke.

Join Mr Excel as he shares best practices for Excel Charting, Graphing and Data Visualisation. He will also demonstrate the use of Sparklines to create work-sized charts and more...
Recorded May 2 2017 60 mins
Your place is confirmed,
we'll send you email reminders
Presented by
Bill Jelen, host of MrExcel.com
Presentation preview: Excel Charting, Graphing and Data Visualisation

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
  • Fast, not Furious! How to accelerate your SAP period-end close. Recorded: Oct 26 2017 51 mins
    Nicholas Gerber, Excel4apps Client Manager & Simon Parkes, SAP Solution Engineer
    Are you an SAP user? Are you feeling robbed of valuable execution time at month end due to laborious, time-intensive processes and complex tools? Do you rely on Excel during this tedious and stressful time, but find it to be too manual and inefficient? If so, you’re not alone!

    Join Excel4apps for a guided tour into a typical SAP period-end process, its challenges and suggested ways to improve and streamline standard methods. Learn automation techniques and how you can leverage Excel-based tools to cut reporting time in half!

    What you will learn:
    -How connecting SAP to Excel directly can drive significant benefit for the business and users.
    -Shorten period-end close to improve business KPIs and make finance teams happy again!
    -Avoid continual re-work and duplication - never export to Excel again!
    -Improve decision-making by having more time to analyse your data
    -Remove reliance on IT at this critical time and allow Finance to build reports themselves for ad hoc enquiries
    -Make adjusting and loading journals less of a headache
    -Manage the close process from real-time Excel.

    If you are a Finance or Accounting Professional or in IT supporting SAP and Finance and want to learn more about how you can achieve a faster, smarter and easier period-end process, then don’t miss this webinar
  • Fast, Not Furious. How to Accelerate Your Oracle EBS Period-End Process. Recorded: Oct 12 2017 50 mins
    Nick Gerber - Client Development Manager, David Rincon - Oracle Solution Consultant
    Are you feeling robbed of valuable execution time at month end due to laborious, time-intensive processes and complex tools? Do you rely on Excel during this tedious and stressful time, but find it to be too manual and inefficient? If so, you’re not alone!

    Join Excel4apps for a guided tour into a typical Oracle EBS period-end process, its challenges and suggested ways to improve and streamline standard methods. Learn automation techniques and how you can leverage Excel-based tools to cut reporting time in half!

    What you will learn:
    -Shorten period-end close to improve business KPIs and make finance teams happy again!
    -Avoid continual re-work and duplication - never export to Excel again!
    -Improve decision-making by having more time to analyse your data
    -Remove reliance on IT at this critical time and allow Finance to build reports themselves
    -Make adjusting and loading journals less of a headache
    -Manage the entire close process from real-time Excel.

    If you are a Finance or Accounting Professional wanting to learn more about how you can achieve a faster, smarter and easier period-end process, then don’t miss this webinar!
  • How to Simplify Your SAP Project Reporting… (and Your Life Too!) Recorded: Sep 14 2017 47 mins
    Nick Gerber - Client Development Manager, Simon Parks - SAP Solution Consultant
    How easy is to keep track of multiple Enterprise Projects within your business? Do you find it easy to get the information you need out of SAP? Or do you frequently rely on data downloads and reformatting to make sense of the data, leading potentially to errors and out-of-date reports?

    Join us next week for a webinar on how you can easily simplify your SAP Project Reporting with Real-Time Reporting in Excel.

    What you’ll learn:
    •Use your favourite tool, Excel, for reporting on Enterprise Projects
    •Achieve 1 Single Version of the truth in Excel
    •Easily build Excel templates that refresh with Real-Time data instantly
    •Easily build and refresh Project Dashboards and summary reports
    •Eliminate Spreadsheet Risk such as spreadsheet errors and version control issues
    •Personalise report templates to Accommodate Different Stakeholders
    •Report on Transactional Data, Master Data, and more in Excel
    •Ability to Drill Down on transactional data, giving you true insights into the figures.

    Excel4apps uses the SAP authorisation user-IDs and profiles, it’s deployed quickly and with little training needed. It allows businesses to easily keep their finger on the pulse of multiple projects by providing real-time data to all stakeholders when and how they need it.

    Attend this webinar if you are a Financial Analyst or a Project Manager looking to simplify your project reporting…and your life too!
  • MrExcel's 40 Best Excel Shortcuts of All Time Recorded: Aug 31 2017 67 mins
    Bill Jelen, Mr Excel; Nick Gerber, Excel4apps
    Would you like to learn the best Excel shortcuts of all time? Then, join Mr Excel. He will take you through his top 40 Excel shortcuts you can’t live without!

    Knowing Excel shortcuts can not only save you time, but it will increase your efficiency at work, making you look like a pro! In this webinar, Bill Jelen - known as MrExcel - will take you through his all time favourite shortcuts. After the webinar, receive a handy one-page summary that you can keep by your desk to remind you of all the great tips and tricks that you could be using.

    What you’ll learn:
    •Navigate quickly in Excel, both within and between worksheets
    •Format cells in Excel
    •Select large data sets in Excel
    •Enter formulas quickly
    •Create perfect charts in 1 keystroke
    •Plus 35 more shortcuts!

    Attend this webinar if you are a Finance or Accounting professional and/or are interested in improving your Microsoft Excel skills to the next level.
  • Part 2: What Does the Move to S4/Hana Mean for Business Functions & Reporting? Recorded: Aug 16 2017 12 mins
    Richard Sampson, Managing Director, Excel4apps
    Part 1 of this two-webinar series looked at the strategic challenges facing organisations using SAP following the launch of SA/Hana. This part 2 focuses instead on the departmental challenges, and what these developments might mean for operational reporting. In many organisation today, the reality of the reporting environment might means that experienced business users spend 80% of their day manipulating data rather than interpreting it. So, while your CFO might quite rightly be looking at S4/Hana and digitalisation, we would encourage businesses to also Fix Today’s Problems Today, as the real-time access to data discussed in this webinar will not only support but accelerate your path to digitalisation.
  • Part 1: The Move to S/4Hana and the Impact to the Business of “Strategic IT” Recorded: Aug 16 2017 13 mins
    Richard Sampson, Managing Director, Excel4apps
    This webinar focuses on some of the challenges facing organisations using SAP today. There's a lot of noise in the marketplace following the launch of S4/Hana. What does it mean for organisations? How may SA/Hana impact IT and Finance and what does it mean for reporting? Perhaps, most importantly, how can businesses address these challenges so that they are able to improve performance today while safeguarding their investment for the future? This presentation looks at how businesses can fix today's problems today, while also planning for tomorrow.
  • How to Manage Spreadsheet Risk from Within your SAP Environment Recorded: Jul 19 2017 51 mins
    Richard Sampson - Managing Director Europe, Simon Parkes - SAP Solution Engineer
    Are you frustrated at the mainly standard, readily structured reports available in SAP? Are you still using Excel to do a lot of the ‘heavy lifting’ reporting? 
     
    Regardless of IT policy, Excel is still the go-to-tool for most users to transform their data into something meaningful. Yet, static spreadsheets inherently create issues around version control, complex cross referencing, master data references and calculation errors, all of which is an Audit Risk. The responsibility for this tends to fall between the Business and IT and can become a necessary evil.

    Attend this webinar to hear how you can overcome these issues using an Excel add-in from Excel4apps.

    What you'll learn: 
    •Achieve a genuine Single Version of the Truth - discover how you can access live SAP data in real-time from an Excel front-end - your data remains in SAP but you view it from Excel.
    •Reduce Financial Reporting and Consolidation Time by 70% - learn how Excel4apps helps you accomplish this goal by solving many SAP Process Challenges.
    •See the Management Reporting capabilities of the award-winning GL Wand in action - be inspired to transform your period-end process.

    If you’d like to find out more about how you can manage spreadsheet risk while still using Excel for reporting, then don’t miss this webinar.
  • Filling the Gap in Oracle Reporting: Your Ultimate Financial Reporting Package Recorded: Jul 18 2017 61 mins
    Malcolm Hewlett - Oracle Practice Manager Europe, David Rincon - Oracle Solution Engineer
    Oracle reporting can be cumbersome and inefficient. Closing month end, performing ad-hoc analysis, reconciling and other reporting tasks are becoming increasingly difficult. Deadlines get shorter, executives are delayed in making critical decisions, working late becomes the norm, and frustration increases.

    Join Malcolm Hewlett and David Rincon from Excel4apps for a live webinar where you will learn how to:
    •Alleviate the pains of month-end by replacing FSGs and Web ADI
    •Prepare efficient, professional reports for business presentations and sharing
    •Eliminated dependence on IT, empower end-users, and shorten month-end processes.

    See a demo of GL Wand and Journal Wand - the ultimate Oracle Financial Reporting package - in action. A quick win for Finance teams, GL Wand and Journal Wand:
    •Decrease reliance on IT - eliminate cumbersome Oracle reporting tools like FSGs and Web ADI
    •Increase efficiency and empower end-users - automate ad-hoc reports and analysis in Excel
    •Streamline real-time data from Oracle into Excel – data is validated and refreshed at the click of a button.

    GL Wand and Journal Wand make it easy to obtain, analyse, share, and present essential information when and how you need it so you can create a 360-degree month end reporting process and wave goodbye to those late nights and weekends at the office.

    Register today!
  • How To Create Interactive Excel Dashboards from Start to Finish Recorded: Jun 20 2017 61 mins
    Bill Jelen - Host of MrExcel.com, Malcolm Hewlett - Territory Manager Excel4apps
    Impress your colleagues at your next meeting by creating striking Dashboards that engage and deliver the key information management needs at a glance!

    Join MrExcel as he takes you through all the steps to design Interactive Excel Dashboards from start to finish. He will illustrate how to best display the information that summarises key results on 1 page.

    Here's what you'll learn:
    •Create Visually Rich Dashboards that fit on 1 page
    •Provide answers to key questions at a glance
    •Design Interactive Dashboards using slicers
    •Use Power Query to prepare data for Dashboarding
    •Create tiny, Cell-Sized Charts using icons and sparklines
    •Display top 10 and Key Performance Indicators in Dashboards
    •Add Photos to Dashboards
    •Publish Dashboards to the Web using Excel on-line.

    Who'll be speaking:
    Bill Jelen is the host of MrExcel.com and the author of 43 books about Microsoft Excel including, “Pivot Table Data Crunching” and “Excel Gurus Gone Wild”. He has made over 80 guest appearances on American TV's “Call for Help” with Leo Laporte, and was voted guest of the year on the “Computer America” radio show. Before founding MrExcel.com in 1998, Bill spent twelve years "in the trenches", as a financial analyst for the accounting, finance, marketing and operations departments of a publicly held company.

    This is a free MrExcel.com webinar sponsored by Excel4apps - Excel-based Real-Time Solutions that People Love.
  • Journal Entry: Curing Common SAP Financial Pains with Excel Recorded: May 24 2017 59 mins
    Melissa Neil - SAP Product Manager, Simon Parkes - SAP Solution Consultant
    Are you or your finance users struggling with time constraints in entering manual FI/CO type entries into SAP? Are you limited by your current financial custom uploading tool? Don’t worry, there is a cure.

    Entering financial or journal entries into SAP efficiently is essential to managing all aspects of your business, yet manually keying all those entries (one line at a time) into inflexible SAP T-code entry screens can be time consuming and painful. The IT Department can build your staff a home-grown custom loader for loading journal entry information into SAP; however, these batch loaders tend to be limited and inflexible, don’t handle errors well, and require ongoing IT support and maintenance. It is merely a band aid to a larger issue.

    GLSU is an Excel add-in for uploading financial data into SAP. It streamlines financial data entry and reporting without the dependency on IT making it the ultimate cure. Additional GLSU features include:
    1. Park and Post all from Excel
    2. Sophisticated error handling and business logic
    3. Excel templates created and modified in seconds with no programming or scripting.

    Attend this webinar to learn:
    • What current SAP financial uploading tools are often used today
    • The limitations for SAP users in their current FI/CO entry process
    • How GLSU, a financial spreadsheet uploader for SAP, can help reduce the manual waste and increase efficiency.
  • Videocast: Achieving the Rolling Forecast Recorded: May 3 2017 21 mins
    Andrew Stutzman, Solution Specialist
    Rolling forecasts can be a powerful differentiator for companies striving to remain competitive. Unfortunately, most organisations can’t achieve them today. What if it didn’t have to take years, large investments and big process changes to get there? Your current technology, processes and planning models might be closer than you think.

    Topics Covered:
    0:52 - Today’s State of Budgeting, Planning, and Forecasting
    7:27 - Annual Planning Approach
    10:11 - Annual Budget vs. Rolling Forecast – What’s Better?
    12:03 - Impediments to Rolling Forecasts
    14:00 - IT vs. Business Considerations
    16:26 - Demo of Planning Scenarios in SAP-Connected Excel
    19:40 - Other SAP Solutions
  • The ERP Data Reporting Challenge Recorded: May 2 2017 3 mins
    Simon Parkes, Solution Specialist
    Business users in many organisations spend far too much time simply trying to access the data they need from their enterprise reporting systems (ERPs). Woes around reporting on that data are common place…
  • Excel Charting, Graphing and Data Visualisation Recorded: May 2 2017 60 mins
    Bill Jelen, host of MrExcel.com
    Standout in your next meeting and bring your reports to life using icon sets and colour scales! Learn how to efficiently make charts and graphs in Excel, using just one keystroke.

    Join Mr Excel as he shares best practices for Excel Charting, Graphing and Data Visualisation. He will also demonstrate the use of Sparklines to create work-sized charts and more...
  • SAP Planning & Posting with the Ease of Excel Recorded: Apr 26 2017 49 mins
    Richard Sampson - Managing Director Europe, Simon Parkes- SAP Solution Specialist
    Planning, Budgeting and Forecasting processes are critical to the success of the business and key in aligning day-to-day activities with long-term strategy.

    Creating and maintaining your Plans manually in Microsoft Excel® is highly popular with many SAP organizations, but requires considerable time and effort. Rolling forecasts are an additional challenge when using Excel, again due to both the time and costs involved. Tight budgets, reduced funding and the prioritisation of resources and assets add to the complexity of the overall challenge.

    In this webinar we will discuss and demonstrate live how you can now connect Microsoft Excel directly to SAP to make your Planning process far easier and be better prepared for uncertain business changes such as Brexit.

    What we will cover:
    •Understand how the Excel4apps add-in enables direct plan posting into FICO
    •Retrieve financial and non-financial data from SAP in real-time to report on actuals and budget via Excel
    •Shorten the Planning Process by automating the distribution of plan templates and real-time actuals
    •Achieve Rolling Forecasts with the tools you already have.
  • Enhanced Sub-Ledger Reporting & Discoverer Replacement Recorded: Apr 19 2017 59 mins
    Malcolm Hewlett - Oracle Territory Manager Europe, David Rincon - Oracle Solution Specialist
    Many Oracle users are struggling with sub-ledger reporting or are looking for a replacement for Oracle Discoverer. In this webinar you’ll learn how to:

    1. Facilitate a conversation with your data with easy drill through to transactions across the full E-Business Suite.
    2. Better control your sub-ledger processing with control dashboards identifying open, on hold and triggering transactions.
    3. Automate reconciliations between sub-ledger and GL control accounts e.g. Fixed Asset Register.

    We offer a unique Excel connector, meaning you can have access to real-time E-Business Suite sub-ledger data directly from Excel. In addition, the availability of 1000+ out-of-the box reports means getting started is easy.
  • Introducing Journal Wand: Achieving the 360° Month End Close Process Recorded: Apr 11 2017 58 mins
    Malcolm Hewlett - Oracle Territory Manager Europe, David Rincon - Oracle Solution Specialist
    Loading journals into the Oracle E-Business Suite can be complex, and to make matters worse, your current tool may be difficult to use and provide weak error messaging, contributing to inefficiencies and frustration.

    Are you feeling robbed of valuable execution time during month end due to cumbersome journal upload tools and processes?

    Join us for this webinar to see how easy it is to upload journals to the Oracle E-Business Suite General Ledger using Journal Wand, the latest innovation from Excel4apps. When combined with GL Wand, it provides a 360° Excel solution to the GL month end process, giving users the ability to report, analyse, and adjust journals directly from sheets containing real-time data.

    What this webinar will cover:
    •Real-life examples – hear how our customers are utilising Journal Wand as an alternative to Web ADI or combining Journal Wand with GL Wand
    •Customizable Excel templates - amend and share journal templates on the fly to accommodate unique processing requirements, all within Excel
    •Data validation before loading - prevent invalid or unbalanced journals from loading into the Oracle GL with cell-specific error messaging and data validation.
  • Budgeting: Can you really make Rolling Forecasts a reality? Recorded: Mar 22 2017 44 mins
    Alex Hodges - Head of SAP Practice Europe, Simon Parkes- SAP Solution Specialist
    Is budgeting and forecasting a labour intensive and time consuming process? Is your planning model ready to deal with the growing political and economic uncertainty? If the answer to either of these questions is yes, then this webinar will be of interest to you.

    Many leading organizations are now moving towards a continuous planning and strategy cycle, providing more accurate forecasting and cost control. Up until now, this has meant purchasing more costly software with the associated implementation and change management costs.

    Join us for this webinar to learn how your organization can easily achieve the rolling forecast using the tools you already have; ultimately saving time, reducing process costs, and substantially improving efficiency.

    What this webinar will cover:
    •The need for Continuous Planning will impact all UK organisations over the next 2 years
    •The advantages of a Rolling Forecast vs. an annual budget approach
    •Common obstacles to Rolling Forecasts and how they can be overcome
    •Business vs. IT priorities when considering planning solutions
    •A live demo of Continuous Planning Scenarios in SAP-Connected Excel.

    Making the rolling forecast a reality might be easier than you think. Join us for this webinar to find out how it can be achieved within your organisation.
Excel-based reporting and budget loading software.
Are you a Finance or ERP professional looking at starting real-time conversations with your data? Do you love Excel? Then you’ll love us! Excel4apps provides the power of Excel as an interface to live ERP data without programming support, data exports, errors and waiting.

Embed in website or blog

Successfully added emails: 0
Remove all
  • Title: Excel Charting, Graphing and Data Visualisation
  • Live at: May 2 2017 9:00 am
  • Presented by: Bill Jelen, host of MrExcel.com
  • From:
Your email has been sent.
or close