Need help finding the right learning solutions? Email Us: [email protected]
- Onboard For Tech Teams
- Reduce initial time to productivity.
- Increase employee tenure.
- Plug-and-play into HR onboarding and career pathing programs.
- Customize for ad-hoc and cohort-based hiring approaches.
- Upskill For Tech Teams
- Upgrade and round out developer skills.
- Tailor to tech stack and specific project.
- Help teams, business units, centers of excellence and corporate tech universities.
- Reskill For Tech Teams
- Offer bootcamps to give employees a running start.
- Create immersive and cadenced learning journeys with guaranteed results.
- Supplement limited in-house L&D resources with all-inclusive programs to meet specific business goals.
- Design For Tech Teams
- Uplevel your existing tech learning framework.
- Extend HR efforts to provide growth opportunities within the organization.
- Prepare your team for an upcoming tech transformation.
Get your team started on a custom learning journey today!
Our Boulder, CO-based learning experts are ready to help!
Course Summary
The Data Analysis & Visualizations with Excel training course is designed to advance the skills of participants who are already familiar with Microsoft Excel. The era of “big data” has exploded due to the rise of cloud computing, which provides an abundance of computational power and storage, allowing organizations of all sorts to capture and store data. Analyzing data to find issues, insights and opportunities, is now a critical part of many job roles. Beyond the analysis, data analysts in all job roles must be able to effectively present and communicate their findings in visually compelling ways. Excel can connect to a wide range of data sources, perform robust data analysis and create diverse and robust data-backed visualizations to show insights, trends, and create reports.
The course begins with a review of data analysis fundamentals and then dives into visualizing and analyzing data with Formulas, functions and PivotTables. Next, students are introduced to presenting visual insights with dashboards and creating geospatial visualizations. The course concludes with performing statistical analysis, transforming data, and modeling and analyzing data with Power Pivot.
Purpose
Learn how to use Excel for data analysis to present data into visual insights.
Audience
Data Analysts who need to be able to effectively present and communicate data in visually compelling ways.
Role
Skill Level
Style
Duration
2 Days
Related Technologies
- Productivity Objectives:
- Perform data analysis fundamentals
- Visualize data with Excel
- Analyze data with formulas and functions
- Analyze data with PivotTables
- Present visual insights with dashboards in Excel
- Create geospatial visualization with Excel
- Perform statistical analysis
- Get and transform data
- Model and analyze data with Power Pivot
- Present insights with reports
Request Information
Get your team upskilled or reskilled today. Chat with one of our experts to create a custom training proposal. Fully customized at no additional cost.
If you are not completely satisfied with your training class, we'll give you your money back.
about our training
-
Real-World Content
Project-focused demos and labs using your tool stack and environment, not some canned "training room" lab.
-
Expert Practitioners
Industry experts with 15+ years of industry experience that bring their battle scars into the classroom.
-
Experiential Learning
More coding than lecture, coupled with architectural and design discussions.
-
Fully Customized
One-size-fits-all doesn't apply to training teams. That's where we come in!
What You'll Learn
In the Data Analysis & Visualizations with Excel training course, you'll learn:
- Data Analysis Fundamentals
- Data analysis scenarios
- Tables
- Sort and filter data
- Visualizing Data with Excel
- Visualize data with charts
- Modify and format charts
- Best practices for selecting charts
- Analyzing Data with Formulas and Functions
- Analyze data with formulas
- Analyze data with functions
- Analyze data with data validation, forms, and controls
- Create conditional visualization with Lookup functions
- Analyzing Data with PivotTables
- Create a PivotTable
- Analyze PivotTable data
- Presenting Visual Insights with Dashboards in Excel
- Visualize data with PivotCharts
- Filter Data using Slicers
- Create a dashboard in Excel
- Creating Geospatial Visualizations with Excel
- Create map charts in Excel
- Format and customize map charts in Excel
- Performing Statistical Analysis
- Visualize trendlines and sparklines with Excel
- Analyze data with the data analysis toolpak
- Getting and Transforming Data
- Connect to data with queries
- Clean and combine
- Shape and transform data
- Modeling and Analyzing Data with PowerPivot
- Install PowerPivot in Excel
- Create data models with PowerPivot
- Create PowerPivots
- Perform advanced data analysis and visualization
- Presenting Insights with Reports
- Planning a report
- Creating a report
Real-world content
Project-focused demos and labs using your tool stack and environment, not some canned "training room" lab.
Expert Practitioners
Industry experts that bring their battle scars into the classroom.
Experiential Learning
More coding than lecture, coupled with architectural and design discussions.
Fully Customized
One-size-fits-all doesn't apply to training teams. That's where we come in!
Elite Instructor Program
We recently launched our internal Elite Instructor Program. The community driven instructor program is designed to support instructors in transforming students’ lives by consistently showing a world-class level of engagement, ability, and teaching prowess. Reach out today to learn more about our instructors.
Customized Technical Learning Solutions to Help Attract and Retain Talented Developers
Talk to one of our Learning Solution Architects today
Let DI help you design solutions to onboard, upskill or reskill your software development organization. Fully customized. 100% guaranteed.
DevelopIntelligence leads technical and software development learning programs for Fortune 500 companies. We provide learning solutions for hundreds of thousands of engineers for over 250 global brands.
“I appreciated the instructor’s technique of writing live code examples rather than using fixed slide decks to present the material.”
VMwareAbout Us
LET’S DISCUSS
DevelopIntelligence has been in the technical/software development learning and training industry for nearly 20 years. We’ve provided learning solutions to more than 48,000 engineers, across 220 organizations worldwide.
Resources
Thank you for everyone who joined us this past year to hear about our proven methods of attracting and retaining tech talent.
- Boulder, Colorado Headquarters: 980 W. Dillon Road, Louisville, CO 80027
© 2013 - 2022 DevelopIntelligence LLC - Privacy Policy