Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the gutenslider domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /home/awtg-dev-bemore/htdocs/dev-bemore.awtg.net/wp-includes/functions.php on line 6121

Warning: Undefined array key "capabilities" in /home/awtg-dev-bemore/htdocs/dev-bemore.awtg.net/wp-includes/class-wp-roles.php on line 292
INTERMEDIATE MICROSOFT EXCEL - BeMore

INTERMEDIATE MICROSOFT EXCEL 

COURSE AIMS
This hands-on one-day training course has been designed to give delegates a solid understanding of intermediate level tools and concepts used in Excel, specifically in writing and using formulas in order to increase their knowledge and productivity.

TARGET AUDIENCE

Users with a basic understanding of Microsoft Excel who want to take their knowledge of the basic features further in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction course.

MODULE 1:  Working with Functions and Formulas

Some key formulas and functions essential to Excel users along with features to help manage formulas, functions and ranges.

  • Creating Formulas
  • Common Aggregate Functions (eg. SUM)
  • IF and Nested Functions
  • Using the VLOOKUP Function
  • Formulas with Absolute References
  • Text Functions
  • Date Functions 

MODULE 2:  Managing Tables in Microsoft Excel

Managing spreadsheet data in table format, an excellent feature to administrate large sets of data.

  • Creating Excel Tables
  • Sorting and Filters
  • Formatting Your Form
  • Using Formulas on and in an Excel Table
  • Totals in Tables 

MODULE 3:  Data Tools in Excel

Features to help with managing spreadsheet data making it a less daunting and repetitive task to manage the data.

  • Text to Columns
  • Remove Duplicates
  • Conditional Formatting
  • Flash Fill
  • Data Validation