Excel - Level 1 Course



Course Details:

Length: 1 day

Price: $275/person (USD)

Bundle & Save: View Bundle

Group Price: Request Quote

Training Reviews

Course Features:

Live Instructor Teaching

Certificate of Completion

Digital Badge

Courseware: Print

Free 6 Month Online Retake

Hands-On Learning?: Yes

Software Lab Included?: Yes

Delivery Methods:

Live Online

Individuals and Groups
@ Your Location

Onsite for Teams

Group Teams
@ Your Organization

This is an instructor-led course. It is taught by an instructor live online or at organizations for groups.
For team training, we can teach onsite at your office or private live online.

 

Course Overview

This course will introduce students to spreadsheets and the fundamental concepts of Microsoft Excel. Learn these features of Microsoft Excel and get more done quickly. Learn how to: Quickly set up workbooks, enter data, and format it for easier viewing, Perform calculations and find and correct errors, Visualize data with charts and graphs, including new sunbursts, waterfalls, and treemaps, and Print worksheets and charts.


Register Early: Registration Deadline is 2 Weeks Prior to Class Start.

Course Notes

Versions That Can Attend: Desktop Version of Office 2021, 365, 2019, 2016 (Microsoft Windows PC or Macintosh)
Course Taught With: Desktop Version of Office version 365/2019 (Microsoft Windows PC) Software and Courseware


Knowledge Prerequisites

• To ensure your success in this course, you should have end-user skills with any current version of Windows, including being able to start programs, switch between programs, locate saved files, close programs, and use a browser to access websites. You can obtain this level of skills and knowledge by taking the Windows for End Users Course.

Suggested Follow-Ons

Excel - Level 2
Excel - Level 3
Microsoft Office 365 Online (with Teams for the Desktop)

Related Certifications

MOS: Microsoft Excel Expert Certification
MOS: Microsoft Excel Associate Certification

Certification Notes: Certification exams are administered by third party testing companies. Our courses prepare you for the certification exam, which is an additional fee paid to the testing provider. You must contact the corresponding testing provider to take a certification exam.

Course Topics

Chapter 1: Set up a workbook - 3
Create workbooks
Modify workbooks
Modify worksheets
Merge and unmerge cells
Customize the Excel app window
• Manage the ribbon
• Manage the Quick Access Toolbar
• Customize the status bar
• Change the magnification level of a worksheet
• Arrange multiple workbook windows
Skills review
Practice tasks

Chapter 2: Work with data and Excel tables - 41
Enter and revise data
Manage data by using Flash Fill
Move data within a workbook
• Sidebar: Quickly access data-formatting commands
Find and replace data
Correct and fine-tune data
Define Excel tables
Skills review
Practice tasks

Chapter 3: Perform calculations on data - 71
Name data ranges
• Sidebar: Operators and Precedence
Create formulas to calculate values

Chapter 4: Change workbook appearance - 103
Format cells
Define and merge cell styles
Apply and modify workbook themes
Apply and modify table styles
Make numbers easier to read
Change the appearance of data based on its value
Add images to worksheets
Skills review
Practice tasks

Chapter 9: Create charts and graphics - 207
Create standard charts
Create combo charts
Create specialized charts
• Hierarchy charts
• Statistic charts
• Scatter charts
• Stock charts
• Map charts
Customize chart appearance
Identify data trends
Summarize data by using sparklines
Illustrate processes and relationships
Insert and manage shapes
Sidebar: Insert mathematical equations
Skills review
Practice tasks

Chapter 11: Print worksheets and charts - 285
Add headers and footers to printed pages
Prepare worksheets for printing
• Fit your worksheet contents to the printed page
• Change page breaks in a worksheet
• Change the page printing order for worksheets
Print worksheets
Print parts of worksheets
Print charts
Skills review
Practice tasks



Course FAQs

What Are the Available Class Formats?

This course is taught by a live instructor and is available in two class formats:

  1. Live Online for Individuals
  2. Onsite/Online for Private Groups

What Is an Excel Workbook?

An Excel Workbook is a collection of related data and information stored as one single file. It contains worksheets, which are composed of cells organized into rows and columns that can hold text, numbers, or formulas. With an Excel Workbook, users can easily visualize their data by creating charts and graphs. Additionally, with its powerful functionality, users can automate their workflow and perform data analysis. Overall, an Excel Workbook is a great tool to organize, analyze and efficiently present data.

The main benefit of using an Excel Workbook is its flexibility - it allows users to create tables, control formulas, and customize their views with ease. Additionally, users can use powerful built-in functions to calculate values such as sums, averages, and variances. Furthermore, Excel provides a variety of features to make it easier for users to sort and filter their data.

In addition to its versatility and flexibility, an Excel Workbook can also help reduce the risk of errors in your data. With its built-in error checking and alerting, users can detect any mistakes quickly, allowing them to make corrections as needed. Additionally, by using Excel's powerful auditing tools, users can track changes in their data and ensure accuracy.

What Is Excel Data and Tables?

Excel data and tables are collections of information that are organized in columns and rows, making them easy to read and use. Excel tables allow you to sort, filter, or pivot the data so that it can be better understood. They also provide helpful visualization tools like charts, graphs, and pie charts which help users make sense of the data quickly and accurately. With the help of Excel tables, users can easily and quickly analyze data to make better business decisions. Furthermore, Excel data and tables can be used for a variety of purposes such as financial analysis, sales forecasting, project management, and more. As such, Excel data and tables are essential tools for organizations to effectively organize and analyze information.

