OptimaTrain

Practical Excel 2016 for the Workplace – Fundamentals

$100.00$175.00

COURSE DESCRIPTION

This introductory course covers the fundamentals of Microsoft Excel 2016. It assumes you have used Excel, at least at an elementary level, such as opening and saving an Excel file. This course will drastically increase your productivity and broaden your Excel skills.

Clear
SKU: N/A Category:

Description

COURSE DESCRIPTION

This introductory course covers the fundamentals of Microsoft Excel 2016. It assumes you have used Excel, at least at an elementary level, such as opening and saving an Excel file. This course will drastically increase your productivity and broaden your Excel skills.

The course begins with the Excel user interface: the tabs and ribbons, the backstage view, and the Quick Access Toolbar. It then teaches you methods for performing common Excel tasks, such as moving around large worksheets, selecting ranges, copying and pasting, working with formulas, creating and modifying charts, and printing. It also teaches you best spreadsheet practices for making your spreadsheets attractive and understandable by others. Throughout, the focus is not just on performing common tasks in Excel, but performing them efficiently.

Category: Office Productivity/Microsoft

What are the requirements?

  • Microsoft Office 2016

What am I going to get from this course?

  • Close to 4 hours of video content, plus an Excel add-in for premium subscribers
  • An understanding of the Excel user interface, including changes to Excel since 2007
  • Efficiency tips on moving around worksheets and selecting large ranges
  • Efficiency tips on copying, cutting, and selecting formulas and ranges
  • How to manipulate rows, columns, and worksheets
  • How to take control of printing worksheets
  • How to format efficiently and effectively
  • How to work effectively with formulas, including auditing for correctness
  • How to create and modify charts effectively
  • How to use common but powerful Excel functions, including IF and VLOOKUP
  • Best practices for creating attractive and understandable spreadsheets

What is the target audience?

  • Any beginning Excel users who want to become more efficient and take their Excel skills to the next level

Additional information

Access Length

1 Year, 2 Years, 3 Years