PURPOSE
Unlock the full potential of Microsoft Excel with our Intermediate Excel Online Course! This comprehensive training program is designed to take your spreadsheet skills to the next level and equip you with valuable tools and techniques to excel personally and professionally. Learn how to use Excel using our online course. An Excel spreadsheet is a powerful tool for data organisation and analysis, offering a structured and efficient way to manage information. With its user-friendly interface and versatile features, Excel enables users to create dynamic and visually appealing spreadsheets.
COURSE CONTENT
Unit 1: Calculating data with advanced formulas
- Applying cell and range names
- Naming ranges automatically
- Using specialised functions
- Fixed referencing
Unit 2: Organising worksheets and table data
- Sorting and filtering data
- Creating and modifying tables
Unit 3: Presenting data using charts
- Creating a chart
- Modifying charts
- Adding data to charts
Unit 4: Simplistic
- MIN, MAX and Average
- COUNT, COUNTA and COUNTBLANK
- Rounding
Unit 5: Inserting graphic objects
- Inserting graphic objects
- Drawing and modifying shapes
- Illustrating workflow using SmartArt graphics
- Adding a background
Unit 6: Custom formatting
- Custom format numbers, date, etc.
Unit 7: Other functions
- Watch window options
- Text to columns
- Subtotal function
- Protection
- Setting up calculations
- Types of errors
- Breaking links
- Data validation
- Hyperlink
Unit 8: Dates
- Working with dates and time
- Dynamic dates and TODAY and NOW functions
Unit 9: Formatting functions
- Conditional formatting
- Format painter
- Paste special
Unit 10: Reporting formula
- Pivot tables
- Counting using pivot tables and drilling down into detail
- Updating a pivot table with new data and adding multiple values
- Using calculated fields in pivot tables
- Removing or hiding subtotals, grand totals and filling blanks
Unit 11: Google sheet
- Google sheets
DELIVERY
Duration: 1 Day
Delivery: Classroom/Online
ACCREDITATION
5 Day Courses: Participants will receive a SpecCon Holdings certificate upon completion of all courses.
1 Day Courses: Participants will receive a SpecCon Holdings certificate upon completion of this course.
HOW TO USE EXCEL SPREADSHEET
Here is a step-by-step guide on how to use Excel
- Opening Excel
- Creating a New Workbook
- Entering Data
- Formatiting Cells
- Working with Rows and Columns
- Formulas and Functions
- Charts and Graphs
- Sorting and Filtering
- Data Validation
- Conditional Formatting
- PivotTables
- Protecting Worksheets
- Saving and Printing
OUR MOST POPULAR CATEGORIES
