Microsoft Excel Simplified – 101 Tips

Skill Express Ltd

Course

Online

Save 90%
£ 20 VAT inc.

The best Excel courses

See all

See all

Description

  • Type

    Course

  • Level

    Intermediate

  • Methodology

    Online

  • Class hours

    8h

  • Duration

    Flexible

  • Start date

    Different dates available

  • Online campus

    Yes

  • Delivery of study materials

    Yes

  • Support service

    Yes

  • Virtual classes

    Yes

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.

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.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

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

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

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

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

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

After completing the course successfully, the learner will immediately receive an E-Certificate which will be completely free of cost. Also, you can have your printed certificate delivered by post. Although there is no expiry date on the certificate, we do recommend our learners to renew the certificate every twelve months.

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

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Emagister S.L. (data controller) will process your data to carry out promotional activities (via email and/or phone), publish reviews, or manage incidents. You can learn about your rights and manage your preferences in the privacy policy.

Reviews

Subjects

  • Excel
  • Word
  • Access
  • Microsoft Excel
  • Printing
  • Microsoft excel training
  • MS Excel
  • Ms Word
  • Character
  • Spreadsheets

Course programme

Curriculum

Introduction to the course and your tutor
  • Introduction to What We’ll Cover and How
Data
  • Enter numbers and fractions
  • Dates and Times
  • Name Cells and Ranges
  • Validate Data entry using a pick list
  • Extend a series of dates with autofill
  • Add a symbol or special character
  • Compare multiple spreadsheets using freeze panels
  • Hide rows
  • Keyboard
  • Speak Cells
  • Find and replace data
Formulas and Functions
  • Add values
  • Function wizard
  • Formulas with comments
  • OneNote
  • Define a constant
  • Apply names in functions
  • Figure out the best loan terms
  • Internal Rates of Return
  • Nth largest value
  • Large, Small, Max, Min
  • Conditional formula
  • Conditional formula with names
  • Count If
  • Conditional sum
  • Inner calculator
  • Square Roots
  • Calculate the duration between two times
  • Calculate days between two dates
Copying Data / Formats etc.

  • Copy a range
  • Transpose a row into a column
  • Copy styles to another workbook
  • Chart formatting
  • Paste special and copying worksheets
  • Track changes while Editing
Lists
  • Enter list data using a form
  • Searching through a data list
  • Import a word list into excel
  • Sort a list
  • Filter a list
  • Sort by multiple criteria
  • Find averages in a sorted group
  • Filter by multiple criteria
  • Remove duplicate records from a list
  • Count filtered records
  • Filter by multiple criteria in the same column
  • Chart a filtered list
  • Look up information in a List
Data Patterns
  • Create a PivotTable
  • Modify a PivotTable and layout
  • Find the average of a field
  • Create a calculated field
  • Calculated fields and charts
  • Hide rows and columns in a PivotTable
  • AutoFormat a PivotTable
  • Create a PivotChart
  • Turning on the Data Analysis function so that statistical information can be run
  • Describe Data with Statistics
  • Discover associations within your data
  • Product Numbers
  • What-if analysis
  • Goal seek
Creating Charts
  • Create a Chart
  • Modify Chart details
  • Change the Chart Type
  • Add a Trendline to a Chart
  • Remove Chart Data
  • Add chart data
  • Missing chart data
  • Error bars
  • Pull a slice from a Pie Chart
  • Label slices of a Pie Chart
  • Histogram
  • Paste a chart into Word
  • Amending a chart in Word
  • Paste-link a Chart into Word
Worksheets
  • Format Numbers as Percentages
  • Format Currencies in Currency and Accounting Formats
  • Format Column Headings
  • Format Quickly with Format painter
  • Insert a background image into your worksheet
  • Create a Transparent image
Saving and Printing Worksheets
  • Save a workbook as a Template
  • Save a workbook as an XML spreadsheet
  • Print multiple cell ranges on One Page
  • Page set up, header, footer, margins – 1 page printing
  • Print multiple areas of a workbook
  • Print multiple worksheets of a workbook
  • Repeat Headings of a Row or Column
  • Print functions to show calculations & comments
Extending Excel
  • Hyperlink a worksheet to another office document
  • Embed a chart within PowerPoint
  • Publish an Interactive Workbook
  • Importing data from a Web Site or Access Database
  • Import a Worksheet into Access
  • Use Excel Data to create labels in Word
Customizing Excel
  • Launch a specific Workbook when Excel Opens
  • Save Time by Creating a Custom View
  • Create a Custom Number Format
  • Changing Text to Columns
  • Create a Macro to Format Numbers
Next steps
  • What to study next – Excel advanced
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!

See related categories

Microsoft Excel Simplified – 101 Tips

£ 20 VAT inc.

The best Excel courses

See all

See all