Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyze the data that is critical to the success of your organization. You will:
Modifying a Worksheet
Formatting a Worksheet
Performing Calculations
Basic Charts
Printing Workbook Contents
Refine the Page Layout and Apply Print Options
Customizing the Excel Environment
This course is intended for students who wish to gain the foundational understanding of Microsoft Office Excel that is necessary to create and work with electronic spreadsheets.
- The prerequisites for this course are an introductory course to Windows or a solid working knowledge of Windows.
- Getting Started with Microsoft Excel
- Identity the Elements of Excel Interface
- Create a Basic Worksheet
- Use the Help System
- Modifying a Worksheet
- Manipulate Data
- Search for the Replace Data
- Spell Check a Worksheet
- Formatting a Worksheet
- Modify Fonts
- Add Borders and Colors to Cells
- Apply Number Formats
- Align Cell Contents
- Apple Styles
- Performing Calculations
- Create Formulas in a worksheet
- Insert Functions in a Worksheet
- Reuse Formulas
- Visualizing Data with Charts
- Create Charts
- Modify and Format Charts
- Printing Workbook Contents
- Refine the Page Layout and Apply Print Options
- Refine the Page Layout and Apply Print Options
- Format Worksheet Tabs
- Manage Worksheets
- Manage the View of Worksheets and Workbooks
- Customizing the Excel Environment
- Customize Proofing and Save Options
- Customize the Ribbon and Quick Access Toolbar
- Customize the Advanced and Trust Center Options
Course based on software release:
2010, 2013, 2016, 2019
Course notes and announcements:
This course is intended to help users get up to speed with Excel quickly. We will cover different features of the interface, the basics of formatting and editing, the basics of building formulas and functions and show users how to print.
* Terms and conditions may apply. Learn more about our training exclusives by contacting training@dunnsolutions.com
Live Virtual:
Get engaging and impactful live, instructor-led training, regardless of your location.
Our Virtual Classroom Live online training format combines premium skills development technologies and our industry-leading instructors, content, exercises and peer collaboration to ensure that you get the highest quality professional development experience possible. Gain the skills and expertise that matter from the convenience of your home, work or wherever you have an Internet connection.
Engage with your instructor and fellow students via a learning platform and course material designed to ensure a stimulating and productive skills development experience.
Choose from sessions across a variety of time zones for training options that suit your schedule. Save time, money and effort without sacrificing learning quality by accessing our expert-led online training from the convenience of your home, office or anywhere with an Internet connection.
Attend from your PC, Mac or any iOS/Android tablet or smartphone. Connect with the class through your device audio or via toll-free phone number†, depending on available technologies and your interaction preferences.
Learn to create, format, enhance and print simple Excel spreadsheets.
