MICROSOFT EXCEL
Excel Levels 1-3
Our Excel courses are designed to help you master this powerful spreadsheet software and unlock its full potential. Say goodbye to frustrations and inefficiencies and welcome a world of seamless data management and analysis. Investing in learning Microsoft Excel is a wise decision that will pay off in your personal and professional life.
Excel Level 1
Level 1 Excel, for beginners. Become more comfortable and more confident with Microsoft Excel.
Enroll Now
1.The Basics
- The components of Excel
- The Excel screen
- Navigating in Excel
2. Selecting Data
- Use Zoom Control to view your data
- Select Non Adjacent cells for quicker formatting
- Select one or more
- Columns and Rows
- Select a Large Range of cells
- Learn several methods of Cut, Copy & Paste
- Use Drag & Drop to quickly move data in your worksheet
3. Formatting Worksheets
- Insert one or more Rows and Columns
- Resize Columns and Rows to best fit your data
- Change the format of your data
4. Formulas
- Create Formulas
- Learn the difference between Relative & Absolute Addressing
- Use AutoSum to quickly add your figures
- Use AutoFill to save time
5. Printing Worksheets
- Preview the output of your workbook
- Use Headers and Footers for a more professional look
6. Working with Large Spreadsheets
- Freeze Panes to help keep your data in the right place
- Split a Worksheet to see different parts of your data at the same time
Excel Level 2
Ready to learn more Excel? Take the Excel level 2 or intermediate training. Feel like you need to get more out of it? Learn Functions, Charts, Filtering & much more.
Take Our Assessment
1. Auto Features
- Autocorrect to type quicker
- Autocalculate to see the quick answer
- Autocomplete and Pick List so there is no more retyping
2. Data Functions
- Custom Sorts
- Filter out specific records using AutoFilter
- Create instant Subtotals & Grand Totals
3. Advanced Formulas
- Learn the difference between Relative & Absolute Addressing
4. Functions
- Using built-in Insert Function
- Mathematical functions such as Round
- Use Financial functions to calculate a loan payment
- Logical functions using IF
- Create formulas using Date & Time functions
- Automatically display information from another spreadsheet using Table Lookups
5. Auto Spreadsheets
6. Multiple Spreadsheets
- Add data together using Paste Special
- Linking worksheets within the same workbook Linking worksheets with another file.
- Grouping Data to enter quickly
7. Charts
- Creating an embedded chart in a Worksheet
- Moving & Sizing an embedded chart
- Modifying your Chart quickly and easily
Excel Level 3
Excel Advanced. Learn about Auditing your work, Concatenate, protecting data, Pivot tables and more.
Take Our Assessment
1.Conditional Formatting
- Data Bars & Color Scales
- Coloring cells based on numbers or words
- Creating your own rules
2. Pivot Tables
- Data Bars & Color Scales
- Coloring cells based on numbers or words
- Creating your own rules
3. Working with Text
- Concatenate
- Removing duplicates
- TRIM Function
- PROPER Function
- AND Function
4. Auditing Worksheets
- Locating Precedent and Dependant Cells
- Tracing Precedents and Dependants
- Removing Auditing Arrows
5. Using Basic Analysis Tools
- Performing “What If” analysis using Goal Seek
- Working with Scenarios
- Having Excel analyze your data for you
6. Options when Saving
- Password Protect your Worksheet
- Define Protected area in your Spreadsheet
Does Your Team Need Excel?
Do you have a group that needs to master Excel? Maybe they have some experience, but it is mostly self-taught?
Book a time to have an Excel Strategy Call, click button below.
Let’s Chat!
error: Content is protected !!
Call Now Button
