• LOGIN
  • No products in the basket.

Lisa Newton, an infopreneur, spreads her knowledge on Excel in this Microsoft Excel Simplified – 101 Tips course. To achieve a higher-intermediate level, this course will allow you to go beyond the basics. You’ll be able to work smarter and quicker with shortcuts, tricks and tips. This course is for Excel users who are already acquainted with the fundamentals of Excel 2007.

The devotion of Lisa to an in-depth understanding of professional research makes this course a unique opportunity for both personal development and the benefiting sector. This Microsoft Excel Simplified – 101 Tips course will cover how to work with data, formulas and functions, copying data, using excel sheets, data patterns and creating charts. Lisa Newton also provided knowledge on saving and printing worksheet, extending excel and customizing excel in This Microsoft Excel Simplified – 101 Tips course. If you want to be relatively knowledgeable about the program and software, then this course will be very beneficial. It’s much easier to show things than to attempt to muddle around and figure out things on your own.

Highlights of The Course

  • In-depth knowledge of data
  • Description of formulas and function
  • How to Copy data
  • Knowledge of formats
  • Knowledge on listing
  • Knowledge of data patterns, charts, worksheet
  • Extended knowledge of excel

Description

The Microsoft Excel Simplified – 101 Tips is a popular training course, ideal for anyone who is looking to kick start their career relating to Excel as well as professionals who want to test their existing skills and knowledge. If you want to gain an in-depth understanding of the topic, then this program is perfect for you.

Our online courses come with lifetime access with no time limit for completion. Each course is fully accessible from a tablet, mobile or laptop, as long as there is a secure internet connection.

We pride ourselves on our supportive network of dedicated instructors and attentive customer service team who are dedicated to assisting you through your learning journey. Contact them at any time via email should you have any questions or queries.

Skills You Will Master

  • How to Work with Formulas and Functions
  • How to Copy data and formats
  • How to Use excel lists
  • How to Create charts
  • How to Present worksheets nicely
  • How to Save and print worksheets

Why Choose Skill Express?

  • Instantly accessible CPD Accredited certificate on successful course completion
  • 24/7 access to the course for lifetime
  • Developed by qualified professionals with updated resources
  • Full Tutor support on weekdays (Monday – Friday)
  • No hidden fees or exam charges

Who Is This Course For?

Microsoft Excel Simplified – 101 Tips course is Designed By Qualified Professionals.

This comprehensive Microsoft Excel Simplified – 101 Tips course is suitable for beginners and who want to gain a better understanding of Excel Whether you are completely new to the field or are an aspiring professional, the Microsoft Excel Simplified – 101 Tips will help open doors to a wide range of professions within your chosen field, helping you to stand out to employers with an accredited qualification that can be used to enhance your CV.

This course is perfect for:

  • Authors of books, courses, etc.
  • Business owners
  • Students of accountancy / finance / bookkeeping
  • Beginners in Excel and want to take it further to a higher intermediate level – using Excel 2007

Assessment

After completing the course successfully, you will be required to pass an automated, multiple-choice questions test which will give you the instant result once you finish the exam. And you can get all of these in a one-time payment!

Certification

After completing the course, you will be eligible for a PDF Certificate which will cost only £2.99, with your unique ID number so that you/ the employers can verify through our website. You can also have your imprinted certificate delivered via post. Although there is no expiry date on the certificate, we recommend that our learners renew the certificate every twelve months

Requirements

Microsoft Excel Simplified – 101 Tips course is Designed By Qualified Professionals

  • There are no academic entry requirements for this course, and it is open to students of all academic backgrounds
  • You’ll need an interest in accounts
  • Students will need to have Excel 2007 installed, as this is the system used in the teaching

Career Path

This Microsoft Excel Simplified – 101 Tips course opens a brand new door for you to enter the relevant job market and also provides you with the chance to accumulate in-depth knowledge at the side of needed skills to become flourishing in no time. You will also be able to add your qualifications to your CV to enhance your career and become more competitive in your chosen industry. This course will impact your career in the following way,

  • Opens career opportunities in the relevant fields
  • Makes you credible in any workplace seeking excel

Course Curriculum

