Certification Course. Excel Essential Training Learn how to enter and organize data, create formulas and functions, build charts and PivotTables, and use other powerful Excel features.
Course Overview Reviews Description In this course, you will learn: How to best enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data and cells, and build charts and PivotTables. Syllabus: Introduction Using the exercise files 1. Getting Started with Excel What is Excel used for? Formatting Exploring font styles and effects Adjusting row heights and column widths Working with alignment and Wrap Text Designing borders Exploring numeric and special formatting Formatting numbers and dates Using conditional formatting Creating and using tables Inserting shapes, arrows, and other visual features 5.
Adjusting Worksheet Layout and Data Inserting and deleting rows and columns Hiding and unhiding rows and columns Moving, copying, and inserting data Finding and replacing data 6.
Charts Creating charts Exploring chart types Formatting charts Working with axes, titles, and other chart elements Creating in-cell charts with sparklines New charts in Excel 8.
Adjusting Worksheet Views Freezing and unfreezing panes Splitting screens horizontally and vertically Collapsing and expanding data views with outlining 9. Multiple Worksheets and Workbooks Displaying multiple worksheets and workbooks Renaming, inserting, and deleting sheets Moving, copying, and grouping sheets Using formulas to link worksheets and workbooks Locating and maintaining links How do I fix this?
AutoSave often takes longer than 1 minute, even when set to 1 minute. Updating your version of Excel is covered at the start of the course. Our free Basic Skills course is a great place to start. You can find it by clicking here.
If you want to continue after finishing Basic Skills you can move on to our Essential Skills course, which covers all of the most important Excel skills. If you want to go even further after finishing Essential Skills you can then continue to our Expert Skills course.
If you complete Expert Skills you will be able to use absolutely every feature of Excel. Dear Mr Smart, I have just bought your excel essential skills, I have downloaded the samples as per instructions but unfortunately I am unable to unzip the files to begin the exercises, I did not have any issues on the previous version of , please advise how do I go about resolving this issue.
Sample Files Free Basic Skills tutorials. Contact Site Map. I am still using a retired Excel version , or I am still using a retired Excel version , , or Excel tutorials. The only Excel books you will ever need.
Download today. The only constantly updated Excel titles more… Thoroughly covers Power Pivot and Power Query more… Covers business intelligence and OLAP features more… Simple, easy, understandable, 2-page lessons more… Available as both printed books and e-Books more… Used by schools, colleges and universities more… Available for , , and Mac versions more…. Book, e-Book and Video Tutorial. The book and e-book have identical content. Select any of the items below to preview the contents of this book.
ISBN: Table of Contents. Front Cover. Why you should use this book. Back Cover. Download Sample Files. How to use the course. Download an e-book. Buy and download the e-book. Buy a printed book. From Amazon. From the Book Depository Worldwide.
0コメント