MS Excel 2019: Upgrading from 2007

Instruction Language: English
Application Language: English
In the course MS Excel 2019: Upgrading from 2007, you will get acquainted with the changes brought to you by the new version of the program, starting with a redesigned user interface. You will examine the new offer of templates, which has come closer to the needs of users. You will familiarise yourself with an improved usage of certain tools. You will also try a set of new tools that enable even less skilful users to perform advanced analysis of data. Namely, you will explore the Flash Fill tool, the menu of the Quick Analysis button and the offer of recommended charts and PivotTables. You will try new tools for editing created charts as well as the use of slicers to filter data.

Product code: EN-Exc19Up07-Exc

Online

Price
£ 22.00
£ 26.62 incl. VAT info
*
*
  • Sparklines
  • The Excel window
  • Customising the Ribbon
  • Creating charts
  • Chart design
  • Advanced paste options
  • Chart formatting
  • Creation and saving of a workbook
  • Screenshots and screen clipping
  • Open an existing workbook
  • Themes
  • Managing multiple windows
  • Conditional formatting rules
  • Workbook views
  • Conditional formatting based on a formula
  • Function library
  • Page setup
  • Microsoft account
  • File properties
  • Workbook inspection
  • Copying formatting
  • File AutoRecovery
  • Excel table
  • Using templates
  • Conditional formatting
  • Compatibility issues
  • Saving a workbook to the Web
  • Macro security
  • Recommended charts
  • Data filtering
  • Instant data analysis
  • Using slicers to filter data
  • Pictures in Excel
  • Printing
  • Customisation of the program settings
  • Getting help with Excel
  • Flash Fill
Products specifications

System Requirements

ProductType Single courses
ApplicationLanguage English
EducationLanguage English