Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
This course is intended for complete beginners who want to learn excel but don't have enough time while doing it. The information is explained in the most practical way and most of the videos are really short (less than 3 minutes) so you can take a look at them every time you get a change, so you can learn at your own pace. We will start from scractch You will learn evreything from getting to know the elements of the workbook apply basic formatting,freeze panes, creating custom views, working with formulas, inserting hyperlinks, page breaks, sorting, filtering, wrapping compare sheets etc.
You will be provided with material to work ( the same workbooks used on the videos)so you can practice while you watch the lessons.
We all know that Excel has become a necessity in our working lives so whether you are a student or you are already working, knowing Excel will boost your curriculum and your probablities of finding and keeping a job will definitely improve
There is no pre-requisite for this course. A complete new beginner can start this course.
I will be answering your doubts and questions so you can feel free to ask anything related to the course.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Introduction|
What we'll be coveringPreview
|Section 2: Getting Started|
Starting a workbook
Knowing the workbookPreview
The Backstage view
Backstage.2 Share via e-mailPreview
Backstage.3 Inviting peoplePreview
Opening a workbook
Saving a workbook
|Section 3: Basic Worksheet skills|
Selecting Data and No Contiguous groups of cellsPreview
Naming and moving worksheets
Copy & Paste
Entering Data using fills
Changing the default folder for opening & saving
|Section 4: Creating a Workbook and Formatting|
Formatting the basics
Creating a Table
Editing a Table
Changing column width and row height
Wrapping, Merging and Orienting text
Insert move & delete rows & columns
|Section 5: Formulas|
Introduction to formulas
Order of operations
Relative and absolute references
Introduction to Functions
|Section 6: Working with big workbooks|
Using the clipboard
Grouping & Hiding
Handling multiple workbooks
Find & Replace
Check the spelling
Creating a Custom view
Creating Hyperlinks to another workbook
|Section 7: Printing|
Page Lay out view
Working with headers
I am an Industrial Engineer, I have more than 6 years teaching Excel and the rest of the Office Suite online. Working as an Industrial Engeneer, you have to make Excel your best friend whether to use it in statistical process, logistics, human resources, purchasing, sales and other departments to maximize productivity so I have gain a lot experience and expertise in Excel that i would like to pass this knowledge to you.
I like to explain using simple words and going straight to the point, that makes it easier for my students to understand the information quickly
I have made my curriculum boosted by my knowledge of the Office Suit, specially with excel, this little tool is a big plus for the companies, so my recomendation if you are not familiar with this software, is not only to learn how to use it but to be an expert, or at least try to be.
I speak English, Spanish, and Portuguese, I love Web Programming