This training is a must for everyone who works in Excel on daily basis. We show you pro tips and tricks to speed up your work and improve output beyond expectations. In this training you will master your Excel skills and take it to an advanced level: Pivot Tables, array formulas, advanced visualizations.
Excel Advanced Become Excel Pro
OBJECTIVE: Understand how to perform complex analysis with Excel and how to use advanced options to improve the analysis of the data.
DURATION: 14h split into 4 sessions (3.5h each) FORMAT: Real time Training Online. Access to online environment, call via Zoom, MS Teams or Webex.
TOPICS: Advanced Pivot Tables and Charts Adding fields and rearranging a Pivot Table Report Incorporating data source changes Inserting a filter field and adding layers Changing the report layout and formatting Changing the type of calculation used to summarize value Adjusting the display settings for calculated values Alternative methods for Pivot Table Calculations Calculated fields and items Creating, editing and conditionally formatting Pivot Chart Building a data model and managing relationships Adding and removing tables for the data model
Grouping, sorting and filtering
Grouping dates and times, values and text fields Using filters for row and column fields Filtering using the filter area, slicers and timelines Sorting in Pivot Tables Advanced Visualizations Choosing the right chart type Exploring user interface choices for modifying charts Filtering and handling missing and hidden data Creating chart templates Applying best visualization practices Integrations of dynamic elements into charts Applying area highlights Using conditional colors in charts Creating performance tracking and project control chart Time tracking with Gantt charts and timelines Sparklines creation and customization Conditional formatting with the REPT Function
Formulas and Functions Review of formulas (arithmetic, comparison, text, reference) Formula operators Copying formulas and range references Range names in formulas Troubleshooting Structure of functions Adding intelligence with logical and information functions Combining functions for extended functionality
Data Analysis Calculating central measures, extreme values and creating frequency distributions
Array formulas Math array operators Comparative array operators and aggregate calculations Join array operators Constants and functions
Manipulating text and data cleaning Data Import and structuring Removing unwanted characters Concatenating data Searching and extracting substrings Filling and deleting gaps Removing duplicates
Working with dates and Times Dealing with dates and times Date and time related functions
Data Extraction and Validation Retrieving information with lookup Exact vs approximate lookups Performing two-ways lookups Multiple column lookups ACCESS: Training Call Training Materials Learning Path (over 6h of recorded content) Additional optional assignments (2) Possibility to ask questions ad hoc to the trainer at any point (email)
Excel Expert Trainer
His background is in finance and
he has worked as a BI consultant before.
Over the last 8 years he
has been consulting on projects and training international teams in Power BI, Tableau and advanced Excel. He is widely recognized in the Power BI community and has one of
the fastest growing Power BI YouTube channels worldwide- How
to Power BI.