Create sophisticated spreadsheets
What does the course cover?
Numbers offers intuitive organisation features, allowing users to focus more on analysis and presentation, trough dynamic methods that Numbers offers to visualize your data.
Explore the important features of this spreadsheet application and learn about the new tools for formula development and charting thanks to this course. Master the new functionality of charts, tables, and templates, and learn how to make spreadsheets effective and eye-catching. Work collaboratively with faraway colleagues or in projects using both Numbers and Microsoft Excel and don’t think about the file format you’ll work easily with both Mac and iOS. At the end of this course, you can share a link of your work via Mail, Twitter or Facebook.
Discover the versatility of this application. Let your data tell a story and convert numbers into something attractive, trough this course.
Each course contains high quality, professional, Live demo’s, Downloadable exercise files and Real-world templates for you to use.
Course detail and sample lessons
Section 1: Getting Started with Numbers
Lesson 2: Launching Numbers
Lesson 3: Exploring Templates Options
Lesson 4: Exploring the numbers interface
Lesson 5: Sheet Management
Lesson 6: Saving and closing a numbers file
Section 2: Entering Values
Lesson 2: Entering and Editing Text
Lesson 3: Formatting Numbers & Dates
Lesson 4: Formatting borders & shading
Lesson 5: Conditional Formatting
Lesson 6: Autofill options
Section 3: Tables
Lesson 2: Headers and Footers in a table
Lesson 3: Formatting a table
Lesson 6: Formulae in table footer
Lesson 7: Merge and Unmerge Cells
Section 4: Formulae
Lesson 2: Basic Operators
Lesson 3: Basic Functions
Lesson 4: Max, Min and Count Functions
Lesson 5: Absolute Referencing
Lesson 6: Named Cells in a table
Section 5: Using Charts
Lesson 2: Inserting and Deleting Charts
Lesson 3: Changing the chart type
Lesson 4: Formatting the chart options
Lesson 5: Formatting the axis and the series
Section 6: Proofing Tools
Lesson 2: Using Spell Checker
Lesson 3: Find and Replace tool
Section 7: Printing Tools
Lesson 2: Printing Options
Lesson 3: Headers, Footers and Page numbering
When you pass that you will receive an internationally recognised accreditation certificate like this:
Want to start learning today?
Joining is simple, easy and risk free with our 7 day money back guarantee.