Search

Excel: From beginner to intermediate [Free Online Course] - TechCracked

Excel: From beginner to intermediate

Learn the skills that Microsoft want you to know in Excel.



What you'll learn
  • Create, configure and save Excel worksheets and workbooks.
  • Navigate through and format worksheets and workbooks.
  • Customise options and views for worksheets and workbooks.
  • Configure Excel worksheets and workbooks to print (e.g. page setup).
  • Insert data into and format cells and ranges, and create and modify tables.
  • Highlight, filter, sort and group cells, ranges and tables.
  • Create and format Excel charts.
  • Insert and format objects, including modifying images.
  • Create formulas in Excel, including using conditional logic and modifying text.


Description

In this 11 hour course, learn how to:
Create and manage worksheets and workbooks
  • Create and navigate in Excel worksheets and workbooks,
  • Format worksheets and workbooks,
  • Customize options and views, and
  • Configure Excel worksheets and workbooks for distribution.
Manage data cells and ranges
  • Insert data into and format cells and ranges, and
  • Summarise and organize data in Excel .
Create tables
  • Create and manage tables,
  • Manage table styles and options, and
  • Filter and sort a table.
Perform operations with Excel formulas and functions
  • Summarize data,
  • Perform conditional operations, and
  • Format and modify text.
  • Excel Formulas such as COUNTIF, SUMIF, MIN etc. are translated into 15 different languages.
Create charts and objects
  • Create charts,
  • Format graphic elements, and
  • Insert and format objects in Excel .
The course will take about 10 hours to complete, plus will you need additional time to test yourselves to ensure that you have learned the necessary skills.

Also See : Excel Data Analysis Masterclass with Excel Dashboards

Enroll Now

Post a Comment

0 Comments