Excel Simplified - 101 Tips

Course details

This course is aimed at the excel user who already knows the basics of Excel 2007. This course will help you to go beyond the basics - to reach a higher-intermediate level. With shortcuts, tricks and tips - you will be able to work smarter and ;

If you want to be fairly competent on the software, then this course will be very handy. It's a lot quicker to be shown things, then to try and muddle through and work things out by yourself. Guaranteed, there'll be some items which we cover, that you have no idea that Excel was capable of doing!

We don't want you to spend a day of your life in the learn 100+ quick and very useful, practical things which you can apply on your job or on your projects.

We'll cover:

• Working with Data - using series, symbols and special characters, hide rows and freeze panels
• Formulas and Functions - Calculate the duration between two dates/times, best loan terms, create conditional formula and conditional sums
• Copying Data - transposing rows into columns and paste specials
• Using Excel lists - sort and filter a list, remove duplicate records, count filtered records, look up information in a list
• Data Patterns - Pivot tables, pivot charts, what-if analysis
• Creating charts - histogram, trendlines, piecharts, error bars
• Presenting data - formatting columns and numbers
• Saving and printing worksheets - printing multiple worksheets, area, cell ranges, repeat headings of a row or column
• Extending excel - hyperlinks, embed a chart, importing a worksheet
• Customizing Excel - custom workspace, custom view, macros

Course Curriculum

This Course will cover some of the following topics:-

Section 1: Introduction to the course and your tutor

• Introduction to what we'll cover and how
• Downloadable Resource

Section 2: 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

Section 3: 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

Section 4: 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

Section 5: 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

Section 6: 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 info can be run
• Describe Data with Statistics
• Discover associations within your data
• Product Numbers
• What-if analysis
• Goal seek

Section 7: 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

Section 8: 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

Section 9: 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 setup, 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

And more…...


Benefits

Edplx has connections and great business relationships with respectable companies within the job industry. This plays an important role in assisting all our students searching for internships, apprenticeships and part/full time jobs. We also provide all our students with the opportunities to speak to our talented career advisors and experts. You will also be invited to career fairs to give you the chance to present yourself to potential employers, once you sign up for it.

Certification

Upon completion of the course, internationally recognised certificates that can be traced by employers are available upon completion.

Who is this Course for

This course is suitable for those who have a basic level with Excel and want to learn other handy functions and features. We use Excel 2007 only in this course. If you have Excel 2003, this course will be difficult to follow as although the functions and features exist in 2003, the layout changed very dramatically between the two versions. Excel 2007 isn't too dissimilar from 2010. Updated on 31 January, 2023