Introduction to the course and your tutor
Introduction to What We’ll Cover and How 00:03:00
Data
Enter numbers and fractions 00:05:00
Dates and Times 00:08:00
Name Cells and Ranges 00:04:00
Validate Data entry using a pick list 00:08:00
Extend a series of dates with autofill 00:05:00
Add a symbol or special character 00:04:00
Compare multiple spreadsheets using freeze panels 00:07:00
Hide rows 00:05:00
Keyboard 00:10:00
Speak Cells 00:04:00
Find and replace data 00:11:00
Formulas and Functions
Add values 00:04:00
Function wizard 00:07:00
Formulas with comments 00:05:00
OneNote 00:06:00
Define a constant 00:05:00
Apply names in functions 00:05:00
Figure out the best loan terms 00:05:00
Internal Rates of Return 00:05:00
Nth largest value 00:04:00
Large, Small, Max, Min 00:05:00
Conditional formula 00:03:00
Conditional formula with names 00:04:00
Count If 00:03:00
Conditional sum 00:03:00
Inner calculator 00:03:00
Square Roots 00:04:00
Calculate the duration between two times 00:05:00
Calculate days between two dates 00:05:00
Copying Data / Formats etc.
Copy a range 00:03:00
Transpose a row into a column 00:02:00
Copy styles to another workbook 00:08:00
Chart formatting 00:08:00
Paste special and copying worksheets 00:07:00
Track changes while Editing 00:07:00
Lists
Enter list data using a form 00:05:00
Searching through a data list 00:05:00
Import a word list into excel 00:05:00
Sort a list 00:02:00
Filter a list 00:03:00
Sort by multiple criteria 00:03:00
Find averages in a sorted group 00:06:00
Filter by multiple criteria 00:04:00
Remove duplicate records from a list 00:04:00
Count filtered records 00:07:00
Filter by multiple criteria in the same column 00:05:00
Chart a filtered list 00:03:00
Look up information in a List 00:06:00
Data Patterns
Create a PivotTable 00:06:00
Modify a PivotTable and layout 00:03:00
Find the average of a field 00:04:00
Create a calculated field 00:02:00
Calculated fields and charts 00:02:00
Hide rows and columns in a PivotTable 00:02:00
AutoFormat a PivotTable 00:04:00
Create a PivotChart 00:04:00
Turning on the Data Analysis function so that statistical information can be run 00:03:00
Describe Data with Statistics 00:03:00
Discover associations within your data 00:04:00
Product Numbers 00:02:00
What-if analysis 00:06:00
Goal seek 00:07:00
Creating Charts
Create a Chart 00:06:00
Modify Chart details 00:05:00
Change the Chart Type 00:04:00
Add a Trendline to a Chart 00:07:00
Remove Chart Data 00:02:00
Add chart data 00:03:00
Missing chart data 00:05:00
Error bars 00:04:00
Pull a slice from a Pie Chart 00:04:00
Label slices of a Pie Chart 00:05:00
Histogram 00:07:00
Paste a chart into Word 00:04:00
Amending a chart in Word 00:03:00
Paste-link a Chart into Word 00:05:00
Worksheets
Format Numbers as Percentages 00:04:00
Format Currencies in Currency and Accounting Formats 00:04:00
Format Column Headings 00:06:00
Format Quickly with Format painter 00:03:00
Insert a background image into your worksheet 00:03:00
Create a Transparent image 00:04:00
Saving and Printing Worksheets
Save a workbook as a Template 00:07:00
Save a workbook as an XML spreadsheet 00:06:00
Print multiple cell ranges on One Page 00:04:00
Page set up, header, footer, margins – 1 page printing 00:05:00
Print multiple areas of a workbook 00:08:00
Print multiple worksheets of a workbook 00:02:00
Repeat Headings of a Row or Column 00:08:00
Print functions to show calculations & comments 00:08:00
Extending Excel
Hyperlink a worksheet to another office document 00:03:00
Embed a chart within PowerPoint 00:03:00
Publish an Interactive Workbook 00:06:00
Importing data from a Web Site or Access Database 00:03:00
Import a Worksheet into Access 00:09:00
Use Excel Data to create labels in Word 00:10:00
Customizing Excel
Launch a specific Workbook when Excel Opens 00:04:00
Save Time by Creating a Custom View 00:04:00
Create a Custom Number Format 00:07:00
Changing Text to Columns 00:06:00
Create a Macro to Format Numbers 00:07:00
Next steps
What to study next – Excel advanced 00:02:00

Course Reviews

4.8

4.8
9 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

152 STUDENTS ENROLLED

Advanced Course Search

Popular Courses

Copyright © 2021 SkillExpress
Select your currency
GBP Pound sterling