Transitioning from Excel to QlikSense - Handson training

Learn to transition from Excel to Qlik Sense with hands-on training, mastering drag-and-drop visualizations, lookups, and conditional formatting to publish insights and leverage the community.

Create a free Qlik Sense account in the cloud, access your workspace, and import data from files using the script editor to load and visualize tables.

Learn to create custom calculations in Qlik Sense using measures and master items to compute totals like shipping cost. Publish these expressions to reuse across dashboards.

Learn to create bar, pie, and line charts in Qlik Sense using dimensions like product category and order priority with sales as the measure, and build dashboards across sheets.

Apply the if conditional statement in QlikSense to categorize data, build dynamic expressions, and create discount categories in both data load and front end.

Learn how to use variables in QlikSense to dynamically adjust all charts with a single value, applying a 10 percent adjustment to international sales and updating dashboards instantly.

Learn to replicate vlookup in QlikSense by performing left joins across tables to bring status data into the main sheet, update records, and use it in charts and expressions.

Explore creating a simple table in Qlik Sense, add columns and measures like sales and shipping cost, format numbers with currency, and sort or expand the table on your dashboard.

Create a pivot table in QlikSense by adding dimensions and measures, arranging fields like customer segment and product category, and applying filters to drive dashboard interactivity.

Explore conditional formatting in QlikSense for bar charts and simple tables, using measures such as shipping cost and switching from average to sum to visualize color conditions.

Learn how to add reference lines to a bar chart in QlikSense, using a reference line expression to mark targets like 20% or 50% of sales across segments.

Apply the calculation condition to charts to improve dashboard performance, using get field selection, product category filters, and an expression editor to display charts only when criteria are met.

Learn to build a tree map chart in Qlik Sense, using customer segments and product categories with sales as the measure, and drill down to brand names.

Create focused presentations by building stories in Qlik Sense from sheets, adding images, text, shapes, and commentary, then use the sheet library and filters to drill down.

Publish your Qlik Sense app to the cloud, move it to my stream for others to view, share it with users via the share button, and republish after review.

Explore built-in Qlik Sense apps in the cloud to gain design inspiration, view various chart types (bar, line, combo) and explore properties to understand how data is presented and reused.

Learn how to get help in QlikSense and increase your knowledge by using the community resources and asking questions to experts. Explore featured content to move your skills forward.

Master the transition from Excel to Qlik Sense with hands-on training, and build an awesome dashboard while providing feedback to influence future course updates.