This course is designed for students who desire to gain the necessary skills to create, edit, format, and print basic Microsoft Office Excel worksheets.
Course Objective: You will create and edit basic Microsoft Office Excel worksheets and workbooks.
Target Student: This course is designed for students who desire to gain the necessary skills to create, edit, format, and print basic Microsoft Office Excel worksheets.
Excel Training Course Objectives
Upon successful completion of this course, students will be able to:
create a basic worksheet by using Microsoft Office Excel.
perform calculations in an Excel worksheet.
modify an Excel worksheet.
format a worksheet.
print the content of an Excel workbook.
manage an Excel workbook.
Excel Training Course Content
Lesson 1: Creating a Basic Excel Worksheet
Topic 1A: Identify the Elements of the User Interface
Topic 1B: Customize the Excel Interface
Topic 1C: Work with Cells
Topic 1D: Enter Data in an Excel Workbook
Topic 1E: Obtain Help in Excel
Lesson 2: Performing Calculations in an Excel Worksheet
Topic 2A: Create Basic Formulas
Topic 2B: Calculate the Cell Values by Using Functions
Topic 2C: Copy Formulas and Functions
Lesson 3: Modifying an Excel Worksheet
Topic 3A: Manipulate Data
Topic 3B: Modify the Worksheet Elements
Topic 3C: Search for Data in a Worksheet
Topic 3D: Modify Rows and Columns
Lesson 4: Formatting an Excel Worksheet
Topic 4A: Modify Fonts
Topic 4B: Check a Worksheet for Spelling Errors
Topic 4C: Apply Number Formatting
Topic 4D: Add Borders and Colors to Cells
Topic 4E: Align the Content in a Cell
Topic 4F: Apply Cell Styles
Lesson 5: Printing Excel Workbooks
Topic 5A: Set the Page Layout Options
Topic 5B: Set Page Breaks
Topic 5C: Print a Workbook
Lesson 6: Managing an Excel Workbook
Topic 6A: Format Worksheet Tabs
Topic 6B: Manage Worksheets
Topic 6C: View Worksheets and Workbooks
Here at Sonic Training, Inc., we take your technical education seriously. With over a decade of training experience, our mix of learning in a fun environment makes understanding complex applications, like Excel, Dreamweaver or Project, easy to digest. We also realize each student is unique and the company they work for is unique, so our small class sizes (never over 8 students) makes it easy to incorporate your project at work into our class.
We actually encourage work-related scenarios to help give the other students another real-life perspective. When you call in, you won't' get an aggressive commission-driven salesperson, but a professional giving you the needed information. For a complete list of student benefits, click here.
Quality Instructors With Real-World Experience
Sonic Training instructors have at least 11 years of teaching experience and an average of 17 years of technical-related experience. The practical real-world experience is critical in the classroom, since on-the-spot student questions can be answered much more effectively. Some of our instructors are published authors of books and technical articles in their respective fields. Would you like to become a Sonic Training instructor? Read more.
Enterprise Training Solutions
Our professional services expertise can help you design a unique training solution that will meet targeted business requirements. From one office upgrade to a multi-city, national or international rollout, Sonic Training will ensure your training initiative is of the highest possible caliber, with the highest measurable return on your training investment.
A comprehensive PowerPoint 2010 course, covering creating, editing, customizing and delivering PowerPoint presentations. Â
The primary Microsoft Office Applications program is geared towards professionals who want to start their careers in Office Administration, as well as students who want to refresh their understanding of Microsoft Office Products.
These days, most people take electronic word processing for granted. While we may still write out our grocery lists with pen and paper, we expect to use a computer to create the majority of our documents.
Microsoft Power Automate is a cloud-based service that makes it practical and simple for line-of-business users to build workflows to automate time-consuming business tasks and processes across applications and services.
Learn about the Visio interface, adding shapes, diagrams, stencils, creating a flowchart, working with connectors, page styles, cross-function shapes, organizational charts.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy