Excel Level 1

Service Description

Microsoft Excel Level 1 / Intro (2016, 2019, Office365) Join my full day online Microsoft Excel Introductory class designed for beginners and those looking to refresh or upgrade their skills. Whether you are new to Excel or just need a refresher, this comprehensive course will cover all the essentials you need to know. I will guide you through the basics of creating spreadsheets, formatting data, using formulas and functions, and analyzing data with charts and graphs. By the end of the class, you will have a solid foundation in Excel and be equipped with the necessary skills to navigate and utilize this powerful software efficiently. Don't miss out on this opportunity to enhance your Excel proficiency from the comfort of your own home. Sign up now and unlock your potential with Excel! Course Outline: 1. Create, Open, and Save Workbooks: • Understanding Excel • Creating a New Blank Workbook • Generating a Workbook from a Template • Opening Excel Files • Utilizing Help Features • Saving Workbooks • Navigating Through Workbooks 2. Explore the User Interface: • Backstage View* • Overview of the Ribbon • Mini Toolbar • Status Bar • Shortcut Key Tips • Contextual Tabs 3. Work with Data: • Entering, Editing, and Deleting Data • Various Data Selection Methods • Utilizing Autofill and Autocomplete • Cut, Copy, Paste, and Paste Special • Resizing Columns and Rows • Inserting and Deleting Columns, Rows, Cells • Undo, Redo, and Repeat Functions • Spellcheck and AutoCorrect • Finding, Replacing, and Using Go To • Basic Functions • SmartTags and Options Buttons • Adding, Editing, and Removing Comments 4. Format A Workbook: • Formatting Using the Home Ribbon • Utilizing the Mini-Toolbar • Formatting Through Dialog Boxes • Using and Modifying Conditional Formatting • Using the Format Painter • Creating and Modifying Styles • Adding, Naming, Moving, Deleting, and Coloring Sheets 5. Charts: • Creating and Formatting a Chart • Modifying Chart Layout and Structure • Changing Chart Types, Options, Location, and Data Source • Saving a Chart as a Template 6. Printing and Viewing A Workbook: • Using the View Ribbon • Splitting and Freezing Panes • Managing Multiple Windows • Utilizing Page Layout, Print Preview, and Basic Print Options • Adding Headers and Footers 7. Customization: • Customizing the Ribbon & Quick Access Toolbar