Microsoft Excel Basic. Brand-new to Excel? Welcome aboard!
If you’re new to Excel, it’s essential to learn the basics – in the right order. This is an Introduction to Microsoft Excel 2016 training course; students will create and edit basic worksheets and workbooks.
This course is designed for students who want to gain the necessary skills to create, edit, format, and print basic Microsoft Excel 2016 worksheets.
With our lessons you will learn basic techniques including how to use math, statistical, logic and text functions, organize data by sorting and filtering, efficiently present your data in several chart formats and more.
In this Microsoft Excel training course, expert training provider will take you through the basics of the worlds most famous spreadsheet software.
Excel can be a complicated and confusing program to use, but this course breaks it down into bite-sized pieces. No prior experience in Excel or spreadsheets is required to get the most out of this Excel beginners training.
You will start with the absolute basics, creating and saving a new workbook.
The course proceeds step by step through the process of entering data in cells, doing basic math, formatting your worksheets, setting up pages for printing and applying basic mathematical formulas.
Once you are comfortable with the basics, you will move on to more advanced formatting with themes, using Excel provided templates, adding graphics and charts, and using Excel as a database.
By the time you have completed this training course, you will be comfortable with day to day operations that you would perform in this software program.
You will be able to perform calculations and create professional graphs and charts from your data. Working files are included to allow you to follow along using the same source material.
This is accredited Microsoft course.
You might be interested in Microsoft Excel Intermediate course as a next step.
The training explains Microsoft Excel starting with the absolute basics of creating your very first worksheet. He slowly works you up through learning the various capabilities of this compelling program and covers topics such fundamental to advanced formula and functions. A chapter on how to connect to Microsoft Web Apps is also covered. The course also shows how to use your SkyDrive to store and share your Microsoft Excel Projects.
Students will receive official Microsoft Certificate.
Creating basic worksheets using Microsoft Excel
The Work Surface
Print the content of an Excel worksheet
Entering Text And Numbers
Inputting Dates And Times
Editing The Contents Of A Cell
Using Copy And Paste
The FILL Handle
Using Undo And Redo
Font Size And Colors
Enhancing Worksheets Using Themes
Working With Comments
Creating Your AutoFill List
Turning Your Data Into A Table For Formatting
Custom Number Formats
Conditional Formats with Built-In Rules
Building Column Charts
Building Bar Charts
Building Pie Charts
Building Line Charts
Using Protection On A Worksheet
Protecting Part Of A Worksheet To Facilitate Data Entry
Controlling Access To Cell Ranges By Password And Or User Accounts
Saving A Workbook With Password Protection
Microsoft Word Advanced Microsoft Word Advanced course is the course for you if you need to produce well-defined Forms and work with large Documents. Our Microsoft Word Advanced course is suitable for those with a sound working knowledge of.....View Detail
Microsoft Word Intermediate Microsoft Word Intermediate course designed to take your PC skills from Basic all the way to Advanced level, one step at a time. You’ll learn how to be active and efficient in your everyday work, with a thorough.....View Detail
Microsoft Word Basic Microsoft Word Basic is an introduction to Microsoft Word 2016 course designed for students new to working with Microsoft Word in Windows. Microsoft Word has made word processing so simple that no one even calls it.....View Detail
Certified Associate in Project Management (CAPM) Certified Associate in Project Management (CAPM) is an asset that will distinguish you in the job market and enhance your credibility and effectiveness working on — or with — project.....View Detail
Internet of Things (IoT) Internet of Things (IoT) - Build Your Internet of Things. Learn the creation of the Internet of Things products and services in our courses. Design, create and deploy a fun IoT device. The Internet of Things (IoT) .....View Detail
Microsoft PowerPoint Advanced Microsoft PowerPoint Advanced. In any stand-up presentation, there are two critical components to an excellent presentation, your delivery, and your slides. They require two different sets of skills. This.....View Detail
Microsoft PowerPoint Intermediate Microsoft PowerPoint Intermediate class goes beyond the basics of creating a design template presentation with text and clip art. Delivering a presentation in the office to your colleagues and bosses or.....View Detail
Microsoft PowerPoint Basic Microsoft PowerPoint Basic - Want to create effective PowerPoint presentations but don’t know where to start? Whether you are new to PowerPoint or have some experience and want to improve your skills, this course.....View Detail
Microsoft Excel Basic Microsoft Excel Basic. Brand-new to Excel? Welcome aboard! If you're new to Excel, it's essential to learn the basics - in the right order. This is an Introduction to Microsoft Excel 2016 training course; students will.....View Detail
Motivational Skills Motivational Skills - Discover Key Factors for Building a Motivated Team. Managers everywhere want teams that are effective, focused and committed to organizational goals. With a team like this, think of the performance.....View Detail