COMPREHENSIVE 5.5-HOURS SESSION | EXPLORING EXCEL’S BEST FEATURES
Microsoft Excel has become the world’s most popular spread sheet software that lets users perform multiple business tasks, like creating dashboards, charts, pivot tables, and much more.
Gaining mastery over Excel will not only ease your day-to-day work but also provide tools to make the most of your data. Whether you’re a beginner or an expert, the Business Intelligence with Microsoft Excel – Virtual Boot Camp will cover vital aspects of Excel that you will find essential in building your professional skills.
This boot camp will help you master charts and graphs, use PivotTables to process huge amounts of data, improve business analytics with dashboards, and learn about cool Excel lesser-known tips and tricks from the top two Excel experts in the industry.
BOOT CAMP HIGHLIGHTS
Excel Tips and Shortcuts
Navigate seamlessly through workbooks and worksheets with keystroke and mouse shortcuts
Copy or move data with simple dragging instead of multi-step command sequences
Display/hide all worksheet formulas instantly; select all formula cells with two mouse clicks
Use keystroke shortcuts for a various number formats
Build lists of dates, times or values without using time-consuming commands
Create charts instantly and learn manipulation tips
Create formulas faster with entire column references
Master over 100 tips to make you a Power User!
Mastering Excel Charts and Graphs
Creating a simple bar chart
Annotating a chart with labels, titles and notes
Creating a line-bar combination chart
Creating a dynamic chart based on a Table
Creating Sparkline charts
Creating infographics with Excel
Using Conditional Formatting to present data visually
Excel PivotTables: Using Excel’s Best Analytical Feature
Pre-requisites for source data – preparing data so that it can be analyzed by PivotTables
Creating a PivotTable with a minimum number of steps, including the new Recommended PivotTables option now available in Excel 2013 and 2016
Manipulating the appearance of a PivotTable via dragging and command techniques
Using Slicers to accentuate fields currently being shown (and which ones are not)
Using the new (in Excel 2013) Timeline feature
Creating ad hoc and date-based groupings within a PivotTable
Exploring the best techniques for updating PivotTables