Microsoft Excel Level 1
This course is designed for people preparing for certification as a Microsoft Certified Application Specialist in Excel, who already have knowledge of Microsoft® Office, Windows (or above), and who desire to gain the skills necessary to create, edit, format, and print basic Microsoft Office Excel 2007, 2010, 2013 and 2016 worksheets.
Lesson 1: Creating a Basic Worksheet
- Explore the User Interface and the Ribbon
- Navigate and Select in Excel
- Obtain Help
- Enter Data and Save a Workbook
- Customize the Quick Access Toolbar
Lesson 2: Performing Calculations
- Create Basic Formulas
- Calculate with Functions
- Copy Formulas and Functions
Lesson 3: Modifying a Worksheet
- Manipulate Data
- Insert and Delete Cells, Columns, and Rows
- Search for Data in a Worksheet
- Spell Check a Worksheet
Lesson 4: Formatting a Worksheet
- Modify Fonts
- Ali Borders and Color to Cells
- Change Column Wiph and Row Height
- Apply Number Formats
- Position Cell Contents
- Apply Cell Styles
Lesson 5: Printing Workbook Contents
- Print Workbook Contents Using Default Print Options
- Set Print Options
- Set Page Breaks
Lesson 6: Managing Large Workbooks
- Format Worksheet Tabs
- Manage Worksheets in a Workbook
- Manage the View of Large Worksheets
Microsoft Excel - Essentials
The class will teach you how to create and modify worksheets, enter complex formulas, create Pivot tables and Charts, inserting objects, and working with tables. Our small classes allow everyone more time to interact with the instructor, learn faster, and more effectively.
Includes essential topics from level 1 & 2
