Excel Simplified - 101 Tips
101 quick tips and tricks to master Excel 2007.
Office Productivity,Microsoft,Excel
Lectures -102
Resources -12
Duration -7 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
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 faster.
If you want to be fairly competent on the software, then this course will be very handy. Its 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 classroom... learn 99 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
The target audience is 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.
Where necessary, we provide a spreadsheet - but as long as you have Excel 2007, you'll be able to copy and do exactly what you see on the screen by pausing the video and following along.
The course will take approx 7.5 hours to complete.
Take this course if you want to take your basic understanding of Excel to a higher intermediate-level.
Goals
- Work with Formulas and Functions
- Copy data and formats
- Use excel lists
- Create charts
- Present worksheets nicely
- Save and print worksheets
Prerequisites
- Students will need to have Excel 2007 installed, as this is the system used in the teaching
![Excel Simplified - 101 Tips Excel Simplified - 101 Tips](https://d3mxt5v3yxgcsr.cloudfront.net/courses/3825/course_3825_image.jpg)
Curriculum
Check out the detailed breakdown of what’s inside the course
Introduction
1 Lectures
-
Introduction 02:47 02:47
Data
11 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Formulas and Functions
18 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Copying Data, Formats etc.
6 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Lists
13 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Data Patterns
13 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Creating Charts
14 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Worksheets
6 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Saving and Printing Worksheets
8 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Extending Excel
6 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Customizing Excel
5 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Instructor Details
![Lisa Newton](https://www.tutorialspoint.com/assets/profiles/227404/profile/200_243461-1596604602.jpg)
Lisa Newton
Lisa Newton BA MSc AAT has a masters degree in Investment Management and a first class honours degree in Accounting with Marketing. She formed her first company in 2004 with £150 in the same month of graduating from City University, London UK. Lisa has never had a full time 9 to 5 job in her life. She's a serial entrepreneur and author who holds directorships in various industries including telecoms, property management, publishing, hair & beauty as well as finance. She has won various awards in Business including: Young Entrepreneur of the Year Award 2007, in 2008 Enterprising Business Award, in 2016 BE Mogul Award and has been nominated and shortlisted in numerous others. In 2011 and in 2012 one of her companies won Best Accounting Franchisor Award. In 2015 and 2017 one of her companies won Best Bookkeeping Business London (Accountancy International Awards).
Lisa's books include: How to write a book in two weeks, Constant Cashflow, Make the most of your money, How to start your own bookkeeping business, Cosmic ordering with Vision Boards, How to Franchise Your Business and Quickbooks Online The Handbook. Some of the books are in audio-format on itunes and audible.
Lisa hosts her own show The Authors Podcast which can be found on the iTunes channel.
Lisa supports the charity The MS Society. A speaker, coach, consultant and an avid networker, Lisa enjoys meeting people and working on projects with like-minded individuals.
In her spare time, Lisa likes traveling, dancing salsa, writing books, learning languages, meditation, yoga and cosmic ordering.
Course Certificate
Use your certificate to make a career change or to advance in your current career.
![sample Tutorialspoint certificate](/market/public/assets/newDesign/img/primePacks/V-certificate.png)
Our students work
with the Best
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfc bank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfcbank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now![Annual Membership Annual Membership](/market/public/assets/newDesign/img/membership-large-small.jpg)
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now![Online Certifications Online Certifications](/market/public/assets/newDesign/img/traning-for-a-team.png)