Microsoft Excel : Advance Formulas And Functions

About Course

Cultivate a strong foundation in Microsoft Excel with HoloGrad’s comprehensive Fundamentals of Excel course. Designed for learners of all levels, this course provides a detailed exploration of Excel’s key features and functionalities.

Throughout the course, you’ll embark on an immersive journey through Excel’s interface, mastering essential navigation techniques to efficiently move around workbooks and sheets. You’ll learn how to enter and manipulate data with precision, leveraging formatting tools to enhance readability and presentation.

As you progress, you’ll delve into the world of formulas and functions, discovering how to perform basic calculations, manipulate text, and manage dates and times effectively. Through hands-on exercises and practical examples, you’ll gain proficiency in using common functions such as SUM, AVERAGE, and IF statements,Pivot Table, empowering you to analyze data and derive meaningful insights.

Additionally, the course covers fundamental spreadsheet management techniques, including organizing data into tables, sorting and filtering information, and creating basic charts and graphs for visual representation.

By the end of the course, you’ll emerge with a solid understanding of Excel’s fundamental concepts and capabilities, equipped with the skills to tackle various data-related tasks with confidence and efficiency. Whether you’re a novice seeking to build a strong foundation or a seasoned user aiming to refresh your skills, HoloGrad’s Fundamentals of Excel course provides the ideal pathway to Excel mastery.

Course Content

Microsoft Excel : Advance Formulas And Functions

Introduction

00:44

Chapter 1 (Modifying Cell Formatting)
A)Merging cells B)Hiding and showing rows and columns C)Inserting and deleting rows and columns D)Setting column widths and row heights E)Using the Format Painter F)Creating and applying cell styles G)Applying number formats H)Working with worksheets and sheet tabs I)Inserting worksheets J)Deleting worksheets K)Moving or copying worksheets L)Renaming worksheets M)Applying coloring to worksheet tabs

Chapter 2 (Sorting and filtering data)
A)Finding and Replacing data B)Sorting Ascending or Descending C)Filtering data D)Defining a filter E)Applying a filter F)Removing a filter G)Applying conditional formatting H)Icon sets, data bars, and color scales

Chapter 3 (Setting Print Options)
A)Adjusting breaks in the worksheet B)Inserting manual breaks into the worksheet C)Constructing headers and footers D)Setting the header and footer distance E)Setting the worksheet orientation F)Setting the worksheet scale G)Checking the paper size H)Setting page margins I)Aligning data horizontally and vertically J)Printing a single worksheet K)Printing selected worksheets

Chapter 4 (Creating charts based on worksheet data)
A)tPlotting non-contiguous data B)tSelecting a chart C)tResizing a chart D)tChanging chart placement E)tChanging the chart type F)tChanging the chart style G)tChanging the Quick Layout H)tChanging chart elements manually I)tChanging the chart and axis titles J)tDisplaying gridlines K)tDisplaying the legend L)tAdding data labels M)tAdding a data table N)tDeleting a data series O)tAdding a data series P)tChanging the chart scale Q)tFormatting the chart background R)tAdding objects to a chart S)tUsing the sunburst chart type T)tUsing funnel charts

Chapter 5 (Applying Formulas and Functions)
A)Technical requirements B)Learning basic formula operations C)Order of evaluation

Chapter 6 (Constructing a formula)
A)Learning Excel functions B)Using the Show Formulas command C)Converting values and percentage increase D)Working out the percentage change E)Working out a percentage increase or decrease F)Getting results using the status bar

Chapter 7 (Analyzing and Organizing Data)
A)tTechnical requirements B)tConsolidating data and investigating macros C)tCreating a summary sheet D)tCreating a macro E)tAdding a macro to the ribbon for easy access F)tRemoving a macro from the personal macro workbook

Chapter 8 (Using the Function Library)
A)tUsing the formula composer (Insert Function icon) B)tEditing formulas C)tUnderstanding relative versus absolute D)tApplying dates in calculations E)tUsing mathematical functions F)tThe INT and ROUND functions G)tThe ROUNDUP and ROUNDDOWN functions H)tThe SUMIF function I)tUsing the COUNTIF statistical function J)tUsing financial functions u2013 PMT K)tApplying conditional logic in a formula L)tThe IF function M)tThe AND function N)tThe OR function

Chapter 9 (Using text functions)
A)tThe CONCAT function B)tThe TRIM function C)tInvestigating formula errors D)tApplying named ranges in a formula E)tDefining a named range F)tNaming a range of cells G)tEditing a named range H)tCreating a named range from selected cells I)tUsing range names in a formula

Chapter 10 (Creating and managing PivotTables and PivotCharts)
A)tCreating a PivotTable B)tAdding PivotTable fields C)tGrouping with PivotTables D)tUsing slicers and timelines E)tCreating a PivotChart in Excel F)tWorking with the 3D Maps feature G)tUsing tools for analysis in Excel H)tAnalysis ToolPak I)tWhat-if analysis J)tUnderstanding data models

