Every registration supports local education. TrainUp Gives Back
Logo

Your Career Training Marketplace

Questions? Call Toll-Free: 1-866-540-9677

  • Instant Access ImageInstant Access
    From Anywhere
  • Unlimited Viewing ImageUnlimited
    Viewing
  • calendar Image 6-12 Months
    To Complete

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
  • Agenda

Get the latest industry news, recommended courses, & promotions from TrainUp.com sent straight to your inbox.