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
