Boost your Basic Excel Skills to a higher level: An Intermediate Workshop for Business Users
Take your basic Excel skills up to a new level and work more efficiently and effectively. Master some of the advanced uses of Excel Tables to automate your data, format your data accurately and learn some of the popular and most effective business formula.
SKILLS INTRODUCED:
- Spreadsheet planning and design to create professional workbooks
- Tips for navigating and selecting data
- Number and date formatting including custom formatting
- Advanced Excel Tables features including:
* Sorting and filtering data, Slicers
* Naming cells and tables
* Structured Referenced formula
* Automatic updating of data
- Advanced Formula and Functions including:
* Absolute and Relative References
* Logical Functions: IF, IFS, AND, SUMIFS, COUNTIFS, AVERAGEIFS
* Lookup Functions: VLOOKUP, XLOOKUP
SKILLS NEEDED:
This is an intermediate level workshop for reasonably confident users of Excel with basic skills including an understanding of formula like SUM( ) and AVERAGE( ), and entering and editing data.