Packt+ | Advance your knowledge in tech

0

Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Free Learning

Microsoft Excel Beginners 2016

You're reading from Microsoft Excel Beginners 2016 Master Excel 2016 for complete beginners in this helpful, info-packed video course

Product type Video

Published in Aug 2019

Publisher Packt

ISBN-13 9781839216732

Length 9hrs

Edition 1st Edition

Tools

Excel

Concepts

Information Management

Author (1):

Simon Sez IT

View More author details

Table of Contents (32) Chapters

1. Introduction FREE CHAPTER

2. What's New

New and Improved Features in Excel 2016

3. Using Touch

Overview of Principles of Using Touchscreen

4. Getting Started

5. Using Help

Online Help and Contextual Help

6. Excel Options

Personalizing your use of Excel

7. The Ribbon and Toolbars

8. Entering and Editing Data

9. Backup and Recovery

AutoSave, Recover Unsaved Workbook, and Create a Backup Copy

10. Fill and Series

11. Viewing and Printing

12. Cut, Copy, and Paste

Methods of Cutting, Copying, and Pasting

13. Formatting a Worksheet

14. Formulas and Functions

15. Managing Worksheets

Worksheet

16. Working with Multiple Workbooks

Working with Multiple Workbooks

17. Saving Workbooks

Saving in Different File Types

18. Proofing

The Spell Checker

19. Inserting Comments

20. Basic Functions in Excel

21. Graphs and Charts

22. Sorting and Filtering Data

23. Shapes and Pictures

24. Formatting Cells Based on Content

Conditional Formatting

25. Protection and Security

26. Naming Items

27. Finding and Replacing Words

Find and Replace

28. Borders

Adding Borders

29. Workbook Inspection

Inspecting a Workbook

30. Privacy Options

Trust Center Privacy Options

31. Sharing Options

Sharing a Workbook

32. Conclusion

Conclusion and Close

Content Locked

Register for a free Packt account to unlock a world of extra content!

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at €18.99/month. Cancel anytime

Authors (1)

Simon Sez IT

Simon Sez IT

Simon Sez IT has been simplifying software learning since 2008, helping individuals, small businesses, and Fortune 500 companies boost productivity through hands-on, easy-to-follow training. With over 12,000 video tutorials across key business and technical tools, Simon Sez IT delivers stress-free eLearning that supports software adoption and skill growth. Trusted by over 940,000 students in more than 180 countries, it remains a go-to resource for practical, expert-led online learning.

See other products by Simon Sez IT

Personalised recommendations for you

Based on your interests and search pattern

Mastering Customer Success

Mastering Customer Success

This guide unveils strategies to cultivate enduring customer relationships. Grounded in effective communication and problem-solving, it shows you how to harness cross-functional collaboration for competitive advantage.

May 2024 5h 40m

Architecting Salesforce Success

Architecting Salesforce Success

This book provides you with a roadmap to becoming a successful Salesforce Architect. Covering common pitfalls and valuable insights, this book prepares you to transition to the role of a Salesforce Architect.

The SketchUp Handbook for Interior Design

The SketchUp Handbook for Interior Design

The SketchUp Handbook for Interior Design walks interior designers and architects through SketchUp Pro and Studio at an intermediate+ level, covering topics and tools specific to the world of design.

Jun 2024 19h 56m

Power Platform and the AI Revolution

Power Platform and the AI Revolution

Learn how to integrate cutting-edge AI technology into business operations and tap into AI services within Power Platform to enable automation and develop apps and chatbots to achieve heightened productivity and efficiency.

May 2024 11h 52m

Mastering Project Management with ClickUp for Work and Home Life Balance

Mastering Project Management with ClickUp for Work and Home Life Balance

This book will guide you in using ClickUp to become a power user of your life. You'll learn practical strategies for setup, project management, and AI integration to optimize workflow, boost productivity, and manage time effectively.

Jun 2024 10h 16m

Mastering UI Development with Unity

Mastering UI Development with Unity

With Unity's robust toolkit, you can create visually appealing UIs to give your games a professional look and feel. This book will help you realize the full potential of the UI systems provided by Unity, so you can create the best UI for your games.

Jun 2024 21h 16m

Autodesk Civil 3D 2025 Unleashed

Autodesk Civil 3D 2025 Unleashed

This book is a comprehensive guide to using Autodesk Civil 3D. You'll progress from design customization with extensions and information management to project extension, preparing you for a successful career in civil engineering.

Jul 2024 10h 28m

Mastering Salesforce Experience Cloud

Mastering Salesforce Experience Cloud

Mastering Salesforce Experience Cloud covers every facet of the platform, from technical reviews to implementation, business transformation, and long-term growth strategies. Learn to maximize the potential of Salesforce Experience Cloud.

Oct 2024 10h 56m

Mastering the Art of Sales Engineering

Mastering the Art of Sales Engineering

This book covers what a sales engineer is and does, and why this is a highly paid and coveted role. The authors share their vast experience to help you learn daily operations and skills to advance your sales career.

Sep 2024 10h 32m

Taking Tinkercad to the Next Level

Taking Tinkercad to the Next Level

Tinkercad users familiar with the basic functionality will learn to create complex shapes and multi-part designs with this book on advanced modeling. It covers strategies and techniques for modeling and designing for production with 3D printers.

Sep 2024 13h 56m