Chapter 11 (Common Tasks:Exporting and Optimizing Files and the Browser View)
A)tTechnical requirements B)tExporting files by changing the file type C)tExporting a file as a previous version D)tChecking the compatibility mode of a file E)tConverting a file using compatibility mode F)tExporting a file in .csv format (Excel only) G)tExporting files as a PDF H)tExporting slides as image files (PowerPoint only) I)tExporting presentations as a video (PowerPoint only) J)tPackaging a presentation for transfer K)tDocument properties (metadata) L)tInspecting a file M)tPackaging a presentation (PowerPoint only) N)tSending handouts from PowerPoint to Word O)tOptimizing and compressing media in PowerPoint P)tInvestigating the browser view options (Excel only)

Quiz

Add this certificate to your resume to demonstrate your skills & increase your chances of getting noticed.

About Course

Course Content

Microsoft Excel : Advance Formulas And Functions

Introduction

Start With Lesson 1

Chapter 2 (Sorting and filtering data)
A)Finding and Replacing data B)Sorting Ascending or Descending C)Filtering data D)Defining a filter E)Applying a filter F)Removing a filter G)Applying conditional formatting H)Icon sets, data bars, and color scales

Start With Lesson 2

Start With Lesson 3

Start With Lesson 4

Chapter 5 (Applying Formulas and Functions)
A)Technical requirements B)Learning basic formula operations C)Order of evaluation

Start With Lesson 5

Chapter 6 (Constructing a formula)
A)Learning Excel functions B)Using the Show Formulas command C)Converting values and percentage increase D)Working out the percentage change E)Working out a percentage increase or decrease F)Getting results using the status bar

Start With Lesson 6

Chapter 7 (Analyzing and Organizing Data)
A)tTechnical requirements B)tConsolidating data and investigating macros C)tCreating a summary sheet D)tCreating a macro E)tAdding a macro to the ribbon for easy access F)tRemoving a macro from the personal macro workbook

Start With Lesson 7

Start With Lesson 8 [Part 1]

Start With Lesson 8 [Part 2]

Start With Lesson 9

Start With Lesson 10

Start With Lesson 11

Quiz

Microsoft Excel : Advance Formulas And Functions

Earn a certificate

Categories

Lists

Company

About Course

Course Content

Microsoft Excel : Advance Formulas And Functions

Introduction

Start With Lesson 1

Chapter 2 (Sorting and filtering data) A)Finding and Replacing data B)Sorting Ascending or Descending C)Filtering data D)Defining a filter E)Applying a filter F)Removing a filter G)Applying conditional formatting H)Icon sets, data bars, and color scales

Start With Lesson 2

Start With Lesson 3

Start With Lesson 4

Chapter 5 (Applying Formulas and Functions) A)Technical requirements B)Learning basic formula operations C)Order of evaluation

Start With Lesson 5

Chapter 6 (Constructing a formula) A)Learning Excel functions B)Using the Show Formulas command C)Converting values and percentage increase D)Working out the percentage change E)Working out a percentage increase or decrease F)Getting results using the status bar

Start With Lesson 6

Chapter 7 (Analyzing and Organizing Data) A)tTechnical requirements B)tConsolidating data and investigating macros C)tCreating a summary sheet D)tCreating a macro E)tAdding a macro to the ribbon for easy access F)tRemoving a macro from the personal macro workbook

Start With Lesson 7

Start With Lesson 8 [Part 1]

Start With Lesson 8 [Part 2]

Start With Lesson 9

Start With Lesson 10

Start With Lesson 11

Quiz

Microsoft Excel : Advance Formulas And Functions

Earn a certificate

Student Ratings & Reviews

Categories

Lists

Company

Login with your site account

Register a new account

Chapter 2 (Sorting and filtering data)
A)Finding and Replacing data B)Sorting Ascending or Descending C)Filtering data D)Defining a filter E)Applying a filter F)Removing a filter G)Applying conditional formatting H)Icon sets, data bars, and color scales

Chapter 5 (Applying Formulas and Functions)
A)Technical requirements B)Learning basic formula operations C)Order of evaluation

Chapter 6 (Constructing a formula)
A)Learning Excel functions B)Using the Show Formulas command C)Converting values and percentage increase D)Working out the percentage change E)Working out a percentage increase or decrease F)Getting results using the status bar

Chapter 7 (Analyzing and Organizing Data)
A)tTechnical requirements B)tConsolidating data and investigating macros C)tCreating a summary sheet D)tCreating a macro E)tAdding a macro to the ribbon for easy access F)tRemoving a macro from the personal macro workbook