Overview:

Are you struggling to learn how to use Microsoft Excel? Don’t know where to start? If you are new to Excel and have no idea how to get started or have never had any formal training, this course is for you.

Navigating the Excel environment is the first step. Start by learning how to create spreadsheets from scratch, enter different types of data, and format cells using colors, fonts, and borders. Learn how to perform fundamental tasks like sorting and filtering. Mastering essentials for creating basic formulas and functions, using calculations like SUM, AVERAGE, MIN, MAX, and COUNT are also keys to building a strong foundation for using Excel effectively in various settings.

This is an Online, Live presentation using Excel Office 365.

Why you should Attend: Unlock the power of Excel! If you are intimidated by spreadsheets or are struggling with how to get started, learning the basics of how Excel works will help ease that anxiety. Excel is used in marketing, sales, finance, or other relevant fields so once you can confidently set up columns and rows of data, you can then learn to analyze that data, create compelling spreadsheets, and automating tasks. Knowing how to use Excel to create dynamic spreadsheets will help boost your business and career to new heights.

Agenda:

• Overview of the Excel Interface
• Rows, Columns, & cells
• Entering different types of data (Text, Numbers, & Dates)
• Working with Rows & Columns
• Find & Replace Options
• Creating basic formulas
• Working with Functions
• Working with Ranges
• Formatting (Bold, Colors, Borders, etc.)
• Chart Basics
• Sorting & Filtering
• Working with sheets
• Saving and Printing

Who Will Benefit:

• New Excel Users
• Anyone who has never had any formal Excel Training
• Anyone wanting to Learn how to create a Good Foundation for writing Formulas