What Are Excel Calculations on Data?

Excel calculations on data allow businesses to analyze and interpret their data efficiently. These calculations can help with various tasks including budgeting, forecasting, reporting, and trend analysis. Excel calculations are an important part of any business’s data management strategy as they provide insights into the data that would otherwise be difficult or impossible to discern. Using Excel calculations, businesses can get a better understanding of their data and use that knowledge to make more informed decisions. Excel calculations can also be used to automate certain processes, such as those involving large sets of data. By automating these processes, businesses can save time and resources while gaining an even greater understanding of their data. Excel calculations are an invaluable tool for businesses looking to make the most of their data.

What Is Excel Spreadsheet Formatting?

Excel spreadsheet formatting is the process of organizing data within a spreadsheet so that it's easier to analyze and interpret. This includes things like adding titles, adjusting column widths, using colors, fonts, and borders for emphasis or clarity, freezing panes to keep certain rows or columns onscreen at all times, hiding rows or columns to focus on the necessary data, adding formulas to calculate values or totals, and using filters to help you find what you are looking for quickly. Formatting can take a lot of time, but it's worth the effort if you want your spreadsheet to be organized and professional-looking. With proper formatting, it is much easier to make sense of large amounts of data and draw meaningful insights. Excel offers a variety of tools to help users create visually appealing, organized spreadsheets that are easy to understand. With a little bit of practice, you can make your Excel spreadsheets look great and save yourself time in the long run.

The key to successful Excel spreadsheet formatting is consistency. Make sure that you are consistent with color coding, font size, and text alignment throughout the entire document. This will help readers quickly skim the data and get a good sense of what is happening. It will also make it easier for you to update the information in the future. With a few simple steps, you can turn your Excel spreadsheet into an organized, professional-looking document that will impress both colleagues and clients alike.

Good formatting can also help prevent mistakes when entering or manipulating data. If your cells are not labeled correctly, it can be easy to mix up numbers or even enter them in the wrong order. Formatting the spreadsheet correctly from the beginning will help ensure that all of your data is correct and organized.

Excel spreadsheet formatting is an important part of creating a professional report or presentation. By taking the time to format your spreadsheet correctly, you can ensure that your data is organized, easy to read and understand, and visually appealing. With a little bit of practice and some creative thinking, you can make your spreadsheets look great and save yourself time in the long run.

What Are Excel Charts and Graphics?

Excel charts and graphics are visual representations of data that enable quick insights and analysis. They provide a clear picture of the relationships between different pieces of information, allowing users to spot patterns, predict trends, and make better decisions. Charts come in various forms such as bar graphs, pie charts, histograms, line graphs, area plots, scatter plots, and more. Graphics such as icons and pictures can also be used to further illustrate important points or highlight key information. Excel provides a range of tools to help construct visually appealing charts and graphics that are easy to understand. These tools make it easier than ever for users to quickly create sophisticated visuals that accurately convey their message. By leveraging the power of Excel charts and graphics, users can make informed decisions backed up by solid data-driven evidence.

Additionally, Excel allows users to customize the look of their charts and graphics so they stand out from the crowd. By using formatting options such as color palettes, font sizes, borders, and shadows, users can create visuals that are eye-catching and professional. This makes it easier to effectively communicate complex information in a visual format that is easily understood by their audience. Excel charts and graphics provide an invaluable tool for users who want to make sense of the data they have at hand, helping them to make informed decisions with confidence.

Overall, Excel charts and graphics offer an effective way for users to quickly analyze data and gain insight into trends. They provide a powerful tool for making better decisions backed up by real evidence. By customizing the look of their visuals, users can create eye-catching visuals that succinctly communicate complex information clearly and understandably. Excel charts and graphics are invaluable for anyone wanting to gain a better understanding of their data.

What Are Printing Options for Excel Worksheets?

Printing Excel worksheets are a great way to quickly create a hard copy of your data. There are several options available depending on what you need the printed version for.

You can opt to print the entire document or just the selected area. Additionally, you can change page settings such as orientation and paper size, as well as page breaks, gridlines, and headings.

You can also customize the print area by selecting a range of cells to be included in the output. This allows you to focus on only the relevant data for your current needs. You can save time by not having to reprint or reformat large documents each time you make changes to a small portion of your data.

If you need to scale your worksheet, such as to fit on one page, you have the option to reduce or enlarge it by percentage to achieve the desired size. Furthermore, you can choose to print column and row labels so that they appear on each page.

Overall, Excel offers a variety of printing options to make sure that you get the exact output you need. Whether your goal is to save time or create an easily readable hard copy, there are plenty of features available to suit your needs.

By taking advantage of these print options for Excel worksheets, you can quickly and easily create a professional and organized hard copy of your data. This will help ensure that your work is accurate, efficient, and visually appealing.

Remember to preview the output before sending it to print to make any final adjustments or corrections. With these helpful tools at your disposal, you can confidently produce quality documents with ease.

Explore Microsoft Excel Training Classes Near Me:

 

Registration:

Have a Group?
Request Private Training

                                    

Start your training today!