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.
The course will be taught from a practical standpoint with an emphasis on real-life problems that business owners or professionals encounter on a daily basis. If your work, assignments or projects require a lot of Excel usage, regardless if you are a student, professional or business owner, then this course is for you!
Some of the topics that will be covered are the following:
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Part 1: Getting Started in Excel|
Starting Excel, maneuvering in Excel via mouse and keyboard, entering dataPreview
Zooming in and out, saving, and printing Excel filesPreview
Formatting data (font type, font size, bold, italics, underline, highlighting)Preview
Formatting numbers (custom formatting, percentages)Preview
Formatting data (alignment, wrap text, merge & center and alt. to merge & center
Adding rows and columns
Changing row height and column width
Copy & paste, cut & paste and paste special
Excel sheets: adding, activating a sheet, hiding, naming, moving and coloring
Excel sheets: locking
Sort, custom sort and filters
Hiding and unhiding rows and columns
Grouping and ungrouping rows and columns
Work with ranges or multiple cells
Printing: Selecting a range, margins, page layout, and headers and footers
|Section 2: Formulas in Excel|
How to enter formulas, sum, product, quotient, average, median
Count, min, max
Simple if statements
Nested if statements
Defining a name, vlookup
Replace and substitute
Left and right
|Section 3: Extra Features|
Creating pivot tables
Updating data in pivot tables
Trace dependents and trace precedents (Excel shortcuts in downloadables)