Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
4 Hour(s) 39 Minute(s)
Language
English
Taught by
IsáBel .
Certificate
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
Course Overview
Customizing the User Interface, Functions, Custom Formatting, Data Validation, PivotTables, Charts, Macros, Printing , +
Supercharge Your Excel Skills: Work Faster, Stress Less!
Are you ready to unlock the true potential of Excel?
If you’re looking to work more efficiently and effectively, this course is designed just for you!
By the end of this course, you’ll master over 70 powerful techniques to enhance your Excel experience, including:
Navigate with Ease: Discover tips for faster navigation and learn how to better organize your workbooks for maximum efficiency.
Time-Saving Analysis Tools: Explore essential tools and formulas that will save you hours in data analysis.
Data Validation Mastery: Implement data validation to ensure accuracy and restrict what users can enter into your workbooks.
Conditional Formatting: Use conditional formatting to highlight key data points for quicker, clearer analysis.
Create Tables and Charts: Learn to build tables and charts swiftly, and discover the magic of sparklines and secondary axes.
Effortless PivotTables: Experience the simplicity of creating PivotTables to analyze your data like a pro.
Printing Done Right: Master printing techniques to present your work beautifully.
Intro to Macros: Get started with simple macros to automate repetitive tasks and save even more time.
... and so much more!
Join over 3,900 others who have transformed their Excel skills and become more productive users.
Enroll now and take the first step toward mastering Excel—work faster, reduce stress, and unleash your full potential!
Course Content
- 13 section(s)
- 86 lecture(s)
- Section 1 Latest Excel Time Savers Quick Tip
- Section 2 Welcome to Excel: Core Data Analysis, and Workbook Customization
- Section 3 Excel Navigation, Workbook Environment, & Worksheet Skills
- Section 4 Useful Tips on Excel Formulas & Functions
- Section 5 Using Data Validation for Data Entry in Excel
- Section 6 Special, Custom, and Conditional Formatting in Excel
- Section 7 Excel Tables & Lists
- Section 8 Excel Charts
- Section 9 Excel PivotTables & PivotCharts
- Section 10 Printing Excel Data
- Section 11 Protecting Excel Files
- Section 12 Excel Macros
- Section 13 Wrap Up!
What You’ll Learn
- Exercise Files Included!
- QUICKLY Navigate Through Your Excel Workbooks
- SAVE TIME with Keyboard Shortcuts
- TRACK the Changes Users Make to Your Spreadsheets
- CREATE a Data Entry Form Fast with Excel's Built-In Form Tool
- CREATE Functional Tables with a Couple of Keystrokes
- SORT Data with Your Own Custom Sort Lists
- QUICKLY Format Your Charts
- CREATE PivotTables & PivotCharts
- SET UP Printing the Way You Want
- PROTECT Your Excel Workbooks
- CREATE Simple Time-Saving Macros
- ... and much more!
Skills covered in this course
Reviews
-
LLuis Moreno
Instructor is very knowledgeable and lessons are short, concise and to the point. I learned a few new tricks that saved me some time. Thank you!
-
GGeorge Emil Circu
Everything is very clear. Moreover I learned a lot of tricks. You deserve more than 5 stars, thanks a lot!
-
CCristian Croitoru
Very informative but the playback is a bit glitchy... Sometimes can be fixed by reloading the lecture page, sometimes by skipping ahead, sometimes it cannot. I viewed all 80 odd lectures at 1.5 speed and that was comfortable for me. Many thinks I was already aware of but still there was a lot of new information that was worth my time. Thanks!
-
HHuangchun Tseng
One of the best Excel courses focuses on tips. Instruction presentation (audio, video, contents) is well and carefully designed for students to easily understand. Working files are attached for download. After having this course, I am looking forward to have advanced Excel courses made by IsaBel.
