OptimaTrain

Practical Excel 2010 for the Workplace – Fundamentals

20 STUDENTS ENROLLED

COURSE DESCRIPTION

This introductory course covers the fundamentals of Microsoft Excel 2010. 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. To learn Excel quickly and effectively, download the companion exercise files so you can follow along with the instructor by performing the same actions he is showing you on the videos.

Category: Office Productivity/Microsoft

What are the requirements?

  • Microsoft Office 2010

Prerequisites: Basic Computer Knowledge

What am I going to get from this course?

  • Close to 4 hours of course content
  • 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

Course Reviews

N.A

ratings
  • 1 stars0
  • 2 stars0
  • 3 stars0
  • 4 stars0
  • 5 stars0

No Reviews found for this course.