Microsoft Excel - Dashboards

Full Details
Provider
Level
Price
Common Core
Images
No items found.

Take your Excel skills to a whole new level by learning how to build dynamic Excel dashboards to show off your data. This online course will teach you the data visualization skills you need to design any dashboard in Excel exactly the way you want.

You should come to this course with a comfort level of building IF functions at a minimum, and knowledge of Pivot Tables is an asset, but not a requirement. At the end of the course, you will have gained the practical skills you need to create beautiful, functional and interactive Excel dashboards.

Highlights:

  •     42 practical tutorials.
  •     Understand the goals of data visualization.
  •     Learn to use conditional formatting, from data bars to icon sets to add finesse to your dashboard.
  •     Review the Excel logic functions which are key to adding dynamics to your dashboard.
  •     Explore the 5 rules of effective charting.
  •     Start by building bar charts, column charts, pie charts and line charts to display your data.
  •     Build more complex charts like scatter plots, combination charts and more to really tell your story.
  •     Add interactivity to your dashboard with the MATCH () and INDEX () functions.
  •     Leverage pivot tables within your dashboard to add even more interactivity.
  •     Learn “black magic” dashboarding tricks, like using Emojis and VLOOKUP to further enhance your data.
  • Video tutorials are recorded in Microsoft Excel 2016 for PC. Learn more about how a GoSkills Excel certification can boost your career.

    Want to be a more efficient Excel user? Start learning 200 of the best Excel shortcuts for PC and Mac.

    Once enrolled, our friendly support team and tutors are here to help with any course related inquiries.

    Full Details
    Formats: 
    Part of resource: 
    Posted 
    Aug 2023
    This resource has religious influence.

    Similar resources

    About GoSkills

    Our unique approach to learning

    As pioneers of microlearning, we’ve been creating bite-sized courses since 2013. Our unique ‘GoSkills format’ includes a 3-5 minute video, an exercise to apply your knowledge, and a short quiz for every lesson.

    This data-backed approach works, increasing retention rates by 20% and learning speeds by 28%. GoSkills also has one of the highest completion rates in the industry.

    Here’s what our customers say:

    “Perfect bite-size lessons that were brief and to-the-point, well thought out to build on key skills, with great exercises to build "muscle" memory, and solid quizzes that hone important points.”

    “Love the bite sized modules! Easy to squeeze one or two in when I have time.”

    “I liked that the lessons covered one thought at a time, in small bites.”

    Our simple and easy-to-use online training platform empowers managers to create bite-sized and interactive learning programs for their teams, so they can achieve the same results.

    We help individuals grow their career

    Our subscribers have access to over 100 bite-sized courses taught by leading industry experts. By learning the most sought after business and technical skills, we help individuals stand out in the job market and find confidence at every stage of their career.

    More by GoSkills

    thumbnail
    Introduction to Tableau
    Introduction to Tableau
    College & Adult
    thumbnail
    Illustrator - Advanced
    Illustrator - Advanced
    College & Adult
    thumbnail
    Illustrator - Basic
    Illustrator - Basic
    College & Adult
    thumbnail
    Photoshop - Advanced
    Photoshop - Advanced
    College & Adult
    thumbnail
    Photoshop for Beginners
    Photoshop for Beginners
    College & Adult
    thumbnail
    Intro To C# Programming
    Intro To C# Programming
    College & Adult