• LOGIN
  • No products in the basket.

Login

Learning Objectives

Introduction , Getting Started with Excel , Creating Workbooks and Using Templates , Entering Data , Excel Formula Basics , Adjusting a Worksheet , Formatting and Aligning Data , Using Cell Styles and Themes , Inserting Objects and Graphics , Proofing a Workbook , Printing an Excel File , Managing Worksheets , Navigating and Viewing Excel Files , Conclusion

 

Pre-Requisites

Basic Computer Skills

 

Description

Microsoft Excel is one of the major workhorses in the Microsoft Office suite of applications and arguably the most widely-used Office product. A solid understanding of how to use this program is vital to nearly everyone in most industries today. This course is designed specifically to teach you the fundamentals of Excel and give you the skills you need to begin to create and manipulate worksheets. Specifically, you will understand how to create, save, enter data, and print spreadsheets in addition to learning how to create formulas and use functions to calculate in Excel. You will learn how to enter data, format spreadsheets, manipulate columns and rows, add headers and footers, and use page setup options to prepare them for printing. You will also learn how to handle large worksheets or multiple workbooks, use styles and themes, insert various graphic objects, and options for proofing your workbooks.

Course Curriculum

Section 01
Lesson 01: What is Excel 00:03:00
Lesson 02: Opening Excel 00:04:00
Lesson 03: Navigating the Excel User Interface-v2 00:06:00
Lesson 04: Navigating the Excel User Interface 00:04:00
Lesson 05: Using the Excel Ribbon 00:07:00
Lesson 06: Understanding Excel Worksheet Components 00:07:00
Lesson 07: Using the Backstage View 00:06:00
Section 02
Lesson 01: Creating a New Workbook 00:06:00
Lesson 02: Saving an Excel Workbook 00:05:00
Lesson 03: Using the Accessibility Checker 00:04:00
Lesson 04: Using the Accessibility Checker-v3 00:04:00
Section 03
Lesson 01: Navigating a Worksheet by Mouse or Keyboard 00:05:00
Lesson 02: Understanding Excel Data Types 00:04:00
Lesson 03: Using the Inking Tools 00:05:00
Lesson 04: Using the Inking Tools-v3 00:03:00
Lesson 05: Working with Cell and Range Addressing 00:05:00
Lesson 06: Using Various Data Selection Techniques 00:05:00
Lesson 07: Working with Common Excel Commands 00:06:00
Lesson 08: Using Flash Fill and Autofill 00:06:00
Section 04
Lesson 01: What are Formulas and Functions 00:05:00
Lesson 02: Understanding the Components of a Formula 00:05:00
Lesson 03: Understanding Calculation Hierarchy and the Order of Operations 00:03:00
Lesson 04: Creating Basic Formulas 00:05:00
Lesson 05: Working with Basic Functions and AutoSum 00:06:00
Lesson 06: Using Cell References 00:05:00
Lesson 07: Using the Quick Analysis Tool 00:03:00
Section 05
Lesson 01: Modifying Columns and Rows 00:06:00
Lesson 02: Hiding and Unhiding Columns and Rows 00:06:00
Section 06
Lesson 01: Formatting and Aligning Data 00:07:00
Lesson 02: Merging Data 00:07:00
Lesson 03: Wrapping Text and Adjusting Orientation 00:06:00
Lesson 04: Formatting Numbers 00:05:00
Lesson 05: Using the Format Painter 00:04:00
Section 07
Lesson 01: Using Cell Styles 00:06:00
Lesson 02: Applying Themes 00:05:00
Section 08
Lesson 01: Inserting and Formatting Images and Shapes 00:08:00
Lesson 02: Inserting and Formatting SmartArt 00:05:00
Lesson 03: Working with Icons 00:04:00
Lesson 04: Inserting Hyperlinks 00:06:00
Lesson 05: Inserting Symbols and Equations 00:05:00
Lesson 06: Inserting WordArt and Text Boxes 00:05:00
Lesson 07: Inserting 3-D Models 00:04:00
Lesson 08: Arranging Objects 00:06:00
Section 09
Lesson 01: Using Find and Replace 00:05:00
Lesson 02: Using Go To and Go To Special 00:03:00
Lesson 03: Using the Spell Checker 00:05:00
Lesson 04: Using the Thesaurus and Translation Features 00:05:00
Lesson 05: Using the resolve Feature-v3 00:02:00
Section 10
Lesson 01: Printing and Previewing Excel Files 00:06:00
Lesson 02: Creating Custom Margins and Scaling 00:05:00
Lesson 03: Adding Headers and Footers 00:04:00
Lesson 04: Formatting a Page with the Page Layout Tab 00:06:00
Lesson 05: Printing Titles and Specific Worksheet Areas 00:03:00
Lesson 06: Exporting to PDF-v3 00:02:00
Lesson 07: Exporting to PDF and XPS 00:04:00
Section 11
Lesson 01: Renaming and Coloring Worksheet Tabs 00:03:00
Lesson 02: Adding, Deleting and Navigating Worksheets 00:03:00
Lesson 03: Hiding and Unhiding Worksheets 00:03:00
Section 12
Lesson 01: Viewing Workbooks 00:03:00
Lesson 02: Using Zoom Tools 00:03:00
Lesson 03: Configuring Sheet Options 00:05:00
Lesson 04: Using the Freeze Panes and Split Commands 00:04:00
Lesson 05: Adjusting Worksheet Properties 00:04:00
Lesson 06: Viewing Workbook Statistics-v3 00:02:00
Course Recap
Recap 00:02:00

FAQs

This course is for anyone who's interested in this topic and wants to learn more about it. This course will also help you gain potential professional skills.

No prior qualifications are needed to take this course.

You can study this course from wherever and whenever you want. You can study at your own pace and from any device. Just log in to your account from any device and start learning!

Yes, there is a test at the end of the course. Once you’ve completed all the modules of the course, you will have to give a multiple-choice test. The questions will be based on the topics of the modules you studied. And of course, you can take the test at any time, from any device and from anywhere you want.

Don’t worry if you fail the test, you can retake it as many times as you want.

You don’t have to wait a minute after your payment has been received, you can begin immediately. You will create your login details during the checkout process and we will also send you an email confirming your login details.

We make the payment process easy for you. You can either use your Visa, MasterCard, American Express, Solo cards or PayPal account to pay for the online course. We use the latest SSL encryption for all transactions, so your order is safe and secure.

After you complete the course, you’ll immediately receive a free printable PDF certificate. Hard Copy certificate is also available, and you can get one for just £9! You may have to wait for 3 to 9 days to get the hard copy certificate.

© iStudy
Select your currency
GBP Pound sterling