Excel Course: Master Microsoft Excel 2021 Intermediate Level
Welcome to the ultimate Excel Course, where you’ll truly master Microsoft Excel 2021 at an intermediate level. Whether you’re a clerk, officer, executive, supervisor, or manager, this course is tailored to enhance your Excel skills to an intermediate level. If you’ve already got a basic understanding of Excel, this is your next step towards becoming a spreadsheet pro.
What to Expect in Our Excel Course
In this interactive course, you’ll dive deep into Excel’s functionalities. Learn to create complex formulas and functions, including AVERAGEA, AVERAGEIFS, SUMIF, SUMIFS, IF functions, and even nested functions. Master data validation, sorting, and filtering techniques for more efficient data management. Discover how to visualize data with conditional formatting, data bars, icon sets, and create stunning charts that tell a compelling data story.
Why Choose Our Excel Course
At Info Trek, we’ve been honing our training and development expertise for over two decades. Our commitment to staying at the forefront of technology means you’ll be learning the latest Excel techniques. Join us in our modern training facilities equipped with high-end computing systems and flexible exam facilities. Don’t miss out on the opportunity to excel in Excel. Enroll in our Microsoft Excel 2021 Intermediate course today!
Course Details
Course Code: – Course Duration: 2 Days; Instructor-led
This Google Looker Studio course will help you to become a Data Visualization Expert and will enhance your skills by offering you comprehensive knowledge, and the required hands-on experience on this widely used Cloud based Business Intelligence tool, by solving real-time industry-based projects.
WHEN TO USE
- The purposes and basic functions of the core BI components
- Using the Google Looker Studio
- Connecting to multiple data source
- Modelling data
- Creating reports and visualizations
Audience
- Any individuals want to learn Google Looker Studio and without any coding expertise.
- Working professionals looking to learn a new powerful tool for dashboard development and data visualization
Prerequisites
None
Methodology
This program will be conducted with interactive lectures, PowerPoint presentation, discussion and practical exercise.
Course Objectives
Upon completion of this program, participants should be able to:
- Know about Google Looker Studio as an enterprise level Business Intelligence tool
- How to use Google Looker Studio to create interactive and beautiful dashboards
- How to connect to various data sources with live examples
- All the chart types in Google Looker Studio like bar, time series, geo maps, scatter plots, and how to configure each of them
- Sharing reports as is, as customised bookmarks or as templates
- Add action controls like dropdowns, sliders and other filter controls in your report to add user interactivity
- How to blend data from different tables to bring together to create one report
- Create tricky calculated fields and parameters
- Advanced features like REGEX_EXP (regular expressions)
Outlines
Lesson 1: Getting Started
- Getting Around Google Looker Studio
Lesson 2: Connecting to Data Sources
- Connecting to a Data Source
- Managing Data Sources
- Sources to get Public Datasets
Lesson 3: Working with Reports
- Getting around report Canvas
Lesson 4: Using the New “Explorer” Feature
- How to Use “Explorer”
Lesson 5: Creating and Configuring Various Chart Types
- Table Visualisation
- Special Types of Table Visualisations
- Pivot Tables
- Scorecards
- Bar Charts
- Line Charts and Time Series
- Combo Charts
- Pie and Donut Charts
- Bullet Chart
- Geo Maps and Google Maps Chart
Lesson 6: Using the New “Explorer” Feature
- How to Share your Reports
Lesson 7: Managing Google Looker Studio Reports
- Data Blending
- Adding Action Controls for User Interaction
- Copying Visualisation Formatting
- Page Level and Report Level Visualisations
- Formatting Chart Metrics
- Creating Visualisation Groups
- Embed URL, Videos and Google Forms in your Report
- Using Parameters to get User Input
- Using Built in Templates and how to create your own Templates
- Embedding a Report in Your Website
- Using Regular Expressions (REGEX)
- Working with Community Visualisations
Lesson 8: Best Practices to Create Reports in Looker Studio
- Charting Best Practices
- How to Choose the Right Visualisation?
- Tips to create an effective Report
